Mega Code Archive

 

Categories / Delphi / ADO Database

 

Generating auxilary tables for local sql

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;