I am using Visual Basic 6.0 for the the front-end of a project and Oracle 8.0.5 fo rthe back-end. I am coming across something that seems strange. I am using ADODB.recordset.
A few of the tables in this database have columns named LINE_NO when I try to SELECT that column it will not return any values. For example: SELECT QUOTE_ID, LINE_NO FROM QUOTE_LINE returns nothing; SELECT QUOTE_ID FROM QUOTE_LINE will. Any suggestions!
Does a select in SQL*PLus also returns nothing?
Is it possible that an error occurs and nothing can be returned. Is the datatype of line_no supported in the VB front-end?