OS/2, eCS & ArcaOS - Technical > Programming
SQL VX-Rexx
(1/1)
Per E. Johannessen:
Hi,
I have a sql query created with DBExpert, and it works fine in DBE.
When trying to use the same SQL statement in VX-Rexx I get this error:
[ODBC dBase driver] [dBase] Extra characters at end of query: JOIN.
VX-Rexx is set up to use the same odbc driver as DBExpert so I suspect that VX-Rexx is "doing"
something to the sql statement before sending it to the driver.
(Simple SQL statements without "JOIN" works fine with VX-Rexx.)
Has anyone experience with this?
Dave Yeo:
Line ending issue?
Per E. Johannessen:
Could be but the SQL statement I use in VX-Rexx is identical to the one that works with DBExepert.
Other simpler SQL statements work fine. If VX-Rexx is adding something it must be "behind the scenes"
and not visible to the user.
I can work around the issue by duplicating some data in a few tables, however first I'd like to know
if anyone else has had the same problem, and hopefully a solution.
Mentore:
--- Quote from: Per E. Johannessen on April 11, 2023, 12:30:21 am ---Could be but the SQL statement I use in VX-Rexx is identical to the one that works with DBExepert.
Other simpler SQL statements work fine. If VX-Rexx is adding something it must be "behind the scenes"
and not visible to the user.
I can work around the issue by duplicating some data in a few tables, however first I'd like to know
if anyone else has had the same problem, and hopefully a solution.
--- End quote ---
Could it be something related to character encoding? I remember differences between e.g. Oracle and MS SQL, on accepting strings surrounded by single instead of double quotes.
Mentore
Per E. Johannessen:
I don't think so since some SQL statements works just fine. The problem is with statements containing "INNER JOIN" and "JOIN".
Also the these statements work correctly with DBExpert.
Navigation
[0] Message Index
Go to full version