Page 1 of 1

display of records

Posted: Sat Jun 09, 2007 6:03 pm
by venkat_mel
hi

i have a situation where i need to display only few records in a form.
i am giving a condition
if (:dept.deptno=40) then
clear_record;
end if;

but the record is not cleared automatically. it is getting cleared once i go into that particular record. what else can i do. can i use exec sql to display records based on a conditon.

thanks,
venkat

Posted: Mon Jun 11, 2007 1:39 am
by ahmadbilal
You can check Data Block property <b>"Number of Records Displayed"</b>