ADO & RDO Error
Posted on 1999-07-27
I've been trying to find a solution for these errors and I can't, can somebody help me please ???
I'm using VB6 to access an Oracle Database, but I need to execute a BIG length SQL (more than 120 words) using either ADO or RDO technology...
The error that I get using RDO is: "NOT ENOUGH STACK SPACE", while the Error that I get using ADO is: "UNEXPECTED FAILURE"
If I tried to execute a short lenght SQL like: "Select * from TB", it doesn't produce any error...Why ???
The reason of executing a complex query is that I need to get from a single SQL the data stored in 9 tables, with 19 fields each approximately and parameters, big enough ah!!
Oh! I forgot, Why is it that the recordcount property always says -1 instead of the number of records obtained through the SQL statement ????