Recent Posts
11
Nomads / Re: numeric data in grid cells: how to round?
« Last post by James Zukowski on May 09, 2024, 03:34:19 PM »As a possibility, you could enable it before the load and disable it immediately after. That would minimize the potential crash time.
12
Nomads / Re: numeric data in grid cells: how to round?
« Last post by PMM_CAI on May 09, 2024, 03:17:44 PM »Thanks James. 'RI' did the trick, although we haven't decided about using it yet, since we don't want the behavior to be used elsewhere, and we might not want to risk turning it on in the pgm and then aborting out before turning it back off. But we are considering it! Thanks again.
Paula McKeever
CAI Software LLC
Paula McKeever
CAI Software LLC
13
ODBC / Re: ODBC with latest MS Excel
« Last post by Devon Austen on May 09, 2024, 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.
14
ODBC / Re: ODBC with latest MS Excel
« Last post by Mike Hatfield on May 09, 2024, 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!!
15
ODBC / Re: ODBC with latest MS Excel
« Last post by Ken Sproul on May 09, 2024, 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?
16
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
17
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?
18
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.
19
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).
20
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.