>When working with tables, you could use a single element database that was
>accessed exclusively, so that an open-read-increment-write-close procedure
>would handle it nicely.

>In migrating to an ADO/ODBC SQL interface, how would you achieve the same
>thing? The TQuery does not support the exclusive property of the TTable,
>and the BDE's Local SQL is limited in scope...

1. Start Transaction
2. Get Order ID
3. Insert information
4. Commit changes.

You don't use local SQL for ADO....

--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax


---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to