|
Posted by Jim C on 11/28/06 16:51
Robert,
I'm accessing the tables with an application that uses ODBC for now
(it'll probably go some other more direct route in the near future as
things are refactored). The way it is architected it needs to know the
value before the insert occurs because of the how and when it passes
that value to child records in master-detail setups.
Your idea about emulating an Oracle sequence looks like it will be just
the ticket. Thanks!
Jim
Robert Klemme wrote:
> You do not post where you need that information. If your insert is in a
> stored procedure then SCOPE_IDENTITY after the fact should work.
>
> If for some other reasons you really need the value beforehand, you can
> emulate an Oracle sequence
Navigation:
[Reply to this message]
|