Dixon Epperson wrote:

>
> But now I have a couple of questions. If I am only going to use it
> for inserting new data, why do I need to check that the SD_RECNO is null??

If you want to keep before insert trigger you planned to have originally
it needs to supply a value only if none has been supplied.

>
> Also, how come it wouldn't work with
> END
> SUSPEND;
> right preceeding the final END!!??

Too many ENDs?

Cheers,


Ann