| getting column name from text item [message #80790] |
Fri, 22 November 2002 14:58  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
Hello All...
Problem here... I have a whole bunch of text items that I am looping through and trying to get the COLUMN_NAME of each text item...
Normally one would use - GET_ITEM_PROPERTY(s_block_item,COLUMN_NAME); RIGHT!
But... this isn't working for some reason. The text items originally started out as database fields by default, but I didn't think that I wanted them as database fields so I changed the DATABASE_ITEM property to 'NO', but then I realized that they should be, thus changed them back. Now for some odd reason when I use the following code, I get a null value for the column_name, even though the property database_item is set to 'YES' and the actual column_name in the property pallette of the text item does have the proper column name in it!! Suggestions?
declare
s_db_columnNm varchar2(100);
s_block_item varchar2(100);
begin
s_block_item := 'malig_abstract_edit.loc_at_diag';
s_db_columnNm := GET_ITEM_PROPERTY(s_block_item,COLUMN_NAME);
message('column name = '||s_db_columnNm);
end;
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
