OraFAQ Forum: Forms » problem in NEXT ITEM

Home » Developer & Programmer » Forms » problem in NEXT ITEM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in NEXT ITEM [message #195755]

Mon, 02 October 2006 03:01

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii all

I have a problem in using in "next item"

see this code

IF(GET_ITEM_PROPERTY(:SYSTEM.CURRENT_BLOCK||'.'||:SYSTEM.CURRENT_ITEM,INSERT_ALLOWED)= 'FALSE') THEN
LOOP         	
NEXT_ITEM;	
exit WHEN ((:SYSTEM.CURRENT_BLOCK <> Vblock_name) OR
(GET_ITEM_PROPERTY(:SYSTEM.CURRENT_BLOCK||'.'||:SYSTEM.CURRENT_ITEM,INSERT_ALLOWED)= 'TRUE')
         	);
END LOOP;         	
END IF;

this code to make the cursor on the first field in my form have insert allowed with 'yes'

it works fine when the form contain records (table is not free)
if the form doesnot contain records (table us free) it the loop is working as inifinite loop

N.B
the first item in my form has initial value and set insert allowed to no
(this to make the cursor go to the next item when insert)

Thanks for everyone Helped and Helping me

[Updated on: Mon, 02 October 2006 03:02]

Report message to a moderator