Re: Thanks for the SEQUENCE help, but still dosen't work....

Try moving the code to a When-New-Item-Instance trigger instead. But remember that this will increment the sequence even on records that do not get inserted into the database.

But why don't you see the value that is being generated in the Pre-Insert trigger? If the sequence is incrementing, the value is apparently being generated. Are you selecting into a database column? Are you including, and displaying, that field on your form?

You can use a sequence as a default value, too, in the item property sheet. See the online help topic Default Value property, which shows that the property can be set to :SEQUENCE.my_seq.NEXTVAL. (This also will increment the sequence even if the record is not committed.)

If this doesn't help, please give a little more detail about your form.

Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> wrote in message news:389AF154.893D989_at_hsv.boeing.com...
> Hi folks. Thanks for reading this.
>
> I asked yesterday how to tie a sequence to a FORMS 2.1 field. I was
> told to place a SELECT statement on a PRE-INSERT trigger for the block
> and I did that. Problem is, the sequence nubmer still does not show up
> on the form.
>
> Is there anything ELSE I need to do to get the sequence value to show up
> on the form?
>
> The sequence seems to be working (I cheked it after each run) and it's
> incrementing just fine, but the value does not show up on the form.
>
> Thanks for any help.
>
> Richard H.
Received on Fri Feb 04 2000 - 17:07:39 CET