I am new to transactions in mySql I am using Visual Basic to access a mySql database. I had seen somewhere that to use transactions through ODBC you have to send the commit and rollback commands like a select statement. But even when I send the begin work before my other statements, the commit is till done even if I issue a rollback statement. I can be able to use transactions when working from the mysql command prompt. But I want to use the same in Visual Basic to be able to prevent saving when halfway through my statements. I have put a set autocommit=0 at the start of my code. But still nothing doing
Someone give me some sample VB code to connect to mySql and use transactions Thanx a heap Harrison Njamba Somak Travel Limited P.O. Box 48495 Tel 535509 / 0733-923214 Nairobi Kenya ____________________________________________________________________ - This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error you may not disclose, copy, distribute or act upon its contents without the authors prior written consent. Please can you notify the system manager at [EMAIL PROTECTED] immediately and delete this email. - Any views or opinions expressed are those of the author and do not necessarily represent those of Somak Travel Limited, Kenya. - This footnote also confirms that this email message has been swept for the presence of computer viruses. No responsibility can be accepted in the event that a virus is contained within it or any attachments. - SOMAK TRAVEL LTD - KENYA NAIROBI, PO BOX 48495. Tel: +(2542) 557832 Fax:+(2542) 535175 MOMBASA, PO BOX 90738. Tel: +(25411)486197 Fax:+(25411)487324 ____________________________________________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php