Kbase P64770: Is it possible to link static browse to a dynamic query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/07/2004 |
|
Status: Unverified
GOAL:
Is it possible to link static browse to a dynamic query ?
FIX:
Yes, it is possible to link a static browse to a dynamic query. Simply set the QUERY attribute of the browse to the handle of the dynamic query.
See the code below:
DEF VAR hQuery AS HANDLE NO-UNDO.
DEF VAR hBuffer AS HANDLE NO-UNDO.
DEF VAR hColumn1 AS HANDLE NO-UNDO.
hBrowse = BROWSE-1:HANDLE.
/* assuming BROWSE-1 to be the static browse*/
CREATE QUERY hQuery.
CREATE BUFFER hBuffer FOR TABLE "customer" .
hQuery:SET-BUFFERS(hBuffer).
hQuery:QUERY-PREPARE("for each customer no-lock").
hBrowse:QUERY = hQuery.
hColumn1 = hBrowse:ADD-LIKE-COLUMN("customer.custnum").
hBrowse:ADD-LIKE-COLUMN("customer.name").
hColumn1:WIDTH = 5.
hBrowse:SENSITIVE = YES.
hQuery:QUERY-OPEN().