aldrin wrote:
I tried using
query << sCommand.c_str();
only, but it doesn't work....and if I'll go with
query.execute();
only, then it won't work coz there's no command that would be queried....
do I need to use
query.update(x,x2);
query.execute();
instead of doing
query << sCommand.c_str();
query.execute();
?
Thanks!
-aldrin
Please read the manual.
Things are much simpler.
If you want to run query that returns a result set, you just do:
query << "SELECT ..."
or if it does not return result set:
query.execute("UPDATE...");
Sincerely,