Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Basid Editing
Basid Editing
Posted: 2005/08/04 19:31
 
Hi,

I've been trying to connect to MySQL, I'm using Any DAC but having some
early problems, I have managed to connect the components to the database,
and through to TADTables and Datasets I can see the database on my DBGrids,
but when I try to edit the table through the data aware components, I get
this back...

[AnyDAC][DApt]-400. Record has been changed/deleted by another user.
Updated[0] record(s).

Thanks in advance

Dan
RE: Basid Editing
Posted: 2005/08/04 20:29
 
Hello Dan !

If the AnyDAC version, you have is <= 1.2.3, then it is broken in the part of editing capabilities. I will release today 1.2.4 with required fixes.

The error happens, if updating record, AnyDAC updates records more or less than 1. To avoid issue, download 1.2.4, and try to set UpdateMode to upWhereKeyOnly.

Also:
1) What is your table structure ?
2) What is your MySQL version ?

Regards,
Dmitry