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.
166
ODBC / Re: PXPlus SQL ODBC Driver w/ Command line
« on: April 17, 2020, 01:27:58 PM »
What is the command you are using when you get the error?
i.e. pxpsql -d "/home/myuser/app/data" "select * from 'mytable' where field1='this'"
i.e. pxpsql -d "/home/myuser/app/data" "select * from 'mytable' where field1='this'"
167
Language / Re: web/ftp regex question
« on: April 15, 2020, 02:14:37 PM »
The MSK() happens in the PxPlus program.
I think your problem may be that you include ^ at the start of your pattern. The pattern as passed into *web/ftp is automatically put between a ^ and a $ to ensure only whole matches return true.
If you remove the ^ from your pattern it should work.
I think your problem may be that you include ^ at the start of your pattern. The pattern as passed into *web/ftp is automatically put between a ^ and a $ to ensure only whole matches return true.
If you remove the ^ from your pattern it should work.
168
Language / Re: web/ftp regex question
« on: April 15, 2020, 11:53:39 AM »
Yes PxPlus 2017 should support *web/ftp regular expression via the M option.
Sorry when you said originally you were using version 14 my brain interpreted that as PxPlus 2014.
Sorry when you said originally you were using version 14 my brain interpreted that as PxPlus 2014.
169
Language / Re: web/ftp regex question
« on: April 15, 2020, 10:43:08 AM »
*web/ftp was enhanced to support full regular expressions using the M option starting with PxPlus 2016 update 0001. All versions released after that also had this enhanced version of *web/ftp.
PxPlus 2019 is newer then PxPlus 2016 so it will have the version of *web/ftp that supports regular expressions via the M option.
PxPlus 2019 is newer then PxPlus 2016 so it will have the version of *web/ftp that supports regular expressions via the M option.
170
Language / Re: web/ftp regex question
« on: April 15, 2020, 08:12:42 AM »
PxPlus 2014 does not support the M option (MSK( ) regular expression pattern matching) in *web/ftp. That ability was added in PxPlus 2016 update 0001.
171
Programming / Re: Printing to PDF - through WindX/Citrix connection
« on: March 27, 2020, 02:21:27 PM »
An error 15 is an OS error. If you print MSG(-1) you can sometimes get more info about the error. This info may help you figure out the problem.
172
ODBC / Re: ODBC fail w/ Office 2016 when using ORDER BY.
« on: March 25, 2020, 09:47:16 AM »
I would suggest trying a newer version of the ODBC driver as maybe you are encountering a bug that has already been fixed. There have been several bugs with order by that have been fixed. If the newer version does not resolve the issue then read on for ways to try to debug.
I have not had anyone report this exact issue. Generally the version of Excel should not make any difference. That you do see a difference makes me think that somehow a different SQL query is being generated in the newer Excel then in the older Excel. I would enable logging so you can see what the SQL query ODBC was asked to execute was. You then can compare the older Excel to the new Excel and any difference may lead you to the cause of the error.
I would also make sure you are doing the same procedure in the newer excel to execute the query as the old Excel. I would also make sure you are using the same ODBC version and DSN settings.
I have not had anyone report this exact issue. Generally the version of Excel should not make any difference. That you do see a difference makes me think that somehow a different SQL query is being generated in the newer Excel then in the older Excel. I would enable logging so you can see what the SQL query ODBC was asked to execute was. You then can compare the older Excel to the new Excel and any difference may lead you to the cause of the error.
I would also make sure you are doing the same procedure in the newer excel to execute the query as the old Excel. I would also make sure you are using the same ODBC version and DSN settings.
173
ODBC / Re: Can't install podb400 driver
« on: February 28, 2020, 11:12:59 AM »
That 17 year old software released by Best software not PVX Plus Technologies looks to be not compatible with the current version of Windows.
You have to either find an older version of Windows to run it on or use a newer version of the product. Newer version should still be able to access the data from the old Mas90 but obviously no guarantees.
If you have a current PxPlus license you can use our latest ODBC driver from our site, if not you can purchase a PxPlus license to use our ODBC.
Alternatively you can try the oldest ProvideX ODBC that still runs on Win10: http://www.pvxplus.com/downloads/sage/odbc/windows/client/4.xx/odbc-client-4.21.1000-windows-32bit-x86.exe
You have to either find an older version of Windows to run it on or use a newer version of the product. Newer version should still be able to access the data from the old Mas90 but obviously no guarantees.
If you have a current PxPlus license you can use our latest ODBC driver from our site, if not you can purchase a PxPlus license to use our ODBC.
Alternatively you can try the oldest ProvideX ODBC that still runs on Win10: http://www.pvxplus.com/downloads/sage/odbc/windows/client/4.xx/odbc-client-4.21.1000-windows-32bit-x86.exe
174
Programming / Re: Interact with external web sites
« on: February 27, 2020, 12:45:22 PM »
Check out "*plus/web/request" which is documented here https://manual.pvxplus.com/?Web%20Services/Overview.htm
It will allow you to get the HTML of the web page which you can parse.
It will allow you to get the HTML of the web page which you can parse.
175
ODBC / Re: pathnames in SQL selects
« on: February 27, 2020, 09:59:46 AM »
The table name in the SQL query must match a DD table name or a table name from a INI file. It is not possible to use a physical file path in the SQL query. Our ODBC driver uses standard SQL which requires a table name not a file path.
You will need to use the table name from the DD for the file. It is a required field so each entry in your DD has a unique name. If you don't like those names you can always define an INI file from the data dictionary entries and give them new names to be used by ODBC.
https://manual.pvxplus.com/?odbc/table_definitions/ini_definition.htm (Info about the layout of the INI used by ODBC)
https://manual.pvxplus.com/?odbc/table_definitions/generating_ini_table_definitions.htm (Info about how to programmatically generate an INI from your DD)
You will need to use the table name from the DD for the file. It is a required field so each entry in your DD has a unique name. If you don't like those names you can always define an INI file from the data dictionary entries and give them new names to be used by ODBC.
https://manual.pvxplus.com/?odbc/table_definitions/ini_definition.htm (Info about the layout of the INI used by ODBC)
https://manual.pvxplus.com/?odbc/table_definitions/generating_ini_table_definitions.htm (Info about how to programmatically generate an INI from your DD)
176
ODBC / Re: ODBC Client vs Server Version
« on: February 26, 2020, 01:50:44 PM »
Some versions are compatible some are not. Please check out: https://manual.pvxplus.com/PXPLUS/odbc/odbc_faq.htm#Mark10 for details.
They could not use the version 7 client with the version 5.10 file server. With the 5.10 file server the most recent client you can use is 6.00.0003.
They could not use the version 7 client with the version 5.10 file server. With the 5.10 file server the most recent client you can use is 6.00.0003.
177
Programming / Re: *browser: Can the debugging tools be accessed?
« on: February 25, 2020, 08:09:19 AM »
The developer tools are disabled in the *browser control.
You may be able to run the javascript directly in a chrome browser and use the developer tools there to debug.
You may be able to run the javascript directly in a chrome browser and use the developer tools there to debug.
179
ODBC / Re: Unknown PXPIO Opcode - 0
« on: January 03, 2020, 11:02:03 AM »
The opcode is how the PxPlus ODBC client communicates with the PxPlus ODBC file server. An invalid opcode suggests a mismatch between the file serve and ODBC client versions.
Please see the ODBC FAQ in our manual for reference of which ODBC client driver is compatible with which version of the file server.
https://manual.pvxplus.com/?odbc/odbc_faq.htm#Mark10
Please see the ODBC FAQ in our manual for reference of which ODBC client driver is compatible with which version of the file server.
https://manual.pvxplus.com/?odbc/odbc_faq.htm#Mark10
180
Registration and Setup / Re: Windows 2019
« on: November 26, 2019, 10:23:50 AM »
Yes PxPlus 2019 is supported on Windows 2019.
Note: If running large user counts as a service, they may need to adjust the OS memory size settings due to the newer OS.
We don't list supported version of Windows on the download page as Microsoft generally keeps everything compatible. The only rule to keep in mind is if the PxPlus that you want to run is older then the version of Windows it could not have been tested and you use at your own risk. That being said given Windows history of compatibility it probably will work fine.
Note: If running large user counts as a service, they may need to adjust the OS memory size settings due to the newer OS.
We don't list supported version of Windows on the download page as Microsoft generally keeps everything compatible. The only rule to keep in mind is if the PxPlus that you want to run is older then the version of Windows it could not have been tested and you use at your own risk. That being said given Windows history of compatibility it probably will work fine.