Subject Re: [IBO] Why fetch all the records
Author Jason Wharton
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/
>
>