Alsalam Alykom,
i'm creating a program and i have counter and i want it to count from 1 to 18 for ever (infinite loop)
without doing sequence.
and if sequence how can i insert it into form and make it work?
another thing that i want each time i enter i see this counter cuz i was using pre_insert trigger on block level but the number appears when i save but i want it to appear when i open the form..
thnx alot in advance ,hope u can help me.

</div>

<div align="left">To Create a Sequence :
CREATE SEQUENCE AR_PER_SEQ
INCREMENT BY 1
START WITH 1
MAXVALUE 18
CACHE 50
CYCLE;
--- this seq. start with 1 to 18 repeated after the value = 18

To put in the form so u see it when open the form :
you have many choices like :
in the trigger
when_create_record on the block level
write:
SELECT AR_PER_SEQ.NEXTVAL INTO :(The_column_name) FROM DUAL ;
-- you can add any conditions after from dula (if u have any conditions)
--------------------------
Imprtant Note :don't use CYCLE seq. if u put the value in a primary key .
--------------------
I hope u undersand me .

and if u don't like to us a seq. u can change the code ( u are using now) from pre_insert to when_create_record

with my best wishes

تم تعديل 20 أبريل 200520 سنة بواسطة ah_prog