Re: find max id for forms
Date: Tue, 7 Aug 2001 17:31:11 +0200
Message-ID: <9kp1ju$2vc$1_at_mail.ic.uva.nl>
Hello Kevin,
wouldn't it be easier to use a sequence to generate the number? You would
have to create the sequence and call it in the pre-insert trigger in your
form.
"CupOfWater" <asiandoof_at_hotmail.com> wrote in message
news:e0c9495d.0108060846.33dad8b_at_posting.google.com...
> Hi, I have a form that has a field, mid denoting membership ids. This
> corresponds to an ORACLE table that has mid, name, etc. Instead of
> having the users find the highest mid from the database and enter the
> next highest one, I want the form to automatically find the largest
> mid and add 1 to that number and put the result into the mid field. I
> don't know how to do this, but I think it involves some triggering of
> some sort and PL/SQL, but I don't know which trigger(s) would be
> appropriate. Thanks.
>
> Kevin
Received on Tue Aug 07 2001 - 17:31:11 CEST