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!