Home » Developer & Programmer » Forms » clearing item which have multi records
clearing item which have multi records [message #349131] Fri, 19 September 2008 00:35 Go to next message
Messages: 37
Registered: September 2008
I have text item which consist of 10 records.
When a user preses button, I have to clear the item.
Since it has more than one records, I couldnt manage to do it.

I tried two methods but both didnt work.

clear_block('BLOCKNAME') --> returns ORA-06502

:item_name:=null; --->doesnt work

[Updated on: Fri, 19 September 2008 21:58]

Report message to a moderator

Re: clearing item which have multi records [message #349442 is a reply to message #349131] Sun, 21 September 2008 20:28 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I really don't feel like answering this question. Its Monday morning and I had a very heavy weekend in the garden. My body hurts and questions like this make my head hurt.

Records contain items, not the other way around. A query can return multiple records, and it is possible to build a multi-part item by concatenating various items together, but "I have text item which consist of 10 records" just not make sense.

Please restate what you are trying to do.

Previous Topic: Sql Loader command can be used in Forms
Next Topic: problem with convert developer5 to 6i
Goto Forum:

Current Time: Mon Oct 24 09:15:44 CDT 2016

Total time taken to generate the page: 0.04747 seconds