بسم الله الرحمن الرحيم

السلام عليكم ورحمة الله وبركاته،،
How i can use Sequence in form have master and detials i hope someone give me Example for this case ....
thanks alot

1- Create Sequence in SQL*Plus
SQL> Create Sequence my_sequence;
Exit;

PRE-INSERT
Select my_sequence.next_val into :BLK1.serial from dual;


Where :blk1.serial is a text item on your canvas
BLK1 is the master block

If the sequence number should appear as a foreign key in all details block records then you should use the COPY VALUE From block property to also copy the value from the Master Block to the detail block. The Copy Value from property you use should be the one in the details block and not in the master.

وكيف أعمل saquence في الreport??

اظن ان المقصود من

وكيف أعمل saquence في الreport??

هو عمل تسلسل داخل التقرير

وهذه المشاركة به الجواب انشاء الله تعالى

اضافة مسلسل داخل التقرير