Visual Basic 6.0 and Oracle 8.0.5

[joedogg]

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!
[sig][/sig]

 

[Advocate]

quick response - is line_no some sort of oracle reserved word ? i have not had the chance to check references ? could you try changing name of field ?

Best of Irish Luck, David.
djwilkes@hotmail.com

 

[MikeLacey]

Try:

Select "QUOTE_ID", "LINE_NO" From "QUOTE_LINE";

The double quotes will work if any object names are using reserved words.

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/