DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: VB BLues

  1. #1
    Join Date
    Oct 2000

    VB BLues

    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!

  2. #2
    Join Date
    Jul 2000
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.