If I set a tsqlstatement like this:
with sqlstmt
do begin
sql.clear;
sql.add ('insert into mytable (col1, col2) values (:col1, :col2);');
execute;
end;
If later I use the same sqlstmt like this:
with sqlstmt
do begin
sql.clear;
sql.add ('delete from myothertable where id = :id;');
execute;
end;
If I come back to the code for the insert my params.count is now 3.
When the sql.clear is executed I would assume the params would also
clear. But this does not seem to be the case.
I found a params.clear which I can use. But it would seem that if the
sql statement is cleared then shouldn't the params be cleared as well?
What is the thinking behind making it a separate call?
--
Patrick Goupell
Income taxes? See this http://www.truthattack.org or this
http://www.whatistaxed.com
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
mseide-msegui-talk mailing list
mseide-msegui-talk@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
