PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC Ver 6 - 64bit vs 32bit with Division  (Read 1987 times)

mcohen

  • New Member
  • *
  • Posts: 2
    • View Profile
ODBC Ver 6 - 64bit vs 32bit with Division
« on: July 05, 2019, 04:01:45 PM »
I have the following query which causes the 64 bit application to crash.
select
IC_WAREHOUSE_ITM.ITEM_NUM
, IC_WAREHOUSE_ITM.WAREHOUSE
, IC_WAREHOUSE_ITM.ON_HAND
, (IC_WAREHOUSE_ITM.ON_HAND / 1 ) AS 'TEST'
from
IC_WAREHOUSE_ITM

I have installed 2 different 64 bit applications for testing purposes. I have also deployed a 32 bit application for testing purposes.
It works with the 32 bit driver V6.0 and V6.10, but not the 64 bit driver.
I have gone through the motions of validating both the client and server match for version number.
If I remove the /1 then it works in both cases.
Thoughts are appreciated.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC Ver 6 - 64bit vs 32bit with Division
« Reply #1 on: July 08, 2019, 04:11:11 PM »
I just tried this here and I do not get any crash. I get back the correct response for the query.

I am testing with one of my own files. Could it be that your file has some odd data in it that it triggering the problem?

I would suggest you create a helpdesk ticket if you want PVX Plus to look further into the crash issue.
Principal Software Engineer for PVX Plus Technologies LTD.

mcohen

  • New Member
  • *
  • Posts: 2
    • View Profile
Re: ODBC Ver 6 - 64bit vs 32bit with Division
« Reply #2 on: July 08, 2019, 06:10:27 PM »
Since this is working in your data and not mine, and it is working for me with 32 bit, I will ask if it is possible that your data is missing two possible situations.
One where the data is "0", and the other where the data is "NULL"?

The other question I should ask.
Are you using a client/server licensed scenario or are you going direct?
« Last Edit: July 09, 2019, 12:41:33 PM by mcohen »

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC Ver 6 - 64bit vs 32bit with Division
« Reply #3 on: July 10, 2019, 09:24:16 AM »
OK that was the reason I didn't reproduce the issue.

I tried with a table with 0 in the field and got the crash as described.

This is a bug in the ODBC driver and you will need to create a help desk ticket (http://helpdesk.pvxplus.com/) so we can track and resolve the issue.
Principal Software Engineer for PVX Plus Technologies LTD.