Question:
When I insert or delete records with Database Desktop using
Local SQL a INSERTED or DELETED table is generated. How do I
do the same with any BDE tool?
Answer:
Here's a Delpi example. It assumes Query2 has a SQL statement
that deletes or inserts records from a Paradox or dBASE table.
Query2.PrePare;
Check(DbiSetProp(hDbiObj(Query2.stmtHandle), stmtAUXTBLS, LongInt(True)));
Query2.ExecSQL;