At 09:26 AM 28-05-01 -0700, you wrote:

>Hi all
>
>I'm using an IBOTable with an IB6 database.
>
>in this table I have 2 records one containing field complete = 'Y' and
>another record field complete = 'N'
>
>when I have no filter on it I see all the records.
>
>in the object inspector I set the filter property to
>filter = complete = 'N'
>filtered = true
>
>and run I see neither records (y or the n)
>Can someone help me and point to me what I'm missing, or does the filter
>need to be set at runtime also? I'm confused
>Thanks
>Daniel
>
>when I put in the properties
>
>filter = complete = 'N'
>filtered = true

Daniel,
the Filter property is a quoted string, see the Filter property in the Delphi VCL.

So you need:

Blah.Filter := QuotedStr('Complete = 'N');
Blah.Filtered := True;

Regards,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________