Re: A simple question, I hope

Have a look a SEQUENCES. You can select the next value of a sequence into the ID field in a BEFORE INSERT ROW trigger.

In article <vO%T6.1896$c37.193703_at_newsread1.prod.itd.earthlink.net>, "Darryl" <dfs_at_nospam.com> wrote:

> How do I get the trigger-generated ID number for the row I just added to
> a table? I can't do a SELECT MAX(ID) because it's a high transaction
> system.
>
> Thanks,
> Darryl
>
>
Received on Fri Jun 08 2001 - 22:27:10 CDT