PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - mcohen

Pages: [1]
1
ODBC / Re: ODBC Ver 6 - 64bit vs 32bit with Division
« 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?

2
ODBC / 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.

Pages: [1]