Printable View
I am using ado 2.1 with the odbc driver for Oracle. When I execute my query through the Oracle odbc test utility I get the records I expect. But through the app with the added layer of ado I do not get the same results. The sql statement is an outer join between two tables: Select * From Table1,Table2 Where Table1.ID = Table2.ID (+)
Does anyone know how to solve this?
what is the code u a are using to access the database ??
maybe some details will help...
JaspaL
I finally figured it out. Basically the provider I was using did not allow you to use the recordcount property of the recordset. It it was SQL select to one table the recordcount was set but if a join was involved the recordcount was -1. You can't rely on this you should check eof and bof.