Re: Sequences in Triggers

In article <3672DF79.7E7B865C_at_lambdaconsulting.com>,   greg.williams_at_lambdaconsulting.com wrote:
> How would I assign a sequence to an item when a button is pressed?
> I know it needs a when button pressed trigger, and I've already created
> the sequence
> (starts with 1000, increments by 1). But I can't figure out how to
> assign it.
>
> And is it even possible to assign a sequence to a list item?
>
> Steve Karam
> steve-karam_at_lambdaconsulting.com
>
>

Hi Steve,
Try select seq_name.nextval into :field_name from dual;

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 21:12:50 CET