that's exactly what I figured, then why with

IBOTable filter property set to

complete = 'N'
filtered = true

set the current record field complete = 'Y'
insert a new record
assign complete := 'N'
post the record
display the grid and neither records (which happened to be the first
filtered record of the table.) were there.
If I would continue this with the first filtered record from the table,
they would not display. even if they were in the table.
when I added the indexname property this went away and the procedure acted
as expected.

Daniel





At 10:49 AM 28/05/2001 -0700, you wrote:

>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/
> >
> >
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/