PxPlus User Forum

Twitter Twitter Twitter

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.

Messages - Devon Austen

Pages: [1] 2 3 ... 15
Language / Re: cvs base64:ascii bug
« on: November 14, 2022, 12:12:07 PM »
I think you are right and that is a bug.

Please create a helpdesk ticket so we can properly track the bug and let you know when a fix is available.

Nomads / Re: Dependency problem
« on: October 25, 2022, 08:18:31 AM »
You have defined 2 dependencies.

You first dependency will disable the control if the condition is TRUE. Since you selected invert it will also enable the control when the condition is FALSE.

The second dependency will enable the control if it is TRUE.  Undoing the result of the first dependency.

With these rules you will never have the control disabled. If the first rule disables the second rule will enable it.

The easier fix is to remove the second dependency you have defined. You just need the one with the invert checkbox checked. With invert it will handle both  the disable and enable.

Language / Re: Error 15 in *plus/web/request
« on: September 27, 2022, 04:18:29 PM »
This is just a guess but it sounds like what you are trying to access for your original test is not accessible from your machine. I would check firewall and to make sure you are on the correct network to access the resouce.

Language / Re: Error 15 in *plus/web/request
« on: September 27, 2022, 01:52:25 PM »
I just tested 12.50 on CentOS 6 and I could use

Code: [Select]
call "*plus/web/request","https://tls-v1-2.badssl.com:1012/","",result$,rhdr$
The rhdr$ result indicates it connected successfully via TLS 1.2.

Maybe the looking at the error message from the OS will help. When you get the error do a

Code: [Select]
print  MSG(-1)

Wish List / Re: Mass comment out and uncomment in IT editor
« on: September 22, 2022, 08:43:29 AM »
IT and ED+ are both good choices. ED+ is newer and was developed to provide a way that would work on the web and not just with Windows.

They both accomplish the same task and you can use the one that you are most comfortable with and you find the most useful.

You can also use both to edit the same file if you find there is a feature in one but not the other. Just use ED+ for the comment feature and do the rest of the editing in IT for example.

Wish List / Re: Mass comment out and uncomment in IT editor
« on: September 22, 2022, 08:08:08 AM »
You can do this with the ED+ editor using the CTRL + / keyboard shortcut.

ED+ is built using the open source Ace Editor so most of the keyboard shortcuts listed here work: https://github.com/ajaxorg/ace/wiki/Default-Keyboard-Shortcuts

Nomads / Re: Nomads - Signature Capture and Touchscreen
« on: September 21, 2022, 08:03:39 AM »
The issue was in the embedded chromium browser component so unfortunately you can't just grab an updated lib program from the new version. You will need to use version 19.10 for the fix. This can be done though with a version 18 license. It will just run with new v19.10 features disabled which should be fine since you just want the bug fix.

Nomads / Re: Nomads - Signature Capture and Touchscreen
« on: September 20, 2022, 01:34:18 PM »
The fix was on the PxPlus side and is included in the latest version 19.10 update.

Programming / Re: Error 13 on [tcp] connection with secure
« on: August 02, 2022, 11:07:20 AM »
Is this on Windows or a UNIX/Linux. If UNIX/Linux what distributions are you running?

PxPlus supports TLS 1.2 as of version 14 (PxPlus 2017). Since you are using version 15.1 TLS 1.2 support is there so my guess is you are on a older Linux distribution that has an older OpenSSL without TLS 1.2.

You do say it worked with postman which I would assume also uses the OS OpenSSL so I could be wrong and something else like a bad install over an old PxPlus may be at play here. Or maybe postman has built-in OpenSSL?

ODBC / Re: ODBC and views not working
« on: August 02, 2022, 10:58:28 AM »
As long as the PxPlus pointed to via ViewLib= in the pxpsqlsvr.conf is the same architecture (i.e. 64-bit or 32-bit) as the installed PxPlus SQL Server then you should be able to access view.

For example I would setup a PxPlus SQL Server and the PxPlus that are both 64-bit.

Another thing to rule out is Excel not liking the views. You can use the PxPlus SQL command line client to test a query against the view to see if you get back the data. If you do then the issue is Excel does not like something about the view. If that is the case there is a different way from excel to access the ODBC and therefore view that may work.

C:\PVX Plus Technologies\SQL ODBC Driver (64-bit)\pxpsql.exe --catalog Ref_Prod_Views -s -p 4093 "SELECT * FROM 'View: actcodf0'"

Programming / Re: Error 13 on [tcp] connection with secure
« on: July 29, 2022, 11:37:01 AM »
On the [TCP] open specify the "TLS1.2" option to force pxplus to use TLS1.2 which is the newest protocol it supports and the most likely to be accepted. Without specifying that the server may be detecting that PxPlus supports a older unsupported protocol and rejecting it.

Programming / Re: *web/sftp directory delimiters
« on: July 21, 2022, 02:52:41 PM »
To better help you I would need to see the type of call you are making to *web/sftp. Make sure not to include any actual private info when posting the example i.e usernames and passwords.

What error are you getting and why do you think the delimiter is being stripped?

As far as I know the *web/sftp program does not strip any trailing delimiters off. In fact we often add a trailing delimiter if missing in the code. Our tool uses curl and it is possible it may be doing something but I have not seen any issues before.

Programming / Re: *web/sftp
« on: July 12, 2022, 08:28:11 AM »
Hi Peter,

If you can sometimes download the file and other times you can't that would possibly indicate the issue is on the sftp server. Likely sometimes the file is locked by a program updating it for example. The best you can do in that situation is to handle errors like that by trying again a few times before giving up.

Another probably less likely possibility is that sometimes your current directory is different so maybe using a absolute path would help /HOME/USERNAME/PO/OUT

ODBC / Re: Error while update mssql Database via ODBC
« on: July 06, 2022, 12:37:06 PM »
From the doc: https://manual.pvxplus.com/?PxPlus%20User%20Guide/Data%20Integration/Introduction%20to%20SQL/Using%20SQL%20Directly%20Within%20PxPlus.htm

I think you need to add a ! to the beginning of your SQL statements i.e. KEY="!"+SEL_STRG$

Pages: [1] 2 3 ... 15