Author Topic: SQL VX-Rexx  (Read 1030 times)

Per E. Johannessen

  • Full Member
  • ***
  • Posts: 232
  • Karma: +3/-0
    • View Profile
SQL VX-Rexx
« on: April 10, 2023, 08:25:26 pm »
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

  • Hero Member
  • *****
  • Posts: 4630
  • Karma: +93/-1
    • View Profile
Re: SQL VX-Rexx
« Reply #1 on: April 10, 2023, 10:40:27 pm »
Line ending issue?

Per E. Johannessen

  • Full Member
  • ***
  • Posts: 232
  • Karma: +3/-0
    • View Profile
Re: SQL VX-Rexx
« Reply #2 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.

Mentore

  • Full Member
  • ***
  • Posts: 133
  • Karma: +4/-0
    • View Profile
Re: SQL VX-Rexx
« Reply #3 on: April 12, 2023, 07:48:45 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.

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

  • Full Member
  • ***
  • Posts: 232
  • Karma: +3/-0
    • View Profile
Re: SQL VX-Rexx
« Reply #4 on: April 12, 2023, 02:42:45 pm »
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.