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.
Pages: [1]
1
Language / Maximum Number of Columns in a Report View List Box
« on: February 11, 2024, 07:38:07 AM »
There seems to be a limit to the number of columns a report view list box can have but I couldn't find any documentation for the limit.
I defined a list box with 267 columns. The first column is defined as S0 (not visible).
While scrolling to the right, the headings stopped scrolling at the 180th visible column.
However, the data for the remaining columns continued to scroll and display.
Is this a limit or a bug?
Is it pxplus or Windows?
Attached is a txt file containing the string used in the fmt= option.
I defined a list box with 267 columns. The first column is defined as S0 (not visible).
While scrolling to the right, the headings stopped scrolling at the 180th visible column.
However, the data for the remaining columns continued to scroll and display.
Is this a limit or a bug?
Is it pxplus or Windows?
Attached is a txt file containing the string used in the fmt= option.
2
Language / How to pass a com object string property greater than 32k?
« on: September 21, 2023, 06:52:21 PM »
I'm using a com object with a string property that I need to pass a value greater than 32k back and forth.
I think there's a trick to this if memory serves, but I couldn't find it.
I think there's a trick to this if memory serves, but I couldn't find it.
3
Web Services / *web/email question regarding running in background
« on: March 02, 2023, 06:27:04 PM »
This may be for the PxPlus team.
We have a background process that sends emails using *web/email.
This process is designed to handle any email errors reported by *web/email and continue running.
Recently that background process started hanging.
We discovered that that the email server credentials had changed.
Once we updated the credentials, the process stopped hanging.
So my question is what could be happening inside *web/email to cause the background process to hang instead of simply returning the authentication error?
PxPlus Version: 15.10
We have a background process that sends emails using *web/email.
This process is designed to handle any email errors reported by *web/email and continue running.
Recently that background process started hanging.
We discovered that that the email server credentials had changed.
Once we updated the credentials, the process stopped hanging.
So my question is what could be happening inside *web/email to cause the background process to hang instead of simply returning the authentication error?
PxPlus Version: 15.10
4
Programming / Knowing a Call from the Command Prompt VS from Program Code
« on: September 06, 2022, 11:03:13 PM »
Is there a way to know whether a program was called by entering the call from the command prompt vs. being called from a program line (such as running it or stepping into it)?
Given this program:
10 ! CALLED_PROG
20 ENTER ARG1$
30 IF SOMETHING THEN PRINT "CALLED FROM COMMAND LINE" ELSE PRINT "CALLED FROM PROGRAM"
40 EXIT
Call made from the command prompt:
->CALL "CALLED_PROG","TEST"
Call made from a program:
1010 CALL "CALLED_PROG","TEST"
What would SOMETHING be at line 30 in CALLED_PROG?
Keep in mind that in both cases, the name of the program being called could be referenced in a variable instead of quoted text.
I've played with the stk() function but that doesn't help if the call from the command line is done while stepping through a program because stk(-1) references the line/program stepped to.
I considered parsing the code pointed to by stk(-1) using lst(pgm(num(mid(stk(-1),1,5)),tcb(12)-1)), but even if the code at that line does in fact call the program, it still may have been called from the command prompt.
The one difference I am sure of is that when calling from a command prompt, there is no "next" statement to execute. Is there a way to know this?
Given this program:
10 ! CALLED_PROG
20 ENTER ARG1$
30 IF SOMETHING THEN PRINT "CALLED FROM COMMAND LINE" ELSE PRINT "CALLED FROM PROGRAM"
40 EXIT
Call made from the command prompt:
->CALL "CALLED_PROG","TEST"
Call made from a program:
1010 CALL "CALLED_PROG","TEST"
What would SOMETHING be at line 30 in CALLED_PROG?
Keep in mind that in both cases, the name of the program being called could be referenced in a variable instead of quoted text.
I've played with the stk() function but that doesn't help if the call from the command line is done while stepping through a program because stk(-1) references the line/program stepped to.
I considered parsing the code pointed to by stk(-1) using lst(pgm(num(mid(stk(-1),1,5)),tcb(12)-1)), but even if the code at that line does in fact call the program, it still may have been called from the command prompt.
The one difference I am sure of is that when calling from a command prompt, there is no "next" statement to execute. Is there a way to know this?
5
Programming / Looking for PxPlus based ERP Wholesale Distribution System
« on: June 24, 2022, 04:38:16 PM »
If you know of a solid ERP Wholesale Distribution System written in PxPlus, please provide contact and/or sales info.
Thanks,
Ken Sproul
Thanks,
Ken Sproul
6
Programming / *web/email error message (0/117)
« on: May 12, 2021, 08:16:19 PM »
I'm having trouble with *web/email returning an error 0 with the following message:
Sending to SMTP Server Failed: (0): Connect to SMTP Server: server-name;25 timed out. (0/117).
Pxplus Version: 15.10
Windows Version: Windows Server 2012 R2 Standard
I can open "[tcp]server-name;25" with no error. I can write smtp commands to the channel to send an email. I can use *web/mail to send an email with no error.
This same server has an older version of PxPlus and *web/email works fine with the older version.
I checked permissions in the pvx and lib directories and don't see any issues, although I cannot rule it out.
What is *web/email trying to do (assuming at line 117) that is resulting in a busy error?
New info. The server is a local smtp server on port 25 without user authentication. So I changed the server to "smtp.gmail.com;465-secure;username;password" using my own username/password and it worked without an error. Hopefully this is a clue.
Sending to SMTP Server Failed: (0): Connect to SMTP Server: server-name;25 timed out. (0/117).
Pxplus Version: 15.10
Windows Version: Windows Server 2012 R2 Standard
I can open "[tcp]server-name;25" with no error. I can write smtp commands to the channel to send an email. I can use *web/mail to send an email with no error.
This same server has an older version of PxPlus and *web/email works fine with the older version.
I checked permissions in the pvx and lib directories and don't see any issues, although I cannot rule it out.
What is *web/email trying to do (assuming at line 117) that is resulting in a busy error?
New info. The server is a local smtp server on port 25 without user authentication. So I changed the server to "smtp.gmail.com;465-secure;username;password" using my own username/password and it worked without an error. Hopefully this is a clue.
7
Language / Post Open Embedded IO Procedure with Direct Access File Path
« on: February 12, 2021, 05:11:57 PM »
When using an embedded IO procedure with a file that is being opened as the result of the direct access method in a read statement (see example below), is there any way to know that the file is being opened by direct access?
Example:
read ("custfile",key=custnum$)
Example:
read ("custfile",key=custnum$)
8
Language / rtf multi_line behavior change
« on: April 15, 2020, 05:49:54 PM »We noticed a change in rtf behavior between versions 12.50 and 15.10 when pasting a range of cells copied from excel. The cells in excel do not have any borders. However, in v12.50 the cells have borders after they are pasted into an rtf multi_line, whereas in v15.10, they do not.
While this appears to be a bug fix, it was also a nice "feature". Is there anything we can do to bring this "feature" back (i.e. object properties, parameters, etc.)?
9
Programming / Question about the end clause of a select / next record loop
« on: August 20, 2019, 03:01:45 PM »
Is an expression used in the end clause of a select / next record loop evaluated at every iteration?
10
Programming / hidden windows suddenly become visible
« on: May 23, 2019, 04:29:09 PM »
Has anyone experienced hidden windows suddenly becoming visible?
This just started happening at one of our client sites. They are running PxPlus v11.65 on a windows server and Windows 10 on the client side. A pxplus program will be running and after some time of not doing anything, the desktop will flicker and the hidden base window and a hidden menu window will suddenly be visible. This particular user has a laptop with two external monitors and the windows are all on one of the external monitors.
I'm wondering if it's a recent update to Windows or an anti-virus program triggering this. Any ideas?
This just started happening at one of our client sites. They are running PxPlus v11.65 on a windows server and Windows 10 on the client side. A pxplus program will be running and after some time of not doing anything, the desktop will flicker and the hidden base window and a hidden menu window will suddenly be visible. This particular user has a laptop with two external monitors and the windows are all on one of the external monitors.
I'm wondering if it's a recent update to Windows or an anti-virus program triggering this. Any ideas?
11
Language / sub() function with negative occurance not always working as expected
« on: April 30, 2019, 02:00:52 PM »
I'm not sure the sub() function is working correctly with a negative occurrence argument. Tried it in versions 12.50 and 15.10.
-}?sub("#####.000","###",",###",-1)
,#####.000
Shouldn't it return this?
##,###.000
Out of curiosity I tried this which works:
-}?sub("#####.000","#","0",-1)
####0.000
But this didn't:
-}?sub("#####.000","##","0",-1)
##0#.000
I would have expected ###0.000.
Is there an explanation or is this a bug?
-}?sub("#####.000","###",",###",-1)
,#####.000
Shouldn't it return this?
##,###.000
Out of curiosity I tried this which works:
-}?sub("#####.000","#","0",-1)
####0.000
But this didn't:
-}?sub("#####.000","##","0",-1)
##0#.000
I would have expected ###0.000.
Is there an explanation or is this a bug?
12
Web Services / *web/email not working with PxPlus Webserver
« on: April 18, 2019, 12:38:29 PM »
I have a PxPlus Webserver background process with a web request program that uses *web/email to send emails from the server. If I substitute it with *web/mail, the email is sent with no problem.
The message I'm getting from *web/email is:
Sending to SMTP Server Failed: (0): Connect to SMTP Server: unc-address;25 timed out. (0/115).
So why is *web/email having this problem and *web/mail is not? Any help will be appreciated.
The message I'm getting from *web/email is:
Sending to SMTP Server Failed: (0): Connect to SMTP Server: unc-address;25 timed out. (0/115).
So why is *web/email having this problem and *web/mail is not? Any help will be appreciated.
13
Language / Error 41 with list_box find due to negative index ...
« on: September 14, 2018, 08:44:11 PM »
A tree view list box has a large number of elements. The list_box read is returning a negative index that results in an error 41 when used with list_box find to look at elements above and below the current index. The item property doesn't error with the negative value, but accessing the itemtext$ property afterwards reslults in an error 11.
I coudn't find any index limits in the language reference, but it seems to be limited to something in the 32k range. Has anyone run into this and found a workaround? Is it a PxPlus or windows limit?
I coudn't find any index limits in the language reference, but it seems to be limited to something in the 32k range. Has anyone run into this and found a workaround? Is it a PxPlus or windows limit?
14
Language / 12.50 PxPlus on Server Changes to 12.51???
« on: August 15, 2018, 11:21:23 AM »
So we have PxPlus 12.50 installed on the server with matching windx on the clients. After some time goes by, the server reports version 12.51, but since windx still reports 12.50, nomads won't run. We haven't installed 12.51. Any idea how this version mismatch is happening?
Pages: [1]