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.


Topics - Dave Fullerton

Pages: [1]
1
Off Topic / Ontario derecho storm
« on: May 25, 2022, 01:50:22 PM »
Hi folks:

I am just wondering if the derecho storm that hit Ontario over the weekend has impacted Pvx+'s ability to reply to support ticket requests.  Does anyone know if they are operational?

Regards

Dave Fullerton

2
Language / Intermittent error 261 and 278
« on: June 09, 2021, 05:05:29 PM »
Hi folks:

We have a client that has just changed their servers and configuration.  The user workstations are UserVMs: Windows 10 1909, Servers are 2019 Standard, and they are using ESXI Hosts: 7.0.  Under this configuration, the client is running our application in a mapped drive configuration.  Intermittently, a user will get an error 261 - Invalid/output or error 278 Invalid argument, usually in *winproc.  The PxPlus level was 12.5 but I upgraded them to 16.2 with the same results.

I have gotten connected to the workstations that have experienced the issue, and can bash the software around and I won't get any error - things work as expected.  I get out, and shortly after, while doing something reasonably mundane, the system hangs, and the user sees the stack level and the console prompt running down the screen when they press the Enter key. 

The error 278 happened on this statement
0320 let _header_obj_type$=""; read (%scr_lib,key=scrn_k$+"0000",dom=8800)iol=8010; let _header_obj_type$=_obj_type$
but we can start a new session, and all works well.

The error 261 happened on this statement
14311 let %_wp_dir$=msg("_WP_DIR",lwd),%_wp_prefix$=msg("_WP_PREFIX",pfx)

I am sure that this is a network issue and I have not got the most confidence in our client's IT support - well intentioned as they are.  Does anyone have any suggestions as to what may be done to resolve these issues?

Regards

Dave Fullerton

3
Programming / Printing to PDF - through WindX/Citrix connection
« on: March 27, 2020, 02:14:53 PM »
Hi Folks:

Running into an error 15 attempting to write to [wdx]*PDF* when the WindX user is connected via a Citrix server to our application server.  All works as expected if the user does not go through the Citrix server (i.e. they are in their network).   It looks like a convoluted setup to me.

We can create a folder for the file to reside in, and a file name is displayed in the folder, but then the error 15 occurs and an invalid PDF file (adobe can't read it) that is 2K in size is left.

PxPlus on the server is V12, PxPlus on the WindX is V15 (we are getting ready for an update).

Unfortunately, we can't trace the PDF on the WindX station.  We suspect that the issue is permissions based, but the folder is set for Everyone with full access.

Does anyone have any suggestions what we might do for a solution?

Thanks

Dave Fullerton

4
Off Topic / When designing your data base, did you use ERD's?
« on: February 14, 2020, 06:01:05 AM »
Hi all:

I am taking some university courses (working toward a Bachelor of Commerce degree), and one of them is about databases.  A major topic of the course revolves around Entity Relationship Diagrams (ERD's).  When I mentioned to the professor that in over 35 years in the business,  I had never seen one, she was surprised.  So, I thought I would take a little survey.

This forum is used by companies that develop business software around the world.  When you were developing your application, did you use ERD's?

Any input would be appreciated.

Regards

Dave Fullerton

5
Programming / GUID generator
« on: December 05, 2019, 03:12:00 PM »
Hi folks:

Doing a transfer of data from PxPlus files by generating text files which will be transferred to a SQL database.  Apparently, this database requires GUID's and it makes the migration much easier if I can generate it and stick it them in the text file - especially as the GUID may reference data in a different text file.

Does anyone know of a GUID generator that works in PxPlus?

Thanks

Dave Fullerton

6
Programming / How to speed up creating a Tree View List Box
« on: September 20, 2019, 04:59:19 PM »
Hi folks:

We have a routine where the structure of a user defined financial statement gets transferred to a tree view list box.  There are four levels in this list box - a major group, a minor group, a line group, and then line details.  There are no graphics displayed.  Our client has one report that contains 81,141 lines to be loaded into the list box.

The user is in a WindX environment, on a Windows network.  They are running PxPlus V15. 

I hide the list box before displaying anything.  All data is loaded a line at a time.  After 65 minutes, approximately 77,000 records had been processed.  This is obviously waaaay too slow.  I had thought about putting everything into a variable to load everything at once, but I'm worried about error 31's.

Does anyone have any suggestions how to speed up the processing?

Thanks in advance

Dave Fullerton

7
I have noticed in PVX version 16 if I select a radio button and then disable the button it no longer shows that it was selected.  Is there a way to have it still show as selected once it is disabled?

8
Programming / Will PxPlus interface with Office 365 on the cloud
« on: February 12, 2019, 01:31:55 PM »
We have code that opens up MS Word as an object and creates detailed bills.  This has been working for a very long time.  Clients are asking if our routines will work once they move to Office 365 on the cloud. 

I would think that as long as Word can be opened as an object, it probably doesn't matter, but I'd like some confirmation to know if that is an accurate assumption.  Does anyone have any experience with this?

Regards

Dave Fullerton

Pages: [1]