Re: Sequences: How to generate outside of default property
Date: 1998/01/26
Message-ID: <01bd2a8e$acfe1fe0$0bbbcdcf_at_AGDEV001.AGDEV>#1/1
I think I now know how to assign the nextval value to an item. Instead of
a direct reference (block.item = :sequence...nextval) or putting
:sequence...nextval into the default property of the item, I believe the
following would work:
Under the pre-insert trigger for the block, type: 'select
seqname.nextval into block.item from dual' . So evidently, only a select
statement will work if trying to assign the next value outside of the
default property
Joanne James <jjames_at_crystalconsulting.com> wrote in article
<01bd2911$0e355140$cfbbcdcf_at_AGDEV001.AGDEV>...
> Hello... I've set up my sequence to generate up to number x (ie, 99999).
I
> want the sequence to get the next number to store in an item only when I
> press 'Save'.
Received on Mon Jan 26 1998 - 00:00:00 CET