Getting the item type [message #183601] |
Fri, 21 July 2006 08:52  |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
I was trying with the following code.
Declare
Item_Type varchar2(60);
item_count number:=0;
Begin
Item_Type:=GET_ITEM_PROPERTY(:system.curren_item, ITEM_TYPE);
If Item_Type IN ('TEXT ITEM') then
item_count:=item_count+1;
--Code to get the item values if the item is a text item ---
-- for exporting the data to Excel ----
End if;
End;
I am doing this to get the item_count in the form (except buttons, images etc.,) and move all the text item data to Excel sheet.
But the statement
Item_Type:=GET_ITEM_PROPERTY(:system.curren_item, ITEM_TYPE);
does not return anything to the Item_Type variable.
Any one can suggest what should have gone wrong.
Thanks,
Nirmal.
[Updated on: Mon, 07 August 2006 01:59] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: Getting the item type - Bug with Forms 10g ? [message #187214 is a reply to message #186214] |
Fri, 11 August 2006 06:00   |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
i even tried the statment like this
Declare
it_id Item;
ItemType Varchar2(255);
item_name varchar2(255):='YOUR_BLOCK.YOUR_ITEM';
BEGIN
Message('1');
Message('1');
it_id := Find_Item(item_name);
Message('2');
Message('2');
ItemType:=Get_item_property(it_id,ITEM_TYPE);
End; The program execution is not goind beyond the first Message.
Program halts without any response in the following statement.
it_id := Find_Item(item_name);
I am using FORMS 10g. I called Oracle support people, even they could not find a solution.
Is this a bug with Forms 10g ?
Thanks,
Nirmal
[Updated on: Mon, 14 August 2006 00:11] by Moderator Report message to a moderator
|
|
|
Re: Getting the item type - Bug with Forms 10g ? [message #187433 is a reply to message #187214] |
Mon, 14 August 2006 00:47  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Okay.
1) Exactly which version of Forms 10g are you using and on which operating system?
2) Have you tried creating a new form and having only this code in your form?
3) Try Ctrl-Shft-K (compile all) and then Ctrl-T (Generate). It is possible that you are doing a Ctrl-K (Incremental Compile) and that may not be enough.
I can't find anything on metalink either.
David
|
|
|