Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Hong kong
    Posts
    14

    Unanswered: Invalid identifier

    Dearest helper,

    I have run the following command. It works in SQL Plus but not on VB.

    "select rtrim(QuoteNo) || '/' || to_char(QuoteVer,'9'), QuoteDate, " & _
    "CustName, PartNo , SalesOffice from EPCUSER.ZPMS0004 inner join " & _
    "( select Description from EPCUSER.ZMST0001 where " & _
    "rtrim(MasterKey1) = 'PMSSTATUS' ) on Status = " & _
    " to_number (MasterKey2)"

    This is a inner join table query to return records. It always promtp the error that "Invalid Identifier : MasterKey2 "

    MasterKey is char located in table EPCUSER.ZMST0001

  2. #2
    Join Date
    Nov 2003
    Location
    Hong kong
    Posts
    14

    Any ideas

    Dear helper,

    Any ideas?

    Data type of "Masterkey2" is char.
    Data type of "Status" is float

Posting Permissions

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