MySQL Forums
Forum List  »  Delphi

row could not be located for updating
Posted by: Angelin Lalev
Date: February 15, 2007 06:38PM

The exception 'row could not be located for updating' appears almost every
time I try to update some record in my program.

Table:

CREATE TABLE POTREBITELI (
ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
PSEVDONIM CHAR(12) NOT NULL,
IME CHAR(30) NOT NULL,
PRIVILEGII INTEGER UNSIGNED NOT NULL,
DOBAVEN_OT BIGINT UNSIGNED NULL,
DOBAVEN_DATA DATETIME NOT NULL,
AKTIVEN BIT NOT NULL,
DE_TIMESTAMP TIMESTAMP NULL,
DE_OPERATOR BIGINT UNSIGNED NOT NULL,
DE_VERSIJA DECIMAL(5,3) NOT NULL,
DE_HASH CHAR(25) NULL,
PRIMARY KEY(ID)
);

Server log:

070216 1:47:49 4 Query UPDATE `vive`.`potrebiteli` SET `IME`='asssaassj4hhjjj ',`PRIVILEGII`=1,`DE_OPERATOR`=0,`DE_VERSIJA`=.100 WHERE `ID`=1 AND `IME`='asssaassj4hhjjj' AND `PRIVILEGII`=2 AND `DE_OPERATOR`=0 AND `DE_VERSIJA`=.100
4 Query SELECT `ID`,`PSEVDONIM`,`IME`,`PRIVILEGII`,`DOBAVEN_OT`,`DOBAVEN_DATA`,`AKTIVEN`,`DE_TIMESTAMP`,`DE_OPERATOR`,`DE_VERSIJA`,`DE_HASH` FROM `vive`.`potrebiteli` WHERE `ID`=1


(Please, notice the strange spaces in the value for IME field on row 2)


ConnectionString:
Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=myodbc.vive;Extended Properties="DATABASE=vive;DSN=myodbc.vive;OPTION=0;PORT=0;SERVER=localhost;UID=root"

What did I do wrong?

Options: ReplyQuote


Subject
Written By
Posted
row could not be located for updating
February 15, 2007 06:38PM


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.