How to use sequences, and which trgger for "Execute_Querry'?

[Quoted] Hi. Thanks for reading this.

[Quoted] I have a sequence defined, and want it to increment by 1 each time I add a new record. Well, what happens is, when the form comes up, no records are visible. I have to manually press the 'execute_querry' button to [Quoted] [Quoted] get the old records to show up. When I do that, the records appear, but the sequence number has now doubled. Also, each time I press the "next" [Quoted] [Quoted] or "previous" record button to review the old records, the sequence increments.

[Quoted] [Quoted] So I think I have the "select cr_seq.nextval into [Quoted] :change_request.cr_number from dual;" statement on the wrong trigger. Which one should it be on? I have it on the "WHEN-NEW-RECORD-INSTANCE" [Quoted] [Quoted] trigger for the block. I also tried the "WHEN-NEW-BLOCK-INSTANCE" TRIGGER. Same results.

[Quoted] Also, where does the "EXECUTE_QUERRY" command go so it will auto. load the old records for the table when the form appears?

Thanks,
Richard Hollingsworth Received on Tue Oct 03 2000 - 17:32:59 CEST