|
|
Hello,
Can we have this pl/ sql block in condition tab of personalization like
declare
v_rec_no number;
sum_no number:=0;
begin
if :system.cursor_record > 1 then
v_rec_no = :system.cursor_record ;
first_record;
for i in 1 to v_rec_no loop
sum_no :=sum_no +sum_no;
next_record;
end loop;
end;
What I have to do is while person is doing reservations he can make mutiple lines on that form where he entered a quantity, now that quantity is to be checked with certain quantity which we do have already in database. Can I sum those quantities in form before saving with the quantity i have of quality. that the quantity i am entering in form with multiple lines should not exceed that quantity so it should not let him save the quantity.
Thanks and Regards,
Saad Qaiser Khan
|
Locked
