Re: "WITH" statements and ADO...

deanbrown3d wrote:
> Well that is one idea, and a good one. But I would like to be able to
> build up SQL strings in the code at will, and not create views (its a
> big thing for us to get anything like a view created).
>
> Thanks
>
> Dean

I can't see the original post but one possibility for what you describe is to write a stored procedure in the database capable of processing anonymous blocks. I have one that will handle up to 4GB of PL/SQL.

Then pass in whatever transactions you want in the form of an anonymous block and let the proc execute whatever comes in.

Of course SQL Injection is a concern if you do this so you must be very careful with the front-end.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)