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: Surges Bay TAS 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: order by in query mode
Next Topic: Is there any way that we could fin which block is present on the form
Goto Forum:

Current Time: Wed Aug 23 22:16:10 CDT 2017

Total time taken to generate the page: 0.19859 seconds