Re: Plez help attaching sequence to form object..

Ok,

[Quoted] First an little story from a fifties comic. The main character somehow ended [Quoted] up in an air-ship. He did learn how to fly, but he never passed the part of [Quoted] the exam to land. This proved to be a problem in his current predicament, he couldn't get the zeppelin down.
[Quoted] Luckily Albert Plesman, the founder of the Royal Dutch Airlines, was present of the scene.
[Quoted] He shouted to Pa Pinkelman (the main character)

"What did you do"
"I pushed all the buttons of which I thought they were correct"
"Now push on all the other buttons"

So it is
select cr_seq.nextval
into :block_name.fieldname
from dual;

Users need to have select privilege, and you need to create either private or public synonyms

Regards,

Sybrand Bakker, Oracle DBA

[Quoted] "Richard Hollingsworth" <william.hollingsworth_at_hsv.boeing.com> wrote in message news:394E87F1.E06F81FC_at_hsv.boeing.com...
> Thanks for reading this.
>
> I have a Forms5.0 / Oracle 8.0.5 database running on Win NT 4.0.
>
> I have a sequence called CR_SEQ. When I try to attach the sequence to a
> form field (a text field) I either get a compile error or a run-time
> error based on what I try.
>
> When I try....
>
> select :block_name.CR_SEQ.nextval into change_request.cr_number;
>
> I get a compile error.
>
> I've tried...
>
> :block_name.CR_SEQ.nectval
>
> 'block_name.CR_SEQ.next_val'
>
> block_name.CR_SEQ.nextval
>
> :SEQUENCE.CR_SEQ.nextval
>
> etc, etc, etc....
>
> So, please tell me how to correctly specify my sequence.
>
> Also, is there any special role or priv I have to grant users for this
> sequence to work right?
>
> Thanks,
> Richard Hollingsworth
Received on Mon Jun 19 2000 - 00:00:00 CEST