OpenEuphoria

Re: ODBC - MySQL Commit Error

• Posted by Rad <radhx at rediffmail.com> Nov 11, 2005
• 478 views

Hi,

The parameter for commit is "atom handle", I assumed it will be the statement
handle used for executing update statement.
(tried with odbc-handle too, but got same result).

Further on the same topic, if I create a separate commit_handle by
prepareSQL(odbc_handle,"Commit;")
and use it afterwords with executeSQL(commit_handle) instead of
commit(odbc_handle) of ODBC.e,
the commit works fine.

Can anybody explain me what I am doing wrong with ODBC commit() ??
How to call commit() or rollback() using ODBC.e?

Regards,
Rad.