Главная страница | назад





Article #19443: Generating auxilary tables for Local SQL

 Question and Answer Database
FAQ4443B.txt — Generating auxilary tables for Local SQL
Category :BDE Features
Platform :All Windows
Product :All32Bit,
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;
3/26/99 2:25:24 PM

Last Modified: 01-SEP-99