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