Error message Row cannot be located for updating

2007-03-20 Thread Jonathan Trahair
- Original Message - From: Jonathan Trahair To: MySQL General Sent: Monday, March 19, 2007 11:10 AM Subject: Error message Row cannot be located for updating Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a large order (25

Error message Row cannot be located for updating

2007-03-19 Thread Jonathan Trahair
orders it will not be the same item, colour or row number as other orders. I've been onto Google and found some stuff about Option=2 but that didn't make any difference. Can anyone shed light on this dark area? Thanks in advance. Jonathan Trahair

Error message Row cannot be located for updating

2007-03-19 Thread Jonathan Trahair
I should add, of course all the other items (re-)save perfectly, there is nothing about that actual record which is different. MySQL 5.0.27 WinXP Set mconn = New ADODB.Connection mconn.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; SERVER= mstrServerName ; DATABASE= mstrThisDatabase

Network traffic with MySQL

2007-03-15 Thread Jonathan Trahair
is Option = 3 in mconn.ConnectionString? Thanks in advance Jonathan Trahair

Speed of queries in a MySQL database

2007-03-04 Thread Jonathan Trahair
. Is this the right list for such questions? Thanks in advance. Jonathan Trahair