I'm running Win98, connecting to SAPdb 7.4.3.25 through ODBC Following
the advice from a couple of posts on this list, I've installed the v7.3
ODBC drivers, the the 7.4 drivers, then used the 7.3 dll. Evidently
this avoids the 7.3 bug, while allowing win98 (a non Unicode system) to
connect.
A left outer join query fails with General Error 3009: Invalid Table
Name. Making the join an inner join gets rid of the problem.
I swtched on the ODBC trace file, and saw the following (below). It
looks like something is send extraneous characters to SAPdb when there's
a left join in the mix. Note the {oj in the middle.
Thanks in Advance
Alan Graham
SQCDROPPARSID
PARSEID: : 000002F3 00002D01 3C002E00 01000000
SELECT
"PCSDBA"."TBLPLANT"."PLANTID","PCSDBA"."TBLCUSTOMER"."CUSTOMERID",
"PCSDBA"."TBLCONTACT"."CUSTOMERID","PCSDBA"."TBLCONTACT"."CONTACTID","PCSDBA".
"TBLINVOICEHEADER"."INVOICENUMBER","PCSDBA"."TBLINVOICEDETAILS"."INVOICENUMBER",
"PCSDBA"."TBLINVOICEDETAILS"."LINENUMBER","PCSDBA"."TBLPRODUCT"."PRODUCTCODE"
FROM
"PCSDBA"."TBLINVOICEDETAILS","PCSDBA"."TBLPLANT","PCSDBA"."TBLCUSTOMER",
"PCSDBA"."TBLPRODUCT",{oj "PCSDBA"."TBLINVOICEHEADER" LEFT OUTER JOIN
"PCSDBA".
"TBLCONTACT" ON ("PCSDBA"."TBLINVOICEHEADER"."CONTACTID" = "PCSDBA".
"TBLCONTACT"."CONTACTID" ) } WHERE (((("PCSDBA"."TBLINVOICEHEADER".
"INVOICENUMBER" = "PCSDBA"."TBLINVOICEDETAILS"."INVOICENUMBER" ) AND
("PCSDBA".
"TBLPLANT"."PLANTID" = "PCSDBA"."TBLINVOICEHEADER"."PLANTID" ) ) AND
("PCSDBA".
"TBLCUSTOMER"."CUSTOMERID" = "PCSDBA"."TBLINVOICEHEADER"."CUSTOMERID" )
) AND
("PCSDBA"."TBLINVOICEDETAILS"."PRODUCTCODE" = "PCSDBA"."TBLPRODUCT".
"PRODUCTCODE" ) )
PARSE : CMD :
SQLCODE: -3009 Invalid table name
PARSEID: OUTPUT: 00000000 00000000 00000000 00000000
SQLERRD(INDEX_6) : 409 ERROR NEAR ^ : LPRODUCT",^{oj "PCSDB
START : DATE : 2003-07-26 TIME : 0020:04:46
END : DATE : 2003-07-26 TIME : 0020:04:46
S1: DISCONNECT
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
