Filtering Records

A filter can be applied to any query using a simple language. The filter statement is used both on the Reader and Lookups.

Examples

To retrieve just the match which are GBP the ‘OSQL Where Statement’ would be:

VENDORID = 20010

Query elements can be joined with an AND statement:

VENDORID = 20010 And ACCOUTNO = 10203