Thanks for the story, Sybrand! : - )

Keep pushing dem buttons!

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:961451853.9720.0.pluto.d4ee154e_at_news.demon.nl...
> Ok,
>
> First an little story from a fifties comic. The main character somehow
 ended
> up in an air-ship. He did learn how to fly, but he never passed the part
 of
> the exam to land. This proved to be a problem in his current predicament,
 he
> couldn't get the zeppelin down.
> Luckily Albert Plesman, the founder of the Royal Dutch Airlines, was
 present
> of the scene.
> 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"
> The zeppelin landed in a few seconds
>
> 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
>
>
> "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 Tue Jun 20 2000 - 00:00:00 CEST