PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Code failure between PVX 9.1 and 15.1  (Read 1756 times)

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Code failure between PVX 9.1 and 15.1
« on: July 15, 2021, 11:59:26 AM »
This line of code executes on version 9.1 of PxPlus with no issue.

10010 ok=1; test=hfn; if %wdx=1 then open (test,err=MISSING_WASP)"[WDX][ODB]SunnyLabel" else open (test,err=MISSING_WASP)"[ODB]SunnyLabel"

The exact same code on the same workstation returns an error 15 and branches to the "MISSING_WASP" label on vesion 15.0.  %WDX is in fact 1, so the wdx vefrsion is executing.

What might I be missing here?

Thanks!

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Code failure between PVX 9.1 and 15.1
« Reply #1 on: July 15, 2021, 02:30:43 PM »
You may be able to get more info about the error by checking msg(-1) to see if there is additional error info about the error 15.
Principal Software Engineer for PVX Plus Technologies LTD.

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Code failure between PVX 9.1 and 15.1
« Reply #2 on: July 15, 2021, 02:34:49 PM »
Also, make sure the workstation is using the correct WindX.  The 32 Bit WindX can only access ODBC databases defined by the 32-bit ODBC server, and the 64 bit WindX can only access those defined by the 64-bit ODBC server.

Windows maintains 2 different lists of valid DSN names -- one for 32-bit applications, one for 64 bit applications.  The list checked will depend on the version of WindX you installed on the workstation.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: Code failure between PVX 9.1 and 15.1
« Reply #3 on: July 15, 2021, 04:24:49 PM »
@Mike - I had checked, but just rechecked. My Windx is 32 bit and the ODBC driver is 32 bit.  @Devon, msg(-1) is empty.  Any other ideas?

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Code failure between PVX 9.1 and 15.1
« Reply #4 on: July 15, 2021, 04:31:16 PM »
Checking MSG(-1) needs to be done on the workstation.

So when using WindX you need to call "[wdx]*windx.utl;Get_val" passing it "MSG(-1)", X$ then print X$.

Alternatively execute the open at command mode and issue:

EXECUTE "[wdx]PRINT MSG(-1)"

Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: Code failure between PVX 9.1 and 15.1
« Reply #5 on: July 15, 2021, 04:45:31 PM »
That was stupid on my part. Sorry.  Now we are getting somewhere:

42000: [Microsoft][ODBC Microsoft Access Driver ] Syntax error in FROM Clause

Michael

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: Code failure between PVX 9.1 and 15.1
« Reply #6 on: July 20, 2021, 08:53:49 AM »
Any word on this.  The only thing that has changed here is the PVX version.  This is a productions system and is limping along without an important feature.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Code failure between PVX 9.1 and 15.1
« Reply #7 on: July 20, 2021, 10:09:58 AM »
Do you get the error on the open or when attempting to run some SQL?

The error indicates some bad SQL syntax being sent to the driver. The Open doesn't send SQL to the driver generally.

I tested with version 15.00 here and the Access ODBC driver and I was able to do a open of a DSN without error and then execute SQL without error as well.

How is the SunnyLabel DSN setup?

try enabling set_param '!Q' to see what is being sent to the ODBC driver that may help diagnose the difference as well.
Principal Software Engineer for PVX Plus Technologies LTD.

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: Code failure between PVX 9.1 and 15.1
« Reply #8 on: July 20, 2021, 10:57:44 AM »
Devon, it is just on the open, but  I will do as you indicate.

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Re: Code failure between PVX 9.1 and 15.1
« Reply #9 on: July 20, 2021, 11:26:22 AM »
Devon,  at the 9.1 version I get no pop up when I do the open with '!Q' set.  on the 15.1 version, on the open -same exact line of code - I get "SELECT COUNT(*) FROM".  Again, this is on an open. The code for the open is at the top of this thread.  Same DSN accessed by the 9.1 and the 15.1 version.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Code failure between PVX 9.1 and 15.1
« Reply #10 on: July 20, 2021, 12:12:14 PM »
What are the exact version of the host pxplus and windx you are running?

i.e. xx.xx.xxxxx

Testing here with your line of code works for me in 15.10.0002 for the host and windx.
Principal Software Engineer for PVX Plus Technologies LTD.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: Code failure between PVX 9.1 and 15.1
« Reply #11 on: August 04, 2021, 09:22:29 AM »
There was a issue with [ODB] and WindX that was fixed in version 16.10. You may want to try using version 16.10 of WindX and see if that resolves your issue.
Principal Software Engineer for PVX Plus Technologies LTD.