Re: Accessing a sequence in a report

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
RTProffitt_at_beckman.com

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