Master Detail Form Loop

[mrkamran]

Hello,
I have a master detail form and in detail block i want generate a loop from first record to last record of detail block. I want to check that an code is already in previous records of detail form. So i want to make a loop which check a field with given value in every row where it will find that value it will give me duplication error.
Thanks!

 

[taupirho]

Something like this:-

declare
x number;
begin
go_block('your_block_name')
last_record;
x:= :system.cursor_record;

for i in 1 .. x
loop

/* your stuff goes in here */



end loop;
end;

 

[taupirho]

Hmmm, probably need a first_record statement there too
before the start of the loop