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


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

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

3
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

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

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

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

6
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

i.e.

SELECT * FROM "INTERNETITEM"

7
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

ENTER MYGRID

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>
<html>
<head>
</head>
<body>
[ttl]Grid[/ttl]<br>
[form]
[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]
[/grid]
[/form]
</body>
</html>



! myprog.pxp
 MAKEGRID:
ENTER MYGRID
 OPEN (HFN,IOL=GRIDIOL)"*memory*"
 LET MYGRID=LFO
 SELECT * FROM INTERNETITEM
 WRITE (MYGRID)
 NEXT RECORD
 EXIT
 GRIDIOL:IOLIST ITEMCODE$,ITEMNAME$,ITEMTYPE$

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:
https://manual.pvxplus.com?Webster/Webster%20Application%20Design.htm

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.

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

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

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

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

12
Programming / Re: Error 114 recovery
« on: January 16, 2024, 12:42:36 PM »
Did you also try the filxvlr2 program?

13
Programming / Re: Error 114 recovery
« on: January 16, 2024, 12:05:05 PM »
Check out this forum post form Tips and Tricks: https://forum1.pvxplus.com/index.php?topic=39.0

It details the best way to try to recover keyed files.

14
Wish List / Re: constantly visible scrollbar buttons
« on: December 15, 2023, 10:08:13 AM »
PxPlus uses the standard Windows scrollbars. So how they look is largely up to Windows. With Windows 11 they seems to hide the arrows indicating the buttons unless you mouse over them.

A spinner control is just a multi-line with a scrollbar where you just see the buttons. If on Win 11 you only see the buttons when hovered over. I don't think the auto hide setting will have any effect as the scrollbar PxPlus generates for the spinner control aren't hidden it is only the arrows.

A quick look and it doesn't seem Windows 11 allows you to control this behavior of the standard scrollbar.

Something we are considering for a future version of PxPlus is to enhance the spinner control giving developers more control over how it looks. This would mean not using the standard windows scrollbar and getting this auto hide arrows behavior.

15
Programming / Re: create a pivot table
« on: December 01, 2023, 11:50:07 AM »
Glad you resolved your issue.

Thanks for sharing the answer.

Pages: [1] 2 3 ... 19