RE: [DUG]: Query Parameters

[Stacey Verner]

> SQL.Text := QRY_InsertSomething;
> Prepare;
> while not LQuery2.EOF do begin
>      // Set up parameters;
>      ParamByName['p_new_cell_id'].AsString := '1';
>      ParamByName['p_to_id'].AsString := '13';
>      ParamByName['p_cell_id'].AsString :=
>          LQuery2.FieldByName('cell_id').AsString;
>     ExecSQL;
>     LQuery2.Next;
> end;
> Unprepare;
> 
> That's only 1 prepare...

That is exactly what I want to do, but the query cannot be prepared if it
has something like

select :param, field
from table

which this does.

Stacey



---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"