BorlandTalk.com

miroo · Guest

Hello, I tried something like this: on empty form I put an object of TADOQuery class(Query1) and objects of these classes: TDataSource (to connect the Query1), TSDBGrid (to show results), TButton (to fire an action) and wanted to use a Filter property of the Query1 object. So I put a text like this in that property - ' ( ( curr_code = ''USD'' ) or ( curr_code = ''SKK'') ) and ( some_string_field = ''V'' ) ' and set the Filtered property to TRUE. Then I tried to open the query, but Calling Query1.Open procedure raised an exception of EOleException class with this message - 'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another'. I want to ensure you that all the fields were present in the table and data type of every field is String. However, and it's interesting, when I changed operator OR to AND, everything worked fine. So, if there's a more complicated expresion(like combination of AND and OR operators), it causes an error. As an underlying database was used MSSQL server 8 (9). Ado version is 2.8 SP1. Any idea? Please help.

Viatcheslav V. Vassiliev · Guest

From description of Filtered property (ADO recordset):

There is no precedence between AND and OR. Clauses can be grouped within
parentheses. However, you cannot group clauses joined by an OR and then join
the group to another clause with an AND, like this:

(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'

Instead, you would construct this filter as

(LastName = 'Smith' AND FirstName = 'John') OR (LastName = 'Jones' AND
FirstName = 'John')

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"miroo" <sunlite (AT) pobox (DOT) sk> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:44918b27$1 (AT) newsgroups (DOT) borland.com...