| Generating auxilary tables for Local SQL |
|
|
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? 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
|
| Hits/month | 2,500,000+ |
| Downloads (Since May 2000) |
7,393,709 |
| Total Files | 6,023 |
| Forum msgs | 7,670 |
| Articles/FAQs | 70+/900+ |
| Kylix |
| Tips n Tricks |
| FAQs |
| Knowledge Base |
| Bug Listings |
| Articles |
| Books |
| Newsgroups |
| Links |
| Submissions |
| Testimonials |
| Advertising |
| Contact Us |
| About Us |
Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use