OAR-00904 INVALID COLUMN
-
I am getting an invalid column error from oracle from the following code: I checked the columns and they are ok, any ideas ??? "Select A1.PART_CODE, A1.PO_NUMBER, A1.PO_LINE_NUMBER, A3.RECEIVED_DATE " & _ "from FINPROD.POP_LINES A1, FINPROD.GOODS_RECEIVED_LINES A2, FINPROD.GOODS_RECEIVED_HEADERS " & _ "WHERE A1.PART_CODE = sq(txtBox1.text) " & _ "AND A1.PO_NUMBER = A2.PO_NUMBER " & _ "AND A1.PO_LINE_NUMBER = A2.PO_LINE_NUMBER " & _ "AND A2.GRN_NUMBER = A3.GRN_NUMBER " & _ "ORDER BY A3.RECEIVED_DATE"
silver-gray
-
I am getting an invalid column error from oracle from the following code: I checked the columns and they are ok, any ideas ??? "Select A1.PART_CODE, A1.PO_NUMBER, A1.PO_LINE_NUMBER, A3.RECEIVED_DATE " & _ "from FINPROD.POP_LINES A1, FINPROD.GOODS_RECEIVED_LINES A2, FINPROD.GOODS_RECEIVED_HEADERS " & _ "WHERE A1.PART_CODE = sq(txtBox1.text) " & _ "AND A1.PO_NUMBER = A2.PO_NUMBER " & _ "AND A1.PO_LINE_NUMBER = A2.PO_LINE_NUMBER " & _ "AND A2.GRN_NUMBER = A3.GRN_NUMBER " & _ "ORDER BY A3.RECEIVED_DATE"
silver-gray
-
I am getting an invalid column error from oracle from the following code: I checked the columns and they are ok, any ideas ??? "Select A1.PART_CODE, A1.PO_NUMBER, A1.PO_LINE_NUMBER, A3.RECEIVED_DATE " & _ "from FINPROD.POP_LINES A1, FINPROD.GOODS_RECEIVED_LINES A2, FINPROD.GOODS_RECEIVED_HEADERS " & _ "WHERE A1.PART_CODE = sq(txtBox1.text) " & _ "AND A1.PO_NUMBER = A2.PO_NUMBER " & _ "AND A1.PO_LINE_NUMBER = A2.PO_LINE_NUMBER " & _ "AND A2.GRN_NUMBER = A3.GRN_NUMBER " & _ "ORDER BY A3.RECEIVED_DATE"
silver-gray
There are 3 different table involved here. The table A1 will return many rows since it is the purchase order line items table. the other will return one for each of the rows in A1. I don't understand your reply. This is a select command were the data in txtBNox1.text is the only field that has enterable data in. Please explain your reply. Thanks
silver-gray
-
There are 3 different table involved here. The table A1 will return many rows since it is the purchase order line items table. the other will return one for each of the rows in A1. I don't understand your reply. This is a select command were the data in txtBNox1.text is the only field that has enterable data in. Please explain your reply. Thanks
silver-gray
The text is converted via the following function Public Function SQ(ByVal Textin As String) As String SQ = "'" & Replace(Textin, "'", "''") & "'" End Function
silver-gray
-
The text is converted via the following function Public Function SQ(ByVal Textin As String) As String SQ = "'" & Replace(Textin, "'", "''") & "'" End Function
silver-gray
The database is not aware of your function either. You have placed the function call and the reference to the text box inside the string, that means that it's not code, it's just a part of the string. The string will be sent just as it is to the database, and the database couldn't do anything with it even if it did understand what it was, as it doesn't have access to either your function or your text box.
--- b { font-weight: normal; }
-
The database is not aware of your function either. You have placed the function call and the reference to the text box inside the string, that means that it's not code, it's just a part of the string. The string will be sent just as it is to the database, and the database couldn't do anything with it even if it did understand what it was, as it doesn't have access to either your function or your text box.
--- b { font-weight: normal; }
Thank you. Now I understand Thanks :laugh:
silver-gray