You would need to change your INSERT to INSERT(TRUE).
This is because the code that does the No. Series Management gets called from the insert trigger.
After that you can just use SH."No." to get the number (the instance that the the trigger uses is the same instance that you are currently using).
This isn't a signature, I type this at the bottom of every message
Comments
This is because the code that does the No. Series Management gets called from the insert trigger.
After that you can just use SH."No." to get the number (the instance that the the trigger uses is the same instance that you are currently using).
My bad.
Some times You just look and look, and cant find it .... :roll:
Regards,
Brian