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





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