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 ... 16
1
Programming / Re: Drag and Drop
« on: January 24, 2023, 08:05:24 AM »
You can allow external applications to drop file names onto a list box by using this directive.

    DROP FILE ON dest_ctl_id RETURN new_ctl_id

Whenever a file is dropped onto the dest_ctl_id control, the system will generate the CTL event specified by new_ctl_id.

The application can get a list of the file pathnames being dropped from the FIN(0, "DROPFILES") function call. All pathnames will be fully expanded and separated by a SEP character.

This can be found in the docs here: https://manual.pvxplus.com/?directives/drop_on.htm#filedrop

2
ODBC / Re: sorry for topic where is the catalog on odbc
« on: January 09, 2023, 09:44:35 AM »
When defining a catalog you can specify just a data dictionary. You can leave the ini field blank if you have no INI defining files.

What you specify in the data dictionary field is the path to the providex.ddf file that got created when you created a dictionary. This will be in your application directory likely with your other program files and data files.

For example if the DDF is located at C:\myapp\data\providex.ddf, then use C:\myapp\data.

The catalog is just telling the PxPlus SQL server where the data is. Defining it on the server means clients don't have to know where the data is and just point to a catalog to access the data defined in it.

Make sure the PxPlus SQL ODBC driver is the same version as the PxPlus SQL Server for compatibility. Older versions did not use the catalog and won't have the field.

3
Programming / Re: Server parameter in CALL "*web/sftp;receive"
« on: January 09, 2023, 09:34:24 AM »
Using ; should always work.

What is the error you got when using ;?

4
ODBC / Re: join left and right join tables
« on: January 09, 2023, 08:54:10 AM »
Some descriptions of the different joins are found here: https://manual.pvxplus.com/?odbc/using_odbc_driver.htm
Some examples are foudn here: https://manual.pvxplus.com/?odbc/using_odbc_driver/example_sql.htm

My guess is this is what you want.

select * from { OJ (IM1_inventoryMasterFile  left outer join IMA_ProductLine   on IMA_ProductLine.ProductLineCode=IM1_inventoryMasterFile.productLine)  left outer join AP1_VendorMaster  on AP1_VendorMaster.VendorNumber=IM1_inventoryMasterFile.PrimaryVendorNumber  } where IM1_inventoryMasterFile.itemnumber=:pprod

Not that if you are using the PxPlus SQL ODBC driver version 6 or higher you can simplify  the syntax to remove the { oJ }

select * from (IM1_inventoryMasterFile  left outer join IMA_ProductLine   on IMA_ProductLine.ProductLineCode=IM1_inventoryMasterFile.productLine)  left outer join AP1_VendorMaster  on AP1_VendorMaster.VendorNumber=IM1_inventoryMasterFile.PrimaryVendorNumber where IM1_inventoryMasterFile.itemnumber=:pprod


6
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.

7
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.

8
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.

9
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)

10
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.

11
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


12
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.

13
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.

14
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?

15
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 123.123.123.123 -p 4093 "SELECT * FROM 'View: actcodf0'"

Pages: [1] 2 3 ... 16