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/