[DUG] Connection to MySQL using Devart Components

[Marshland Engineering]

A late reply - I seemed to have missed a few emails!!

Correct me if I am wrong. Comparing SQL and Delphi with Absolute database and I assume all other databases from years gone by. The older ones I have used all worked the same. 

I have 2 linked tables with MemID for tblMembers and tblPayments. I could delete a payment record by being on that record and executing tblPayment.delete.

If I do the same with MySQL I get an error something like Updating two records as the same time. 

I then added and index to tblPayment called PmtID. It is just that, an index not linked to anything else and now I can delete a record without an error. Is it something to do the way SQL finds a record to delete ? 

Thanks Wallace


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120508/57de4a55/attachment.html