Re: Accessing a sequence in a report

From: <>
Date: Thu, 20 May 1999 16:25:36 GMT
Message-ID: <7i1d1r$59p$>

I had no problem using sequence generator in a report query. (I was about to suggest using a column function but I don't think it is necessary)

Here is what I did:

   Table: BOB, col1 and col2 both varchar2.    A couple of records of data in them.

  Create Sequence BOBS;

Now, in reports:

   Select COL1, COL2, BOBS.Nextval as MyNumber   From Bob

...Works fine. This presumes you have the sequence gen in the back end, and that you have all the proper rights to execute/select from it.

Robert Proffitt
Beckman Coulter

--== Sent via ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 18:25:36 CEST

Original text of this message