Last is teh problme in osme of them then. I suspect that the real culprit
is that the ibotable translates the indexname supplied to fields and the
select statement uses the fields rather than the index. I will have to
inspect the monitor logs and play with the plan some more :-)

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, 28 February 2001 15:07
Subject: Re: [IBO] Why fetch all the records


> Calling Last will cause all records to be fetched.
>
> SQL databases are not fixed width files that can mathematically calculate
a
> file pointer and move to the end of a table immediately. They are more
> complex than that.
>
> Hang in there though, I'm working on a solution for this in IBO v4.
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Rohit Gupta" <rohit@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, February 27, 2001 6:14 PM
> Subject: Re: [IBO] Why fetch all the records
>
>
> > No, not fetching RecordCount... would Last or First do this ?
> >
> > A solution is for me to somehow reduce the buffer size for selected
> tables.
> > Is this going to work ?
> >
> > ----- Original Message -----
> > From: "Jason Wharton" <jwharton@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, 28 February 2001 12:21
> > Subject: Re: [IBO] Why fetch all the records
> >
> >
> > > Ok. sorry. I should not have answered like I did.
> > >
> > > By default IBO doesn't fetch all the records. The only way it would is
> if
> > > something explicitly told it to do so. Are you accessing the
RecordCount
> > > property any? That might be causing this to happen.
> > >
> > > Have you tried tracing the code any to see what is going on?
> > >
> > > Without more details I don't think I can help specifically.
> > >
> > > HTH,
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com
> > >
> > >
> > > ----- Original Message -----
> > > From: "Rohit Gupta" <rohit@...>
> > > To: <IBObjects@yahoogroups.com>
> > > Sent: Tuesday, February 27, 2001 1:32 PM
> > > Subject: [IBO] Why fetch all the records
> > >
> > >
> > > > Jason,
> > > >
> > > > that doesnt answer teh question. WHy does the table do that.... it
> does
> > > not
> > > > make it compatible with TDataset. And If I knew I had to change all
> teh
> > > > forms I wouldnt have switched over.
> > > >
> > > > We do have extensive search capability, but this is the way our
> clients
> > > liek
> > > > things, they have for the last 15 years with DOS and CPM proggies.
> > > >
> > > > Since when does it become logical to change the app to suit the
> foibles
> > of
> > > > the tools ? :-)
> > > >
> > > > Anyhow, the problem still remains... its isnt just the main table.
> some
> > > > forms have 6/7 tables - the dratted thing fetches all records in
most
> > > > tables.
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Jason Wharton" <jwharton@...>
> > > > To: <IBObjects@yahoogroups.com>
> > > > Sent: Wednesday, 28 February 2001 05:21
> > > > Subject: Re: [IBO] Strange TFieldTypes
> > > >
> > > >
> > > > > > It would appear that when using TIBOTable on a form view, the
> beast
> > > > reads
> > > > > > all the records from the database.... this is silly. how do I
> stop
> > > it.
> > > > > > Some forms take minutes to open up as compared to sub-second
> > response
> > > > from
> > > > > > btrieve.
> > > > >
> > > > > When opening a form...
> > > > >
> > > > > Why show the user records they have not asked to see?
> > > > > Why force a user to navigate among records to find the record they
> are
> > > > > interested in?
> > > > >
> > > > > What works better is to use native IBO's search mode capabilities.
> > Have
> > > a
> > > > > search panel and a grid. Go into dssSearch mode and allow the user
> to
> > > > enter
> > > > > in simple search criteria for the record they want to see. Then
they
> > > post
> > > > > search mode and it will show them matching records only.
> > > > >
> > > > > Saves on bandwidth and user eye strain both.
> > > > >
> > > > > Jason Wharton
> > > > > CPS - Mesa AZ
> > > > > http://www.ibobjects.com
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > 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/
>
>