David Johnson wrote:

> Try this rework (sorry about any syntax errors - It's been over a year
> since I did any object pascal).
>
> This should be faster since there is only one prepare (on formCreate),
> and less wire traffic.
>
> I would look at limiting the transaction length too, unless your
> installation is very small.
>
> onFormCreate:
>
> with qGuests do
> sql.add('select * from Guests');
> sql.add('where auctionID=:AuctionID and
> constituentID=:ConstituentID');
> prepare;
> end;
>
> onRunQuery:
>
> with qGuests do
> close;
> params.clear;
> params['AuctionID'] := qAuction.fieldbyname('AuctionID').asstring;
> params['ConstituentID'] :=qAuction.fieldbyname
> ('ConstituentID').asstring;
> open;
>
>
>
>
> On Thu, 2005-08-11 at 17:07 -0700, Sam Hunt wrote:
> > with qGuests do
> > begin
> > close;
> > sql.clear;
> > sql.add('select * from Guests');
> > sql.add('where
> > auctionID='+#39+qAuction.fieldbyname('AuctionID').asstring+#39+' ');
> > sql.add('and
> > constituentID='+#39+qConstituents.fieldbyname
> > ('constituentID').asstring+#39+'
> > ');
> > open;
> > end;
>

thanks.

Sam Hunt