Re: Accessing a sequence in a report
From: David Pattinson <david_at_addease.com.au>
Date: Wed, 19 May 1999 10:36:42 +1000
Message-ID: <3742079A.D33FEC48_at_addease.com.au>
Date: Wed, 19 May 1999 10:36:42 +1000
Message-ID: <3742079A.D33FEC48_at_addease.com.au>
Anna,
You could insert all your cheque details into a table using sequence.nextval in the usual way. Then use the table to generate the print job. You could choose to keep the history of printed cheques (could be good for finding cheque numbers by date and payee name), or discard them after printing.
HTH, David.
Anna Goff wrote:
> When I try and pull a nextval from a sequence in a query, it tells me a
> sequence cannot be used here. I am trying to print checks and would really
> like for it to assign the check number (a sequence) at the time it prints.
> Does anyone have any suggestions???
> Thanks!
> ...Anna...
Received on Wed May 19 1999 - 02:36:42 CEST