Re: Changes in initial value behaviour between forms 4.5 and 5.0

Yes, you can use this notation in the Initial Value property (in Forms 5):

  :sequence.your_seq_name.nextval

But you are quite right - using PRE-INSERT is better :)

Paul Couchman wrote:
>
> Does anyone know of any change in behaviour of the "initial value" property
> of items in forms (was default value I believe)?
>
> We have a number of forms which default a primary key sequence into the item
> value at insert time using the :sequence.seq.nextval notation in the default
> value property. When upgrading to 5.0, these items appear to be null when
> inserting, thus getting a ORA-1400 error.
>
> We have got around the problem by using PRE-INSERT triggers to populate the
> values (which I actually prefer), but was just wondering if anyone had come
> across this problem?
>
> Paul

-- 
Valeri Sorokine
[Quoted] ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru