Tony
Glad I could be of help - once I undstood that you need the surogate key
before creation the differences
become clear - My case tool uses generators to replicate the behaviour of
Identiy cols by inserting them in the trigger
when you define a col as a 'counter' (for consistency of behaviour i guess)
I felt you just needed a little lateral help (re the fact that generastor
can be replicated and more powerfully as a stored proc)
On this topic I'm coding a table with surrogate key (MSSQL 7 and ADOExpress)
so I'll tell you how I get on.
Regards Neven
N.K. MacEwan B.E. E&E
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
