Subject | Re[2]: [firebird-support] Prepare of SQL |
---|---|
Author | Nando Dessena |
Post date | 2003-07-24T15:10:11Z |
Valdir,
VSJ> And if i execute a prepare statement for
VSJ> select * from sometable where id = :id
VSJ> then execute
VSJ> SeLeCt * from sometable where id = :id
VSJ> it will make any difference?
if you prepare a statement then you are not allowed to change the
statement text anymore (or better, if you do you are actually creating
another statement). So you prepare a statement, send the params (and
the params only) one or more times, and when you are finisched
unprepare the statement.
Ciao
--
Nando mailto:nandod@...
VSJ> And if i execute a prepare statement for
VSJ> select * from sometable where id = :id
VSJ> then execute
VSJ> SeLeCt * from sometable where id = :id
VSJ> it will make any difference?
if you prepare a statement then you are not allowed to change the
statement text anymore (or better, if you do you are actually creating
another statement). So you prepare a statement, send the params (and
the params only) one or more times, and when you are finisched
unprepare the statement.
Ciao
--
Nando mailto:nandod@...