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
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
