MySQL only supports transactions for table type innoDB. Are you sure that the tables you wish to rollback are this type?
The sql command 'show table status' will list tables and show their types.Regards
> Message Received: Sep 19 2005, 02:27 PM> From: "Figueiredo" > To: [hidden email]> Cc: > Subject: [Gambas-user] DB Transaction (MYSQL)> >
I'm trying to use "db.begin" with mysql database and it doesn't work, is this feature ok ? Please if someone have any tips....
In fact i need to recovery the id of an autoincrement field and I'm using the last_insert_id() in a transaction Insert, an i have no success, not yet.
thank you all