Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Query params count |
Fri, Nov 1 2013 2:27 PM | Permanent Link |
dmitryl | 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 |
Fri, Nov 1 2013 2:58 PM | Permanent Link |
dmitryl | 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 |
Mon, Nov 4 2013 9:47 AM | Permanent Link |
Matthew Jones | There are two queries/statements there so I presume it is picking up only the first
for the count. /Matthew Jones/ |
Mon, Nov 4 2013 12:42 PM | Permanent Link |
Raul Team Elevate | 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/ > |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |