Recent content by Martin99

Any idea what the syntax of that DELETE command would be? The reason I am using a Recordset in the "real" app is that the code operates on the record selected from the queue table by the SQL and when the user has finished working with the queued item, it needs to be deleted from the queue.

In that case don't you find it astonishing that ADO goes ahead and deletes child records in the ABSENCE of anything specifically telling it to do so? This has to be an oversight, and one that really ought to be documented, given its potential for data destruction. Surely ADO has all the...

Hi Pat, No there are no relationships defined in the backend at all, in either case. In the test, I just created those two simple tables and ran the code. I'm baffled, largely because I can't believe I'm the first person to notice this behaviour. I'd be grateful if somebody else could...

Help! There is definately different behaviour between ADO and DAO here! To prove the point to myself, I built a simple test using the same SQL to open the recordsets: Option Compare Database Option Explicit ' Using two simple tables (the fldID fields are irrelevant): ' tbl2.fldData2 is...

Not sure if this is a coding issue or a linking issue - it's a bit of both, but any ideas would be appreciated: I have a stand-alone (C++ Builder 6) application which adds records to a "queue" table in a separate back-end MDB file using ADO. Then I have an Access 2K front-end user application...