Subject | Re: [IBO] Save a query satus |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-01-18T14:01:26Z |
> I wan't to save the status of an IBOQuery (SQL, Params) and want toI think you will find that you do not need to save the
> reload it later.
>
> For saving I use
>
> VAR SaveParams : TParams;
> :
>
> WITH Query1 DO BEGIN
> SaveSQL:=SQL.Text;
> SaveParams:=TParams.Create; SaveParams.Assign(Params);
> END;
>
> for loading I use
>
> WITH Query1 DO BEGIN
> Close;
> SQL.Text:=SaveSQL;
> Params.Clear;
> Params.AssignValues(SaveParams); SaveParams.Free;
> Open;
> END;
params at all.
IBO will rebuild then when you prepare the SQL.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services