dating mistakes women do - Vb6 row cannot be located for updating


I'm working with Delphi (XE3) and need to connect to a My SQL database.

Some values may have been changed since it was last read." The same code was working with SQL 2000 !!! Please give us something more to work with, and I'm sure that someone will try to help...

But my code has such error: "vb6 error: Row cannot be located for updating.

Update() 'Error show up her End With End Sub End Module works as expected with both drivers on: - remote My SQL server 5.0.68pb-win32 - My ODBC 3.51.26 & 5.1.5 pre-release mysql select * from bug38147; ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- | Fld1 | Fld2 | Fld3 | Fld4 | Fld5 | Fld6 | Fld7 | Fld8 | Fld9 | totalconc | ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- | Primo | 2 | 3 | 4 | NULL | 6 | NULL | NULL | 9 | 12.5000 | ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- 1 row in set (0.00 sec) Change DSN to 3.51.26, update value back: mysql select * from bug38147; ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- | Fld1 | Fld2 | Fld3 | Fld4 | Fld5 | Fld6 | Fld7 | Fld8 | Fld9 | totalconc | ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- | Primo | 2 | 3 | 4 | NULL | 6 | NULL | NULL | 9 | 10.1000 | ------- ------ ------ ------ ------ ------ ------ ------ ------ ----------- 1 row in set (0.00 sec) mysql Server log: 080718 28 Query CREATE TABLE `bug38147` ( `Fld1` varchar(9) NOT NULL, `Fld2` smallint(5) DEFAULT NULL, `Fld3` tinyint(3) unsigned DEFAULT NULL, `Fld4` smallint(5) DEFAULT NULL, `Fld5` datetime DEFAULT NULL, `Fld6` varchar(10) DEFAULT NULL, `Fld7` datetime DEFAULT NULL, `Fld8` datetime DEFAULT NULL, `Fld9` varchar(7) DEFAULT NULL, `totalconc` decimal(19,4) DEFAULT NULL, PRIMARY KEY (`Fld1`) ) ENGINE=Inno DB DEFAULT CHARSET=latin1 28 Query insert into bug38147 values ("Primo", 2,3,4, NULL,"6", NULL, NULL,10.10) 080718 28 Query insert into bug38147 values ("Primo",2,3,4, NULL,"6", NULL, NULL,"9",10.10) 080718 29 Connect [email protected] on test 29 Query SET NAMES utf8 29 Query SET character_set_results = NULL 29 Query select database() 29 Query select database() 29 Query SELECT @@tx_isolation 29 Query SELECT * FROM bug38147 WHERE Fld1 = 'Primo' 29 Query UPDATE `test`.`bug38147` SET `totalconc`=12.5000 WHERE `Fld1`=_latin1'Primo' AND `totalconc`=10.1000 080718 29 Quit 080718 28 Query select * from bug38147 080718 30 Connect [email protected] on test 30 Query select database() 30 Query select database() 30 Query SELECT @@tx_isolation 30 Query SELECT * FROM bug38147 WHERE Fld1 = 'Primo' 30 Query UPDATE `test`.`bug38147` SET `totalconc`='10.1000' WHERE `Fld1`='Primo' AND `totalconc`='12.5000' 30 Quit 080718 28 Query select * from bug38147 Now, your logs are *unusable*! Another point; both of your logs show *successful* updates (yes yes, I took a look at 2x100000 lines...) but done via parameters which is not in accordance to your test case.

Please boil down your test case to something small and start logging *only* then so we get log of less than 50 lines please.

read a record - move data from record to the form - move data from form back to the record (without change) - Update record = error reards Rainer Rainer: 2.