Hi,
   I have a typical problem here. From vb I send SQL queries to database 
and execute them. The result I display in a grid. The queries are complex.
I am able to execute most of the queries. 
I am facing a problem in executing queries with parenthesis open.
For example
    (Query1)union(query2)union(query3)....Throws an error 3704 
ADODB.Recordset: Operation is not allowed when the object is closed!

If I execute the same query without parenthesis say,
     query1 union query2 union query3..... Executes fine!

If you execute a query say, (QUERY1) you get an error missing right 
parenthesis which is thrown by oracle as syntax error. But If you execute
(Query1)union(query2)union(query3) at oracle sql plus it gets executed 
fine!
Help me!

Thanks in advance....
Vijay