Recent posts
#11
Language / Re: winqry ERR=42
Last post by edjack - April 08, 2026, 05:58:35 PMwe have no query's that even come close to 200 columns.
It must be something else.
It must be something else.
#12
Language / Re: winqry ERR=42
Last post by Jane Raymond - April 07, 2026, 09:05:39 AMIf the version is 13.10, then line 1875 is:
1875 LET _HideCol=NUM(_HideOpts$(i,1))
Error 42 would indicate that the subscript i is out of range. The _HideCol array is dimmed to 200, so if you have more than 200 columns in your query, this would cause the issue.
1875 LET _HideCol=NUM(_HideOpts$(i,1))
Error 42 would indicate that the subscript i is out of range. The _HideCol array is dimmed to 200, so if you have more than 200 columns in your query, this would cause the issue.
#13
Language / Re: winqry ERR=42
Last post by Devon Austen - April 06, 2026, 11:03:23 AMIs this still version 13.10?
If you open up that program on the system that gets the error is there a line 1875 and if so what is that code?
If there is no line 1875 you may have to open up a trace window and then cause the error to happen and then look through the trace.
Can you bypass your error handling to see if you can get the real line number?
If you open up that program on the system that gets the error is there a line 1875 and if so what is that code?
If there is no line 1875 you may have to open up a trace window and then cause the error to happen and then look through the trace.
Can you bypass your error handling to see if you can get the real line number?
#14
Language / winqry ERR=42
Last post by edjack - April 06, 2026, 07:59:24 AMI posted this in the past but never found a solution.
Getting ERR=42
Program .../lib/_plus/winutl/winqry
Line: 1875
Can someone point me in the right direction to solve this?
thnaks
Getting ERR=42
Program .../lib/_plus/winutl/winqry
Line: 1875
Can someone point me in the right direction to solve this?
thnaks
#15
Web Services / Re: Apache TimeOut and system ...
Last post by yonman - April 01, 2026, 09:11:58 AMFound the problem: The SkypeURIPreview bot was the source of the problem. The below was added to the client's Apache 2.4 extra\http-default.conf file:
SetEnvIfNoCase User-Agent "skypeuripreview" bad_bot
<Location />
<RequireAll>
Require all granted
Require not env bad_bot
</RequireAll>
</Location>
I hope this helps out members who may have this issue. Thank you to those members who responded to my post.
SetEnvIfNoCase User-Agent "skypeuripreview" bad_bot
<Location />
<RequireAll>
Require all granted
Require not env bad_bot
</RequireAll>
</Location>
I hope this helps out members who may have this issue. Thank you to those members who responded to my post.
#16
General Announcements / PVX Plus March 2026 Update
Last post by PxPlus - March 31, 2026, 04:01:36 PMStay up to date with everything happening at PVX Plus.
Check out our latest newsletter for important updates:
March 2026 Newsletter
Check out our latest newsletter for important updates:
- Modernization continues to evolve with new rounded controls capability
- Updated security with support for Authenticator Apps
March 2026 Newsletter
#17
Language / Never Mind -> Re: Program Alia...
Last post by Jerry Fletcher - March 27, 2026, 10:33:47 AMHi,
i think i figured it out. if i do somethign similar to this with a program it seems to work.
thanks
jerry
KEYED "PFXFILE",12
OPEN (1) "PFXFILE"
WRITE(1,KEY="ARFABC.SOA")"[odb]MAS90MFK;ARF_TermsCodeMasterfile;DB=MAS_AB
C;","KEY=TermsCode;REC=TermsCode:2+Description:30+DaysBeforeDue:3+DueDateADayOfMonth:1+DaysBeforeDiscDue:3+DiscDateADayOfTheMonth:1+
MinDaysAllowedInvDue:3+MinDaysAllowedDiscDue:3+DiscountCalcMethod:1,DiscountPercentage:19.7"
CLOSE (1)
i think i figured it out. if i do somethign similar to this with a program it seems to work.
thanks
jerry
KEYED "PFXFILE",12
OPEN (1) "PFXFILE"
WRITE(1,KEY="ARFABC.SOA")"[odb]MAS90MFK;ARF_TermsCodeMasterfile;DB=MAS_AB
C;","KEY=TermsCode;REC=TermsCode:2+Description:30+DaysBeforeDue:3+DueDateADayOfMonth:1+DaysBeforeDiscDue:3+DiscDateADayOfTheMonth:1+
MinDaysAllowedInvDue:3+MinDaysAllowedDiscDue:3+DiscountCalcMethod:1,DiscountPercentage:19.7"
CLOSE (1)
#18
Language / Program Alias
Last post by Jerry Fletcher - March 27, 2026, 09:29:26 AMHello,
I read the prefix documentation but I'm not sure if I am in the right place.
Is there a way to do the following in pxplus?
We have a program ARHIST.
When we call / perform or run it we want the system instead to call/perform/run ARHISTV2.
Is this possible without changing ARHIST and all it's entry points?
Thanks
Jerry
I read the prefix documentation but I'm not sure if I am in the right place.
Is there a way to do the following in pxplus?
We have a program ARHIST.
When we call / perform or run it we want the system instead to call/perform/run ARHISTV2.
Is this possible without changing ARHIST and all it's entry points?
Thanks
Jerry
#19
Language / Re: error 11 on write with no ...
Last post by James Zukowski - March 20, 2026, 09:38:58 AMAny insights? So we don't wander in the dark...
#20
Language / Re: error 11 on write with no ...
Last post by Michael Greer - March 20, 2026, 08:58:05 AMOk. never mind. I was misinterpreting what I was seeing. Thanks all for the suggestions.