Re: Easy one : Autoquery when_new_forms_instance leaves gaps in IDs

Remove the inital value from the field.
Add trigger On-Insert
 :customer_id := :sequence_name.nextval;

Bert Vanderstraeten wrote in message <7lb3ct$l08$1_at_news0.skynet.be>...
>
>I use several forms that (upon opening) fire the execute_query statement so
>all data appears immediately. Adding records is done through pressing a
>button which does a create_record (thus the form is maily used for querying
>but also allows one to add records). Every record has a unique customer_id
>which is determined by a sequence.
>
>Problem: the customer_id has :sequence_name.nextval for initial value. When
>the form is opened all data is queried but the sequence jumps eventhough no
>new records are entered. This results in id gaps every time a form is
>opened.
>
>Any ideas how I can solve this one easily ?
>
>
Received on Wed Jun 30 1999 - 00:11:16 CEST