Re: Using sequence for default value, help!!

And don't forget to code the trigger to check if there is a value in the field already and only assign the nex sequence value if not ! :o)

Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

>> You can't do it like this. You must create trigger which will be
 setting id
>> value.
Received on Thu Apr 26 2001 - 05:44:48 CDT