SQL VX-Rexx

[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]

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.

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.