Please note that FILTERS are totally different from WHERE clause.
WHERE clause is used to read limited set of records/rows from the table on the server.
FILTER is used to filter records/rows already read into the memory of the client PC (our PC)
Filter clause does not know the field names in the main table. Filters operate on the field name ALIAS used in the query.
Filters behave the same way like ADO.
We request you to kindly read the documentation again to avoid such misunderstandings and loss of time.
In your above example:
DO NOT USE REQUERY()
OR, much better to use DBF syntax. We can also use parameterized filters.
Example:
WHERE clause is used to read limited set of records/rows from the table on the server.
FILTER is used to filter records/rows already read into the memory of the client PC (our PC)
Filter clause does not know the field names in the main table. Filters operate on the field name ALIAS used in the query.
Filters behave the same way like ADO.
We request you to kindly read the documentation again to avoid such misunderstandings and loss of time.
In your above example:
oQry:SetFilter( "A6 LIKE '%" + ALLTRIM( vGets[ 1 ] ) + "%'" )
oQry:GoTop()
XBROWSER oQryDO NOT USE REQUERY()
OR, much better to use DBF syntax. We can also use parameterized filters.
Example:
oQry:SetFilter( "? $ UPPER(A6)", { Upper( AllTrim( vGets[ 1 ] ) ) } )
oQry:GoTop()
XBROWSER oQry
// later
oQry:Refilter( { "ABC" } )
oQry:GoTop()
XBROWSER oQryRegards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
