Filter and IndexName are totally independent. You can mix and match here as
you please.

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

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


>
> You are absolutely correct, in my panic mode, I had not gone through the
> regular trouble shooting steps properly. I was doing the same thing, my
> users do to me, when they say the software doesn't work, and dont explain
> where the problem is coming from.
>
> Thanks I'll definetely keep this in mind next time.
>
> But how does the indexname property, in IBOTable, relate with the filter
> property? or does it at all. Can I not have a filter without a indexname?
>
> with no indexname, the first record of the filtered records would not
> display.(after it had been inserted and posted, and the filtering field
set.
>
> in this case
> complete = 'N'
>
> Thanks
> Daniel
>
>
> At 10:29 AM 28/05/2001 -0700, you wrote:
> >What I want is some concrete information that I can draw conclusions
from.
> >Convey facts and avoid ambiguous terms.
> >This will require you to spend more time on your end isolating things but
it
> >sure helps the rest of us help you.
> >The SQL trace monitor is the "tell all". If you say something like:
> >
> >I did exactly this in the properties and when I prepared my statements
this
> >is what was in the SQL trace going to the server... We can draw some
> >conclusions.
> >
> >I think 9 times out of 10 you will simply solve your own troubles too.
> >
> >Regards,
> >Jason Wharton
> >CPS - Mesa AZ
> >http://www.ibobjects.com
> >
> >
> >----- Original Message -----
> >From: "Daniel Bertin" <daniel@...>
> >To: <IBObjects@yahoogroups.com>
> >Sent: Monday, May 28, 2001 10:28 AM
> >Subject: Re: [IBO] IBOTable filter help
> >
> >
> > >
> > > so sorry about my english I meant the records appeared in the grid,
> >filtered.
> > >
> > > I'm still learning the english language's subtleties
> > >
> > > thanks
> > > Daniel
> > >
> > >
> > > At 10:10 AM 28/05/2001 -0700, you wrote:
> > > >Please use details. "appeared filtered" is nearly useless to us.
> > > >
> > > >Look in the SQL trace monitor to see what is happening and report
> >details.
> > > >
> > > >Jason Wharton
> > > >CPS - Mesa AZ
> > > >http://www.ibobjects.com
> > > >
> > > >
> > > >----- Original Message -----
> > > >From: "Daniel Bertin" <daniel@...>
> > > >To: <IBObjects@yahoogroups.com>
> > > >Sent: Monday, May 28, 2001 10:10 AM
> > > >Subject: Re: [IBO] IBOTable filter help
> > > >
> > > >
> > > > > I set indexname property in IBOTable, to an IB index and the
record
> > > > > appeared filtered.
> > > > >
> > > > > how is this related to filter property?
> > > > >
> > > > > Thanks
> > > > > Daniel
> > > > >
> > > > >
> > > > > At 10:00 AM 28/05/2001 -0700, you wrote:
> > > > > >Watch what the SQL trace monitor says is sent to the server. This
> >should
> > > > > >help quite a bit.
> > > > > >
> > > > > >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:26 AM
> > > > > >Subject: [IBO] IBOTable filter help
> > > > > >
> > > > > >
> > > > > > > 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
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > 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/
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 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/
> > >
> > >
> > >
> > >
> > >
> > > 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/
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>