da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: How do I use OCIFilters?

Forum List » NCOCI8 » General English

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

How do I use OCIFilters?

Posted: 2000/09/19 11:33

Didn't find anything about using filters. Dmitry, could you write small how-to on this issue?
Especially I wonder, can I have parameters (or at least macros) in filter and how multiple filters are joined - uzing OR or AND?

Diman

Admin

Posts: 1495

Karma: 19

RE: How do I use OCIFilters?

Posted: 2000/09/20 18:13

Hi !

Okey ... In most filters works the same way as in TQuery. But, differences are:
- TOCIQuery can have multiple filters, and they will be joined by AND. Filter has a Name property, so you can get access to filter using FilterByName/FindFilter call of TOCIFilters.
- Filters supports Oracle SQL expression language. Exceptions: you cant use subqueries, converting routines (to_char, to_number, ...) are using NOT a Oracle format string syntax, but Delphi

Filters does not support parameters and macroses.

Forum List » NCOCI8 » General English