MySQL Forums
Forum List  »  MySQL for Excel

Re: Failure to update database
Posted by: Javier Treviño
Date: March 04, 2014 04:41PM

Can you post an example of the generated SQL statements here for review?
Can you re-try also after turning off optimistic updates? To turn it off just right-click on an area of the Edit dialog where buttons are not present and in the pop-up context menu turn off that option.

The "long" generated SQL statements are OK since for optimistic updates the generated WHERE clause must include all columns in the table.

Cheers.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
4187
February 27, 2014 11:42AM
1723
February 27, 2014 01:21PM
1628
March 03, 2014 04:13PM
1747
March 03, 2014 04:10PM
1380
March 03, 2014 05:13PM
Re: Failure to update database
1477
March 04, 2014 04:41PM
1871
March 04, 2014 05:15PM
1497
March 05, 2014 12:41PM
1607
March 14, 2014 11:12AM
1454
March 14, 2014 07:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.