Suppose you are wanting to insert an order into an order database. The
first thing you need is a sequential order number.
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...
I'm sure there's an easy answer to this, but my brain is starting to melt.
Cheers,
Terry
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
