Kbase P134212: How to filter or reposition a query in GUI for .NET
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/12/2011 |
|
Status: Verified
GOAL:
How to filter or reposition a query in GUI for .NET
GOAL:
How to filter the query for a proBindingSource
GOAL:
How to reposition the query for a ProBindingSource
FACT(s) (Environment):
Windows 32 Intel
OpenEdge 10.2x
FIX:
The proBindingSource is usually bound to either a query for a ABL Temp-Table or to a proDataSet object. To filter or reposition the query for the proBindingSource you should manipulate either the temp-table query associated with the proBindingSource, or the TOP-NAV-QUERY of the DATASET object.
For example:
hQuery = THIS-OBJECT:bindingsource1:HANDLE. /* Temp-Table Query example */
or...
hQuery = THIS-OBJECT:bindingsource1:HANDLE:TOP-NAV-QUERY. /* proDataSet example */
/* Filter the query */
hQuery:QUERY-PREPARE(cFilterString).
hQuery:QUERY-OPEN().
or...
/* Reposition the query */
hBuffer = hQuery:GET-BUFFER-HANDLE(1).
CREATE BUFFER hBuffer2 FOR hBuffer.
hBuffer2:FIND-FIRST(cFilterString,NO-LOCK) NO-ERROR.
IF hBuffer2:AVAILABLE THEN
hQuery:REPOSITION-TO-ROWID(hBuffer2:ROWID).