clearing item which have multi records [message #349131] |
Fri, 19 September 2008 00:35  |
tjay
Messages: 37 Registered: September 2008
|
Member |
|
|
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.
1-)
clear_block('BLOCKNAME') --> returns ORA-06502
2-)
: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  |
 |
djmartin
Messages: 10181 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.
David
|
|
|