PxPlus User Forum
Main Board => Discussions => ODBC => Topic started by: eldonfsr on June 11, 2021, 11:17:48 AM
-
I have this SQL statements but when is executed send a error not found indentifier
select PurchaseOrderNumber, PurchaseOrderDate, Vendorname, ItemNumber from { oj #PO1_PurchaseOrderEntryHeader INNER JOIN #PO2_PurchaseOrderEntryLine ON #PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = #PO2_PurchaseOrderEntryLine.PurchaseOrderNumber } WHERE PO1_PurchaseOrderEntryHeader.PurchaseOrderDate = {d"2015-08-05"}
what i doing wrong...
-
Is the # symbol part of the table name?
If it is not then it likely is the problem as that is not supported syntax.
If it is part of the table name then it looks like it is missing from the WHERE clause.
-
select * from { oj PO1_PurchaseOrderEntryHeader INNER JOIN PO2_PurchaseOrderEntryLine ON PO1_PurchaseOrderEntryHeader.PurchaseOrderNumber = PO2_PurchaseOrderEntryLine.PurchaseOrderNumber } WHERE PO1_PurchaseOrderEntryHeader.PurchaseOrderDate = {d"2015-08-05"}
even i write without # is the same message...
-
Are the table names all correct and is that the correct field names?
If you do it without the WHERE clause to test does it work?