| SQL QUERY FROM FORM [message #86437] |
Wed, 29 September 2004 23:04  |
ashish
Messages: 107
Registered: December 2000
|
Senior Member |
|
|
I WANT T0 EXECUTE SQL SELECT STATEMENT FROM FORM AND I WANT TO display THAT RESULT INTO FORM OR .XLS FILE MY PROBLEM IS MY QUERY IS DEPEND ON COUMNS SELECTED BY USER WITH THE HELP OF LIST element AND THIS TYPE OF SELECT STATEMENT I CANT USE IN cursor . PPPLLLLZZZ GIVE ME THE SOLUTION
REGARDS
ASHISH
|
|
|
|
| Re: SQL QUERY FROM FORM [message #86439 is a reply to message #86437] |
Thu, 30 September 2004 00:38  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Ashish,
This is very much Possible.
All you need to do is make use of Ref cursor and base your Form on a Procedure/Package instead of a Table.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
