[Gambas-user] DB Transaction (MYSQL)

[nigel at ...38...]

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
Nigel
> Message Received: Sep 19 2005, 02:27 PM
> From: "Figueiredo" 
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: [Gambas-user] DB Transaction (MYSQL)
> 
> 
Hi,

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


Paulo Figueiredo
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050920/4f932a20/attachment.html>