FreeServerResources isn't officially "supported". It's just there and I need
yet to make sure I code it in a way that people won't be able to abuse it in
some way.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Michael L. Horne" <guardian@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 14, 2001 12:38 PM
Subject: RE: [IBO] More than one Lookup combo to one dataset


> Hello Jason,
>
> So, just to make sure I understand what to do, I
> could code something like
>
> procedure TformAPVendor.FormShow(Sender: TObject);
> const FirstTime:Boolean = True;
> begin
> if (FirstTime) then
> begin
> FirstTime := False;
> qyIbCombo1.Open; // AutoFetchAll=True on this query
> qyIBCombo1.FreeServerResources;
> qyIbCombo2.Open; // AutoFetchAll=True on this query
> qyIBCombo2.FreeServerResources;
> end;
> end;
>
> I assume that I would NOT close the querys until the
> program exits!
>
> And this would load the information from the file the
> first time the form is shown. The only problem I see
> with this is that each Querys would still have to be
> prepared and each would have to return the same data.
> Even though they are the same.
>
> Well I can live with that. -- :) I guess.
>
> By the way, doesn't appear to be any help in the help
> file about "FreeServerResources". :(
>
> Thanks
> Michael L. Horne
>
>
> > -----Original Message-----
> > From: Jason Wharton [mailto:jwharton@...]
> > Sent: Wednesday, March 14, 2001 2:00 PM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] More than one Lookup combo to one dataset
> >
> >
> > Michael,
> >
> > There is no advantage of this over simply using a separate dataset. One
> > thing that you can do is fetch all the rows and then call
> > FreeServerResources. What this does is release the statement
> > handle that the
> > dataset holds. This makes it purely a client container for rows in
memory
> > from the server.