Help with Sequences Needed

From: <AI4CPHYW_at_MIAMIU.BITNET>
Date: Saturday, 13 Feb 1993 11:30:28 EST
Message-ID: <93044.113028AI4CPHYW_at_MIAMIU.BITNET>

Hello There:

I am writing an application in sqlforms30 that, among other things, constructs a complex identifier that includes a 5 digit serial number. Since the serial number range was assigned to us by an outside source, wasted numbers are unacceptable. What I did is create a finite sequence object and construct the identifier with a pre-commit trigger. I figured that by using a pre-commit trigger a sequence number wouldn't be drawn until all required data is filled in and the user hits the commit key. What I found, however, is that if you begin to fill out the form and abort before committing, sequence numbers are still lost. (i.e. if I run through the form and hit the commit key I get serial number 1, if I start to fill in the form again, change my mind and abort (with PF4 on a vt220) and then fill in the form a third time and commit I get serial number 3.)

Am I doing something wrong? Is there a technique I have missed? Or is this some sort of limitiation to the sequence object? If you have the answer, I'd appreciate hearing from you.

                      -Alec D. Isaacson
                       AI4CPHYW _at_ miamiu.acs.muohio.edu
                       isaacson _at_ rogue.acs.muohio.edu (NeXt Mail)
                       Miami University, Oxford, OH
-------------------------------------------------------------------------

"Say, Genie, it's cold here . . . Can we forget the part about being  in Cincinnati ?" -A LaRosa's Pizza commercial Received on Sat Feb 13 1993 - 17:30:28 CET