You can set the Filter property and set Filtered to true. This will resolve
to SQL on the server.
You can use the SQLWherre property too. If you do, make sure to include the
WHERE token at the first of whatever you put in there.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Daniel Bertin" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 19, 2001 10:36 AM
Subject: [IBO] SQL


> Hi all
>
> How can I do a SQL in a IBOTable?
>
> I want to limit the records retrieved from the database.
>
> select * from disp_leg
> where complete = 'N'
>
> there is a SQLWhere property??
>
> thanks
> Daniel