[DUG] ADOTable filter expressions

[Alan Rose]

The operator has to be on of the following for this ado filter
 <, >, <=, >=, <>, =, or LIKE

So its (unitno = 3) or (unitno = 4) in this example


> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz 
> [mailto:delphi-bounces at ns3.123.co.nz] On Behalf Of Phil Scadden
> Sent: Thursday, 25 May 2006 1:23 p.m.
> To: delphi at ns3.123.co.nz
> Subject: [DUG] ADOTable filter expressions
> 
> If I apply a filter like:
> '[UNITNO]  in (3,4)'
> to an ADOTABLE.filter, I get TOleException, "Arguments are of 
> the wrong type, out of range or in comflict with one 
> another". Expression is fine on the underlying database. What 
> am I doing wrong with syntax here? UNITNO is of long Integer 
> type in the table.
> 
> ----------------------------------------------------------
> Phil Scadden, Institute of Geological and Nuclear Sciences
> 764 Cumberland St, Private Bag 1930, Dunedin, New Zealand Ph 
> +64 3 4799663, fax +64 3 477 5232
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>