PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: 1 ... 8 9 [10]
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 ?
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?
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.
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).
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.
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
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.
Nomads / numeric data in grid cells: how to round?
« Last post by PMM_CAI on May 06, 2024, 05:22:23 PM »
Using PxP 2022. My question concerns formatting of data in numeric cells in a grid. In Format Definition, I assign a numeric variable name to my column; e.g. Cost. In my supporting program, I set the cost's format mask with

let detail_box.ctl'Column$="Cost",detail_box.ctl'row=0, detail_box.ctl'cellformat$="######0.00-"

In the PxP documentation, the CellFormat property redirects to the documentation about multi-line Fmt$ property, which says "Before being output, the number is rounded to the number of decimal places specified in the format mask." But when I test, it truncates, not rounds. (By the way, the incoming value does not exceed the mask.)

Is there a correct way of having numeric grid cell data round instead of truncate?

Thanks in advance.

Paula McKeever
CAI Software LLC
Programming / Re: Source code formatter
« Last post by Len Vassos on May 02, 2024, 11:03:16 AM »
Thanks for all your input.

Based on feedback from our developer community, we will be introducing a PxPlus extension for Visual Studio Code in PxPlus 2024 which is scheduled to be released later this month.
Programming / Re: Source code formatter
« Last post by pwhirley on May 02, 2024, 10:56:24 AM »
Thanks for the input.
I have not used line numbers in my code in many years, so changing line numbers doesn't bother me at all.  I also haven't used ED+ in many years, but I'll check it out and see if I can make use of it.  I really don't want to have to load individual programs to reformat them.  I would prefer to be able to process a whole folder full of source text at once.

Josh, you might want to check out the Eclipse plug-in.  Notepad++ is a good editor, but Eclipse is a full-featured integrated development environment which you can use at no cost.  With the plug-ins available (https://eclipse.sagemas.com) you get a decent editor and the ability to decompile programs, recompile with error flagging, a to-do list, very sophisticated search tool, integration to SVN or Git and much more.  You can automatically save your programs, classes and libraries to multiple locations such as a project space and a test system.

I'll let y'all know if I write something to format or if I figure out how to automate the existing ED+ tool.

Pages: 1 ... 8 9 [10]