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 ... 19
ODBC / Re: ODBC with latest MS Excel
« on: May 09, 2024, 08:03:51 AM »
Hi Mike,

The newer option "From Other Sources->From ODBC" will show PxPlus ODBC data sources and you can use it to get at your data. The only exception being if you are using a version of PxPlus ODBC driver older than version 6.

Programming / Re: To ERR 65 or not to err 65
« on: May 07, 2024, 11:14:26 AM »
Both version 12.5 and version 20 normally return a error 65 if you try to use a control handle already in use.

Your PxPlus 12.5  likely has something in the START_UP that is making it ignore the error.

I would compare the START_UP of both versions and you may find your answer there.

ODBC / Re: ODBC Service Crashing
« on: April 26, 2024, 09:40:14 AM »
The crash is happening in a Microsoft Windows DLL: ntdll.dll.

Is this only happening on this one Windows system?

Is it reproducible on other systems?

Programming / Re: strange error 61
« on: April 16, 2024, 07:52:52 AM »
One of the reasons for a error 61 is:

   •  When using WindX, remote access ('WindX authorization') has been denied.

Is this running via WindX?

If so make sure you have your WindX Security setup correctly to not deny access.

For info about WindX security check here:


ODBC / Re: ODBC output from UPS Worldship
« on: February 21, 2024, 10:30:45 AM »
I am not sure what application you are using that is interfacing with the PxPlus ODBC driver, so I can only make guesses.

It seems it is generating a insert with parameters to allow users to specify the insert values.

I don't know if that is supported for insert and update.

I tested a similar INSERT here with a newer version and I get a parameter missing error or a parameter not supported error when I try it not the errors you report.

Maybe prevent the ODBC client application from using parameters for this insert and have it specify the values if possible.

ODBC / Re: slowing down an ODBC query
« on: February 20, 2024, 03:29:31 PM »
The PxPlus SQL ODBC driver has some options that may help.

Goto the Options tab of the DSN setup page for the PxPlus ODBC client install. There you will find two options that may help.

Dirty Read - Check box for Dirty Read mode of operation to skip the normal file consistency checks.

                   Dirty reads can speed file processing by reducing the number of locks issued against a file. However, this may result in inconsistent data should the file be updated while being read by
                   the PxPlus SQL ODBC Driver.

Burst mode - Check box to enable Burst mode. This helps reduce some of the overhead created by temporary locks.

                      With Burst mode set, the PxPlus SQL ODBC Driver locks the file header for either 50 file operations or three-tenths of a second, whichever occurs first. This decreases the number of
                      times the file must be locked and the number of times that internal buffers may need to be reloaded. Refer to the next paragraph below for an explanation on the effect of temporary

I suspect dirty reads may be of the most help to you.

ODBC / Re: odbc let connect but not accept user login
« on: February 12, 2024, 08:12:09 AM »
From the documentation: https://manual.pvxplus.com/?odbc/configuration_procedures/security_dll.htm

on Sage MAS 90 or Sage MAS 200 systems and passwords will not be validated and should not be used.

I think that you just need to leave the password field blank based on the documentation.

Webster Plus / Re: grid display using program - grid does not show
« on: February 12, 2024, 08:05:38 AM »
Does the file INTERNETITEM have records in it?

Does the fields defined for INTERNETITEM match the IOL used in your program?

ODBC / Re: catalog on odbc
« on: February 05, 2024, 08:16:20 AM »
Make sure the Server Name or IP, port, and catalog fields are empty. If accessing local data they should not have a value because you don't need to connect to the server. Then make sure you define the path to the Data Dictionary on the first tab.

If you still have issues you can reply to this post with your connection string (found on the debug tab). That may help us understand the issue. Just make sure to strip out and usernames and passwords.

Please try to avoid creating multiple posts for the same topic. I will delete the other posts to avoid confusion.

Webster Plus / Re: grid display using program - grid does not show
« on: February 02, 2024, 02:54:40 PM »
Is the channel number for a open file in the variable INTERNETITEM of is the name of the file INTERNETITEM. If that is the name of the file you are just missing quotes in the select statement



Webster Plus / Re: grid display using program - grid does not show
« on: February 02, 2024, 09:10:03 AM »
Hi Jon,

When debugging a Webster issue the first step is to hover over the red highlighted section on the page. The tool tip will give you error information which will help you figure out your issue.

I believe your issue is that your page does not have a [form] and the grid needs to be in a [form].

You also need to add


right under the MAKEGRID: line

This is how the grid program can pass back the handle to the grid memory file.

So try this:

<!DOCTYPE html>
[grid MyGrid program="myprog.pxp;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=2]

! myprog.pxp

Normally you would have a program= in the [form] to specify the program to run when form is submitted and that would handle any events on the page.

For information on the use of the form see here:

For the need for the ENTER you can see the program= short code documentation here: https://manual.pvxplus.com?Webster/Short%20Code%20Options.htm

It looks like we need to update the example on the Using Grids in Webster+ documentation page to include the ENTER statement as that is missing.

Language / Re: ESCape key trapping
« on: January 25, 2024, 03:08:47 PM »
Make sure you do it in order i.e. you have to do enter first. then Esc, then ctrl-c, and finally ctrl-break. If you do it in a different order or don't do them all you won't get the same result.

Language / Re: ESCape key trapping
« on: January 25, 2024, 02:01:13 PM »
Hi James,

That ESC maps to CTL 4 the same a F4 is not a mistake. It has not changed as far as I am aware.

I tested the example program for format 3 and I got the results described in the documentation which were the expected results. Did you manually do the setesc on and off before the two runs?

Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: January 25, 2024, 12:20:39 PM »
Hi Jon,

Did you just switch the license used or did you switch from 32-bit to 64-bit as well. Or did you switch to a different install?

One thought is anti-virus software could be doing scans on the new install but the old one was white listed?

Programming / Re: How to send a POST request using *BROWSER
« on: January 24, 2024, 12:45:44 PM »
Hi Chris,

No you aren't doing it wrong it is just that *browser does not currently support doing a POST.

As Mike suggested you can use *plus/web/request to do the post and get the response. Then if there is a page to display use *browser to display it. If you are not displaying anything *plus/web/request will be much faster since it doesn't have to load a whole browser to do the request it just does it directly via TCP/IP requests.

Pages: [1] 2 3 ... 19