Why params.count return 1, if actual params - 2?

 DBISAMQuery1.SQL.Text := 'DELETE FROM item WHERE id = :id DELETE FROM link WHERE parent_id = rent_id;';
 DBISAMQuery1.Prepare;
 ShowMessage(IntToStr(DBISAMQuery1.Params.Count)); // return - 1

dmitryl wrote:

Why params.count return 1, if actual params - 2?

 DBISAMQuery1.SQL.Text := 'DELETE FROM item WHERE id = :id; DELETE FROM link WHERE parent_id = rent_id;';
 DBISAMQuery1.Prepare;
 ShowMessage(IntToStr(DBISAMQuery1.Params.Count)); // return - 1

There are two queries/statements there so I presume it is picking up only the first
for the count.


/Matthew Jones/

Exactly and one has to use the OPnGetParams event to use multiple
parameters in this case.

Manual has details (under Parameters and Multiple SQL Statements section) :

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphi&version=2007&topic=Parameterized_Queries

Raul

On 11/4/2013 9:47 AM, (Matthew Jones) wrote:
> There are two queries/statements there so I presume it is picking up only the first
> for the count.
>
>
> /Matthew Jones/
>