| How to build and call complex queries through ADO [message #100637] |
Tue, 25 March 2003 13:01 |
Mark R
Messages: 7
Registered: March 2003
|
Junior Member |
|
|
Hello,
Working with ADO and MS SQL Server, I construct queries on the client, as simple strings of text, and pass them into Recordset.Open or Connection.Execute. Some of the queries are complex, with variable declarations, temp table use, cursors, iteration, ect,... like a big stored procedure, but not one, just a query string. I've been trying to do the same with Oracle, like a PL/SQL block with a declare, begin and end. I can't get any queries to work that would return result sets. It seems that all I can do is updates. I don't want to have to create procedures. I do stateless, one time queries, with the query string built on the client and called via ADO. It seems that only simple SELECT statements work. Does anyone have any advice, examples, documentation, urls, that explain how to build, and call through ADO, these more complex type of queries with cursors, temp tables, variable, begin, end, ect,...
Thank you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
