| Re: how to develop a Available query forms [message #81868] |
Thu, 27 March 2003 13:57 |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
Zhangrui,
I think that I would get the column list from the table rather than from the block. To do that you would:
select column_name
from all_tab_columns
where table_name = 'TABLE_IN_CAPS'
That will return a list of columns in the table.
To find out why your procedure is not working, put some displays in, see if the trigger is firing, display the where clause string you built, put a display in where you are setting the default where clause block property, and then execute_query.
I can't see anything wrong with your procedure, but put displays in and take it step by step.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
