Delphi 3 cant (won't?) DELETE records
I am trying to use MySQL ( Client Server SQL Database ) with delphi
C/S ver 3 without many problems, however after I added a 'simple'
form, called from the main forms menu to do maintenance of
name and address information.
The problem is, although I can create and enter NEW records , using a
TDBGrid display against the MySQL databse tables which are updates and
displayed correctly, whenever I attempt to use the DELETE ( from the
attached navigator bar, the following error message appears :
"Could'nt perform the edit because another user changed the record"
This is interesting because :
1) the SAME user actually entered the record, just prior to
the attempted delete
2) there is actually one ONE real user using the program (
although I suppose DELPHI 'might think' otherwise ! )
Any ideas welcome.