Need Help With SQL*Forms and Nextval
From: David R. Barstis <david.r.barstis_at_med.umich.edu>
Date: 6 Jul 1993 12:28:10 GMT
Message-ID: <david.r.barstis-060793082740_at_no-name-medadmin.med.umich.edu>
Date: 6 Jul 1993 12:28:10 GMT
Message-ID: <david.r.barstis-060793082740_at_no-name-medadmin.med.umich.edu>
Hello, I have a field in a master-block that is the primary key. I want to make this unique by using a sequence. If I set the default value to :sequence.seqname.nextval it works fine, except that every time I go to that block it generates a new sequence number, thus "wasting" sequence numbers. Is there a way that I can avoid this "wasting". I would like the number to be displayed to the user and to be propagated down to the many (five) detail-blocks correctly.
Any Suggestions?
Dave Barstis
E-mail: david.r.barstis_at_med.umich.edu
"I'm so broke I can't even pay attention!" Received on Tue Jul 06 1993 - 14:28:10 CEST