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 ... 15 16 [17] 18 19
241
ODBC / Re: CatalogName
« on: October 12, 2018, 08:03:27 AM »
Hi Ben,

Check out the pxpsqlsvr.conf.sample file that came with the installation for an example and a description.

You can also read the documentation about the new catalog setup for the server here https://manual.pvxplus.com/?odbc/configuration_procedures/server_settings_unix_linux.htm

Also for clarity here is an example from one of my pxpsqlsvr.conf files

Code: [Select]
catalogs:
default=*[/myapp/data][][]

In this example I defined a catalog named default which pointed to the data dictionary located at /myapp/data and it does not have an INI file or prefixes

In you ODBC client DSN under the server tab you would then specify default as the catalog name to connect to data from the /myapp/data dictionary.

This is so a server could define multiple catalogs and so that clients do not have to know anything about the server or where the data is on the server.

242
Programming / Re: slow msgbox
« on: October 10, 2018, 11:28:46 AM »
Generally a MSGBOX call just results in a system call to Windows to display a message box. Unless you set your system up to use custom message boxes.

Is your 'MX' system parameter ON? If so are you using the default custom message box (*ext/system/msgbox.gui) or are you using a user-defined message box (*ext/msgbox.gui)?

243
Programming / Re: slow msgbox
« on: October 10, 2018, 10:02:46 AM »
My Windows is also 64-bit.

I tried PxPlus 2017 (V14) and I still do not see a delay.

Are you using WindX? If so what OS is the server running on?

I would suspect something to do with your setup as I am not seeing this issue here.

244
Programming / Re: slow msgbox
« on: October 10, 2018, 09:27:54 AM »
I just tested here with PxPlus 2018 (V15.00.0002) and all message boxes come up instantly. I can see no difference if there is a title or a default title.

I'm on Windows 10 Pro Version 1803.

245
Programming / Re: provide many PNGs to WindX
« on: October 09, 2018, 09:29:13 AM »
The WindX Auto Download I mentioned is actually two features: one is what you already tried the dynamic download, the other is static download. I think static download is more helpful in your case as you could have all your images in a directory and in the sync.conf file specify you want that directory synced. Thus a client system would always have that directory downloaded the first time it connects. If you ever update any of the images or add new images all the clients will get updated the next time they connect.

If you still want to go the DLL route you have to be aware of how PxPlus deal with resource DLLs. oldimages.dll is an internal use DLL you can't open it up and add your own images to it. You would need to create your own DLL with your images and name it PLUSLIB.DLL and put it in the same directory as the pxplus.exe. PxPlus requires that the first resource DLL must be named PLUSLIB.DLL. You can have a second resource DLL and name it what you want but then you have to tell PxPlus about it via the INI file or the 'OPTION' mnemonic. This is documented here https://manual.pvxplus.com/?pluslib1/sect1.1/c.htm


246
Programming / Re: provide many PNGs to WindX
« on: October 05, 2018, 01:40:28 PM »
The PNG image format is a compressed image format. This means it is already compressed and putting it in a zip file will give you very little extra compression. I just did a test here and a 349kb png zipped to a 329kb.

Your best option is probably to take advantage of the WindX auto download feature have the the system automatically copy the images to the client system for you and not worry about compression as the images are already compressed.

Details on the auto download feature can be found here https://manual.pvxplus.com/?windx/autoload.htm

247
FAQs / Does PxPlus Run on Windows Subsystem for Linux (WSL)
« on: October 05, 2018, 10:22:27 AM »
A new feature introduced in a Windows 10 update is Windows Subsystem for Linux (WSL). WSL lets users run a Linux environment directly on Windows without the need of a virtual machine. A few different Linux distributions are currently supported: Ubuntu, Debian, openSUSE, SUSE Enterprise, and Kali.

PxPlus will install on WSL but it will not function 100% correctly. The problem is that WSL is not a complete Linux environment and does not support all of the necessary OS functions needed by PxPlus (https://github.com/MicrosoftDocs/WSL/blob/live/LTP_Results/15014/Syscalls.txt). In particular, PxPlus is not able to do file or record locking when running under WSL. That being said, it is possible to run PxPlus on WSL if you are only trying to do some basic testing with a single user.

According to Microsoft, the WSL is designed with the purpose of running Linux command line tools directly on Windows. It was not designed to be a full Linux environment and run all Linux applications or any production applications (https://docs.microsoft.com/en-us/windows/wsl/faq#can-i-run-all-linux-apps-in-wsl).


248
Programming / Re: client time
« on: September 20, 2018, 09:32:30 AM »
I missed that you were not using Windx but RDP. What I suggested would only work if you are using WindX.

Mike is right that there is no easy way to get the client time when everything is running on the server except the RDP client.

249
Programming / Re: Windx cannot find Server
« on: September 20, 2018, 08:54:27 AM »
I would check the Windows firewall on that machine.

I would also look into the antivirus/internet security software that machine is running.

I hope that helps.

250
Programming / Re: client time
« on: September 20, 2018, 08:51:10 AM »
Have you tried:

Code: [Select]
EXECUTE "[WDX]dte(0:"%hz:%mz %P")"
or if the code also needs to run not on windx

Code: [Select]
EXECUTE "[LCL]dte(0:"%hz:%mz %P")"

251
Programming / Re: *web/email Outbox
« on: September 19, 2018, 09:33:01 AM »
If you are not getting an error and the eraseit argument is 1 then it should delete the files from the Outbox/new directory.

It erases the file here when I do a test with PxPlus 2018. Maybe there is something off with how you are calling *web/email. Can you include your line of code that does the call. Make sure to redact the username password for your smtp2go account. Also include what the value of any variables are.

Can you also try to copy the *web/email and *web/smtp programs from PxPlus 2018 to make sure it is not an issue that was already fixed, or a issue caused by in in-place upgrade, or an issue caused by custom changes.

252
Programming / Re: *web/email Outbox
« on: September 18, 2018, 11:12:09 AM »
All it does is after sending the end of message to the server it waits for a status response. If the status response is not an error and eraseit = 1 then it will delete the message.

I assume your call is not returning an error and errormesg$ does not contain an error message after the call.

253
Programming / Re: FTPS instead of FTP or SFTP
« on: September 12, 2018, 03:17:52 PM »
I haven't tried this and don't know if it will work but have you tried specifying ftps:// and the port when using *web/ftp.

CALL "*web/ftp;receive", "ftps://vendorServer:990", user$, password$, 0, "someFile.ext", download_dir$, case$, result$

FTPS is just FTP+SSL and behind the scenes we use curl which supports FTPS so it may be as a simple as that. If that doesn't work likely we would need to update the utility to try to support it. In which case I recommend creating a wish list forum post so we can gauge interest.


254
ODBC / Re: Extract on ODBC Sql Server
« on: August 22, 2018, 03:10:02 PM »
Likely you need "CONCURRENCY=LOCK" and "EXTROPT=(UPDLOCK)" in the open options or in the [ODBC] INI section. You can put it in the INI if all of your ODB opens will be to a MS SQL db if not use the open options on the [odb] open to the MS SQL db.

255
Wish List / Re: modernize the documentation
« on: August 17, 2018, 09:01:20 AM »
Hi Thomas,

The examples in the POS() function documentation all look correct. An example in the documentation does not necessarily mean a code/program example. In the case of the POS() function and probably a lot of the other functions the example is just of use of the function. It shows you a specific call to the function and the example tells you what the result is. Obviously if you want to use the function in a code/program you need to do something with the output or you will get a error 20.

Making every example in the documentation actual code/program examples would possibly make the examples less concise.

By necessity the documentation must assume a basic understanding of PxPlus syntax. The basics are documented but all that info can't be on every page of the documentation. Beginners need to learn some of the basics like, that it is a syntax error to call a function and do nothing with the return value, and how line numbers work. If they do that they they should have no problem with the documentation.

Pages: 1 ... 15 16 [17] 18 19