Re: Using sequence for default value, help!!

Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk> wrote in <F43E6BAE5BB5D411A44C00805FBE740D7F1EC0_at_apps.leeds.lfs.co.uk>:

>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)

Creating a trigger that fires on inserts only should be sufficient.

Rene

>
>------------------------------------------------------------------------
>--------
>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.
>
>

-- 
Rene Nyffenegger
rene dot nyffenegger at adp-gmbh dot ch