Just put it in there doubled. This is a Delphi question.

Filter := 'complete = ''N''';

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

----- Original Message -----
From: "Daniel Bertin" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, May 28, 2001 9:57 AM
Subject: Re: [IBO] IBOTable filter help


How do you put a quotedstr in the filter property?

filter property = complete = 'N'

Daniel


At 02:29 AM 29/05/2001 +1000, you wrote:
>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
>_______________________________________________________
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/