Recent Posts
1
ODBC / Re: ODBC with latest MS Excel
« Last post by Devon Austen on Today at 08:03:51 AM »Hi Mike,
The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.
The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.
2
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on Today at 04:54:37 AM »Hi Ken, That is true but it doesn't allow the selections from the PxPlus ODBC 32/64 interface.
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
Typical of Microsoft to remove a feature that half the world uses without any explanation of how to work around.
However, I have done some research and I believe I have the solution.
You have to click on File - Options - Data
In Show Legacy data import wizards
tick From Data Connection Wizard (legacy)
tick From Microsoft Query (legacy)
OK
Back in the Spreadsheet
Click Data
Click Get Data
then in the Dropdown you will see Legacy Wiards - From Microsoft Queary (Legacy)
Et Voila!!
3
ODBC / Re: ODBC with latest MS Excel
« Last post by Ken Sproul on Today at 01:06:50 AM »Mike,
I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)
On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
Under "From Other Sources" is "From ODBC" among a bunch of other options.
What Version do you have?
I just applied the latest updates to Office 365.
My Excel is now showing: Version 2404 (Build 17531.20140 Click-to-Run)
On the Data ribbon the section Get & Transform Data still exists with a Get Data drop-down that contains:
- From File
- From Database
- From Azure
- From Power Platform
- From Other Sources
- Combine Queries
- Launch Power Query Editor...
- Data Source Settings...
- Query Options
Under "From Other Sources" is "From ODBC" among a bunch of other options.
What Version do you have?
4
ODBC / ODBC with latest MS Excel
« Last post by Mike Hatfield on May 08, 2024, 10:10:34 PM »I see that MS Excel - Data - Get Data - Other Sources- MS Query has disappeared from the latest version of Excel.
How do we now run PxPlus ODBC ?
Thanks
How do we now run PxPlus ODBC ?
Thanks
5
Nomads / Re: numeric data in grid cells: how to round?
« Last post by James Zukowski on May 08, 2024, 08:44:49 AM »Not sure if this would apply... Have you checked out the 'RI' and 'RN' parameters?
6
Nomads / Re: numeric data in grid cells: how to round?
« Last post by PMM_CAI on May 08, 2024, 07:55:20 AM »I neglected to mention that I cannot convert the data to string prior to loading the grid. It needs to be numeric so that it gets exported as numeric data to a spreadsheet.
7
Programming / Re: To ERR 65 or not to err 65
« Last post by Mike King on May 07, 2024, 02:39:50 PM »Looking at what you posted you will notice that when the error was not reported you are connecting via WINDX whereas you get the error when connected directly. You can tell this by the command line prompt -> versus -}.
If you have enabled WindX Turbo Mode (which is done be default in Nomads) duplicate CTL errors will not be reported back to the server but instead will be reported locally and reported only if the WindX setup enables local error reporting (default is not enabled).
WindX and Nomads are designed to maximize performance by running in Turbo Mode as no errors are anticipated. This allow the system to run faster by not waiting for the WindX to report success or failure (much like UDP if you are familiar with that network protocol).
If you have enabled WindX Turbo Mode (which is done be default in Nomads) duplicate CTL errors will not be reported back to the server but instead will be reported locally and reported only if the WindX setup enables local error reporting (default is not enabled).
WindX and Nomads are designed to maximize performance by running in Turbo Mode as no errors are anticipated. This allow the system to run faster by not waiting for the WindX to report success or failure (much like UDP if you are familiar with that network protocol).
8
Programming / Re: To ERR 65 or not to err 65
« Last post by Devon Austen on May 07, 2024, 11:14:26 AM »Both version 12.5 and version 20 normally return a error 65 if you try to use a control handle already in use.
Your PxPlus 12.5 likely has something in the START_UP that is making it ignore the error.
I would compare the START_UP of both versions and you may find your answer there.
Your PxPlus 12.5 likely has something in the START_UP that is making it ignore the error.
I would compare the START_UP of both versions and you may find your answer there.
9
Programming / Re: To ERR 65 or not to err 65
« Last post by martinp on May 07, 2024, 10:50:57 AM »Must be due to an upgrade in pxplus that causes this perhaps due to object properties? I dont know if any PRM would help you here.
Can you add an err=*NEXT to your controls... This must be some legacy code?
0010 BEGIN
0020 MULTI_LINE 115,@(10,10,10,10)
0030 MULTI_LINE 115,@(10,10,10,10),ERR=*NEXT
0040 ESCAPE
Can you add an err=*NEXT to your controls... This must be some legacy code?
0010 BEGIN
0020 MULTI_LINE 115,@(10,10,10,10)
0030 MULTI_LINE 115,@(10,10,10,10),ERR=*NEXT
0040 ESCAPE
10
Programming / To ERR 65 or not to err 65
« Last post by Cees Trip on May 07, 2024, 08:00:26 AM »Hello all,
I'am puzzeld. We are, sadly, leaving pxplus behind for a ERP in Business Central. To keep access to our old pxplus files I purchased a 2 user pxplus windows licence. Now I am trying to get selected parts of out present programs working in windows.
Now I'm experiencing something crazy. Under the old version 12.500000 I don’t get a error 65 when I create an existing window element multiple times. Also no error when making it visible, hide etc.
Under windows (version 20.100000) I do get an error 65. See Attachment.
Maybe I changed some in our old software at some point. I don't remember what, though. I would appreciate it if anyone could help me with this.
I'am puzzeld. We are, sadly, leaving pxplus behind for a ERP in Business Central. To keep access to our old pxplus files I purchased a 2 user pxplus windows licence. Now I am trying to get selected parts of out present programs working in windows.
Now I'm experiencing something crazy. Under the old version 12.500000 I don’t get a error 65 when I create an existing window element multiple times. Also no error when making it visible, hide etc.
Under windows (version 20.100000) I do get an error 65. See Attachment.
Maybe I changed some in our old software at some point. I don't remember what, though. I would appreciate it if anyone could help me with this.