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