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.
16
Off Topic / Re: When designing your data base, did you use ERD's?
« on: February 14, 2020, 09:20:56 AM »
Hi Kieth:
The cost associated with keeping it up to date would be prohibitive for a small company. and I would think most companies that monitor this forum fall into that category. It is a form of documentation, and as such, it can become a black hole for resources (cash and manpower). I agree with you, it is probably out of date as soon as it is created.
Regards
Dave
The cost associated with keeping it up to date would be prohibitive for a small company. and I would think most companies that monitor this forum fall into that category. It is a form of documentation, and as such, it can become a black hole for resources (cash and manpower). I agree with you, it is probably out of date as soon as it is created.
Regards
Dave
17
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
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
18
Programming / Re: Program Caching
« on: December 20, 2019, 12:08:20 PM »
Hi:
Couldn't you just add ;close(lfo) after your test fin(Prog_FNC$,"LCL_MTime")?
Regards
Dave Fullerton
Couldn't you just add ;close(lfo) after your test fin(Prog_FNC$,"LCL_MTime")?
Regards
Dave Fullerton
19
Programming / Re: GUID generator
« on: December 06, 2019, 11:40:42 AM »
Hi Josh:
That is very cool as well, and it comes out formatted, which is nice. Add a LCS and it's exactly what I'm looking for.
Thanks
Dave
That is very cool as well, and it comes out formatted, which is nice. Add a LCS and it's exactly what I'm looking for.
Thanks
Dave
20
Programming / Re: GUID generator
« on: December 05, 2019, 05:38:07 PM »
Hi Gord:
Thanks for this - I'll see if I can get it to work - I'm very green with the OOP stuff.
Dave
Thanks for this - I'll see if I can get it to work - I'm very green with the OOP stuff.
Dave
21
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
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
22
Programming / Re: How to speed up creating a Tree View List Box
« on: September 21, 2019, 05:24:38 AM »
Hi Ken:
Thanks for the tips. I'm wondering if the 'sort=0 may be the key to my issue. I'll give it a shot.
Regards
Dave Fullerton
Thanks for the tips. I'm wondering if the 'sort=0 may be the key to my issue. I'll give it a shot.
Regards
Dave Fullerton
23
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
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
24
Programming / Re: Duplicate Output Paper and PDF
« on: August 06, 2019, 04:02:56 PM »
Hi Lawrence:
We use repeat_data to do just what you're asking. We will open a PDF file as follows:
02305 if dup_out then close (dup_out)
02310 dup_out=unt; open (dup_out,opt="MARGINS=250:500:500:500;OVERWRITE;FILE="+px_pdf$+file_name$)%wdx$+"*pdf*"
02315 print (dup_out)'font'(%bill_font$,%font_size,""),'DF',
02320 print (dup_out)'lpi'(6),'cpi'(10),
Once the file is opened, we then do this:
repeat data to out on dup_out
where 'out' is our output channel (*winprt*).
I hope this helps.
Regards
Dave Fullerton
We use repeat_data to do just what you're asking. We will open a PDF file as follows:
02305 if dup_out then close (dup_out)
02310 dup_out=unt; open (dup_out,opt="MARGINS=250:500:500:500;OVERWRITE;FILE="+px_pdf$+file_name$)%wdx$+"*pdf*"
02315 print (dup_out)'font'(%bill_font$,%font_size,""),'DF',
02320 print (dup_out)'lpi'(6),'cpi'(10),
Once the file is opened, we then do this:
repeat data to out on dup_out
where 'out' is our output channel (*winprt*).
I hope this helps.
Regards
Dave Fullerton
25
Nomads / Re: Why does a disabled radio button not show which was selected?
« on: July 25, 2019, 12:15:23 PM »
Hi Mike:
What is the patch? The fact that it is in the next release doesn't help us if the client can't go to that release yet.
Regards
Dave Fullerton
What is the patch? The fact that it is in the next release doesn't help us if the client can't go to that release yet.
Regards
Dave Fullerton
26
Nomads / Re: Why does a disabled radio button not show which was selected?
« on: July 18, 2019, 02:54:44 PM »
Hi Mike:
If you try this, you will see that the radio button doesn't stay:
0010 print 'CS',
0020 print '4D', ! Works with or without this
0030 let rbt=10
0040 radio_button rbt:1,@(10,10,10,2)="{!16x16/Controls/Check_Box_Uncheck|!16x16/Controls/Check_Box}Radio 1"
0050 radio_button rbt:2,@(10,12,10,2)="{!16x16/Controls/Check_Box_Uncheck|!16x16/Controls/Check_Box}Radio 2"
0060 print "Click either button and it will be disabled"
0070 while 1
0080 obtain (0)*
0090 if ctl=4 or eom=esc then break
0100 if ctl=rbt then radio_button read rbt,x; disable control rbt:x; print x," Pressed"
0110 wend
Regards
Dave Fullerton
If you try this, you will see that the radio button doesn't stay:
0010 print 'CS',
0020 print '4D', ! Works with or without this
0030 let rbt=10
0040 radio_button rbt:1,@(10,10,10,2)="{!16x16/Controls/Check_Box_Uncheck|!16x16/Controls/Check_Box}Radio 1"
0050 radio_button rbt:2,@(10,12,10,2)="{!16x16/Controls/Check_Box_Uncheck|!16x16/Controls/Check_Box}Radio 2"
0060 print "Click either button and it will be disabled"
0070 while 1
0080 obtain (0)*
0090 if ctl=4 or eom=esc then break
0100 if ctl=rbt then radio_button read rbt,x; disable control rbt:x; print x," Pressed"
0110 wend
Regards
Dave Fullerton
27
Nomads / Why does a disabled radio button not show which was selected?
« on: July 16, 2019, 08:13:02 AM »
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?
28
Programming / Re: Query buttons not hiding as directed
« on: June 13, 2019, 11:00:02 AM »
Hi Len:
That is good news. Does it also address the issue with *winproc and tabbed panels where the tabs are initially disabled? I have been keeping a copy of *winproc.dfs and *winproc to upload to clients when we update their PxPlus.
Dave
That is good news. Does it also address the issue with *winproc and tabbed panels where the tabs are initially disabled? I have been keeping a copy of *winproc.dfs and *winproc to upload to clients when we update their PxPlus.
Dave
29
Programming / Re: Query buttons not hiding as directed
« on: June 11, 2019, 12:45:50 PM »
Hi Paul:
I believe that this is the fix for the issue that you're having. I opened a support ticket for something query button related a while back, and this is the reply I got.
<snip>
This issue has been fixed for the upcoming release. You can fix it by changing the following piece of code in *winproc.dsp:
10150 BUTTON (ID-_GBLINDX)+3000,@(_OBJ_C+_OBJ_W-_X2,_OBJ_L,_QRY_WIDTH*_ADJ_W,0-_OBJ_H)=_QRY_BITMAP$,OPT=STP(_obj_sts$,3,^"HD")+"S"+_QRY_BTN_ATTR$,TIP=_QRY_TIP$,OWN=_automationtext$
</snip>
It's too bad that the upcoming release is not for version 15. I need to upload a modified version of this routine anytime I update users to V15.
Regards
Dave Fullerton
I believe that this is the fix for the issue that you're having. I opened a support ticket for something query button related a while back, and this is the reply I got.
<snip>
This issue has been fixed for the upcoming release. You can fix it by changing the following piece of code in *winproc.dsp:
10150 BUTTON (ID-_GBLINDX)+3000,@(_OBJ_C+_OBJ_W-_X2,_OBJ_L,_QRY_WIDTH*_ADJ_W,0-_OBJ_H)=_QRY_BITMAP$,OPT=STP(_obj_sts$,3,^"HD")+"S"+_QRY_BTN_ATTR$,TIP=_QRY_TIP$,OWN=_automationtext$
</snip>
It's too bad that the upcoming release is not for version 15. I need to upload a modified version of this routine anytime I update users to V15.
Regards
Dave Fullerton
30
Thin Client/WindX / Re: Maximum connections using Simple Host/Client
« on: March 05, 2019, 05:14:39 PM »
Hi Mike:
Have you adjusted the Heap setting? I found that I would get the same error after 18 users, but I have had Simple Client running 75+ users off of one server after adjusting the Heap.
Back on the old mailing list, Neal McKinney and JB Leep had a thread going with settings. Here is what they adjusted:
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager\SubSystems - value Windows. For 64 bit systems, I follow Neal's recommendation and set the values to be 20480.
Regards
Dave Fullerton
Have you adjusted the Heap setting? I found that I would get the same error after 18 users, but I have had Simple Client running 75+ users off of one server after adjusting the Heap.
Back on the old mailing list, Neal McKinney and JB Leep had a thread going with settings. Here is what they adjusted:
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager\SubSystems - value Windows. For 64 bit systems, I follow Neal's recommendation and set the values to be 20480.
Regards
Dave Fullerton