[freetds] DBlib dbsqlexec question (chaining sql statements)
Patrick Dunnigan
patrick.dunnigan at centivia.com
Thu Jun 23 17:11:28 EDT 2005
Hi,
Have two (maybe more) sql statements that I'd like to run. I am wondering if I can execute them at the same time. Example:
Now:
int i = 1;
int j = 3;
dbfcmd(dbproc,"delete from sss where col1 = %d",i);
dbsqlexec(dbproc);
dbresults(dbproc);
dbfcmd(dbproc,"delete from zzz where col1 = %d",j);
dbsqlexec(dbproc);
dbresults(dbproc);
I'd like to do:
dbfcmd(dbproc,"delete from sss where col1 = %d\n",i);
dbfcmd(dbproc,"delete from zzz where col1 = %d",j);
dbsqlexec(dbproc);
dbresults(dbproc);
Is there a command seperator that I put after the newline and / or how many times to I have to call dbsqlexec or dbresults? Would this save roundtrips to the database or is the method the way to go?
Thanks
More information about the FreeTDS
mailing list