ProFox December 2020

profox@leafe.com

20 participants
10 discussions

'Twas The Night Before Crisis...
by Ted Roche 24 Dec '20

24 Dec '20

Wishing one and all a safe socially-distanced holiday season and a happy, healthy and prosperous New Year! -- Ted 'Twas the night before crisis, and all through the house, Not a program was working, not even a browse. The programmers were wrung out, too mindless to care, Knowing chances of shipping hadn't a prayer. The users were nestled all snug in their beds, While visions of inquiries danced in their heads. When out in the lobby there arose such a clatter, That I sprang from my cube to see what was the matter. And what to my wondering eyes should appear, But a SUPER PROGRAMMER, oblivious to fear. More rapid than eagles, his programs they came, And he whistled and shouted and called them by name: On Update! On Add! On Inquiry! On Delete! On Batch Jobs! On Closing! On Functions Complete! His eyes were glazed over, his fingers were lean, >From weekends and nights in front of the screen. A wink of his eye, and a twist of his head, Soon gave me to know I had nothing to dread. He spoke not a word, but went straight to his work, Turning specs into code, then he turned with a jerk. And laying his finger on the ENTER key, The system came up, and worked perfectly. The updates, updated; the deletes, they deleted; The inquiries, inquired; and the closing completed. He tested each whistle, he tested each bell, With nary an abend, and all had gone well. The system was finished, the tests were concluded, The client's last changes were even included! And the client exclaimed with a snarl and a taunt, "It's just what I asked for, but NOT what I want" (attributed variously, my copy came from here[1]) [1] https://leafe.com/archives/msg/514620 and https://leafe.com/archives/msg/237876 Merry Christmas, happy Hanukkah, happy Kwanzaa, festive Festivius, salubrious Solstice, happy Saturnalia and so forth to all! --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 4

Virtual Fox Fest Future: Survey
by Rick Schummer 23 Dec '20

23 Dec '20

We have 11 quick questions to help us plan future Virtual Fox Fest conferences. We would really appreciate your input: https://www.surveymonkey.com/r/F8ZLX9J Happy Holidays and wishes for a healthy and prosperous 2021 to all. Regards, Rick Schummer, Doug Hennig, and Tamar Granor

1 0

Error 108 - File is in use by another user on INSERT INTO line
by MB Software Solutions, LLC 16 Dec '20

16 Dec '20

VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client My error handling tripped on this simple line: INSERT INTO broker!doclinks (ifileid,idoctypeid,crange) VALUES (thisform.oFile.iid,liDocTypeID,ALLTRIM(loObj.txtRange.value)) VFP Help says this about Error 108: Visual FoxPro 9.0 SP2 File is in use by another user (Error 108) You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a network. I don't see why this line of code would throw an Error 108. I guess I'll add a simple TRY/CATCH around it to retry it "N" number of times (via DO WHILE loop with flag and counter), but tossing this out to the group for your thoughts. Thanks, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

ParallelFox - anyone using it in production?
by Alan Bourke 16 Dec '20

16 Dec '20

I have a customer who runs a process which is essentially chugging through a huge DBF and doing some processing for each record. This is taking quite a while on their hardware, like hours. It struck me that this is an ideal application for parallelism. So I've knocked up a quick test that uses ParalleFox with each worker processing a chunk of the DBF file. It seems to work fine. Anyone using this library in production ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

RE: Error 108 - File is in use by another user on INSERT INTO line
by Jürgen Wondzinski 15 Dec '20

15 Dec '20

Hi Mike, see HELP for SET TABLEVALIDATE. You either haven't set that setting (then the default value is 1+2) or you got it wrong :) The "correct" value would be 1+4 = 5 or a plain 0 wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von MB Software Solutions, LLC Gesendet: Dienstag, 15. Dezember 2020 19:00 An: ProFox Email List <profox(a)leafe.com> Betreff: Error 108 - File is in use by another user on INSERT INTO line VFP9SP2 - Citrix/VMWare server, Win10 desktop image on client My error handling tripped on this simple line: INSERT INTO broker!doclinks (ifileid,idoctypeid,crange) VALUES (thisform.oFile.iid,liDocTypeID,ALLTRIM(loObj.txtRange.value)) VFP Help says this about Error 108: Visual FoxPro 9.0 SP2 File is in use by another user (Error 108) You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a network. I don't see why this line of code would throw an Error 108. I guess I'll add a simple TRY/CATCH around it to retry it "N" number of times (via DO WHILE loop with flag and counter), but tossing this out to the group for your thoughts. Thanks, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server]

2 1

RE: SCX form included in EXE is not found on DO FORM line
by Jürgen Wondzinski 09 Dec '20

09 Dec '20

Hi Mike, Maybe, when compiling the EXE you are not saving tot he project folder? Always (!) save your exe to the project-root folder. Next idea: When calling the form, use the relative pathing to that form: i.e. DO FORM forms\myform.scx wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von MB Software Solutions, LLC Gesendet: Sonntag, 6. Dezember 2020 04:32 An: ProFox Email List <profox(a)leafe.com> Betreff: SCX form included in EXE is not found on DO FORM line VFP9SP2 - Win 7 Pro 43 second demo showing the problem: https://www.screencast.com/t/ZjyWYqFI The SCX form is included in the EXE. I'm running the EXE. DO FORM <formname> errors saying that the form is not found. Makes no sense to me. Now the app (a legacy app that I inherited which is very dirty) changes the path but still....if the SCX form is included in the EXE, why in the world would it not be found on DO FORM frmMyForm??????? tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server]

8 27

SCX form included in EXE is not found on DO FORM line
by MB Software Solutions, LLC 07 Dec '20

07 Dec '20

VFP9SP2 - Win 7 Pro 43 second demo showing the problem: https://www.screencast.com/t/ZjyWYqFI The SCX form is included in the EXE. I'm running the EXE. DO FORM <formname> errors saying that the form is not found. Makes no sense to me. Now the app (a legacy app that I inherited which is very dirty) changes the path but still....if the SCX form is included in the EXE, why in the world would it not be found on DO FORM frmMyForm??????? tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 6

MDI window theme github issue
by Tracy Pearson 05 Dec '20

05 Dec '20

Hello everyone, My coworker found this and shared it with me today. I have tested to see VFP apps correctly show the MDI form with a theme in Windows Server 2012. If you have a github account and would like to vote this up. I say thank you! https://github.com/dotnet/winforms/issues/3691 It's not just a Winforms issue, it's a Windows base code issue. I hope it gets fixed. Have a good one! Tracy

2 5

SourceSafe from within Foxpro
by Martin Rochford 04 Dec '20

04 Dec '20

I wonder if anyone can help please with what may be a simple problem. I'm trying to use VSS (Visual SourceSafe) with VFP (Visual Foxpro) on my Windows 10 PC with a local VSS database on my D drive, i.e. not on a network drive. I have done this many times the past and it is an excellent way to keep track of changes between versions. This works fine on a PC at the location of a client who I support, which runs XP. Also, on my own Windows 10 PC, VSS works perfectly from the VSS application, but when I try to access it from VFP I get "database XXX does not exist". I've tried creating a new database but to no avail. The srcsafe.ini file is in the VSS folder, so I can't understand what might be the problem. Could it be an issue with Windows 10? Any pointers would be hugely appreciated! Martin

4 3

ProFox List Statistics for November 2020
by List Administrator Account 01 Dec '20

01 Dec '20

================================================== ProFox List Statistics November 2020 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 182 ================================================== Total Posts: 77 (Down 13.48% from October 2020) Total [OT] Posts: 0 (Unchanged from October 2020) Total [NF] Posts: 8 (Up 14.29% from October 2020) Daily Message Counts for November 2020 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 2 - 4 T 3 - 2 W 4 - 2 F 6 - 6 S 7 - 1 S 8 - 6 M 9 - 4 T 10 - 10 T 12 - 4 T 17 - 3 W 18 - 2 M 23 - 16 T 24 - 9 W 25 - 1 T 26 - 4 M 30 - 2 Message Counts By Day of Week for November 2020 ------------------------------------------------ DOW Count --- ----- Sun - 7 Mon - 26 Tue - 24 Wed - 5 Thu - 8 Fri - 6 Sat - 1 Distinct Posters to the List (changes relative to October 2020) ------------------------------------------------ Non-OT messages: 25 (Up 19.05%) OT messages: 0 (Unchanged) NF messages: 5 (Unchanged) Total number: 25 (Up 19.05%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Paul Newton 2. 9 Charles Hart Enzer, M.D. 3. 7 Chris Davis 4. 6 Alan Bourke 5. 5 Stephen Russell 6. 5 Tracy Pearson 7. 5 MB Software Solutions, LLC 8. 3 Man-wai Chang 9. 2 Ajit Abraham 10. 2 Ed Leafe 11. 2 <juergen(a)wondzinski.de> 12. 2 Richard Kaye 13. 2 Christof Wollenhaupt 14. 2 Bill Anderson 15. 2 Martin Rochford 16. 2 Jürgen Wondzinski 17. 1 List Administrator Account 18. 1 Robert Sullivan 19. 1 Ted Roche 20. 1 Paul H. Tarver Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 5 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Charles Hart Enzer, M.D. 2. 2 Man-wai Chang 3. 2 Paul Newton 4. 1 Robert Sullivan 5. 1 Jürgen Wondzinski Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Paul Newton 2. 9 Charles Hart Enzer, M.D. 3. 7 Chris Davis 4. 6 Alan Bourke 5. 5 Stephen Russell 6. 5 Tracy Pearson 7. 5 MB Software Solutions, LLC 8. 3 Man-wai Chang 9. 2 Ajit Abraham 10. 2 Ed Leafe 11. 2 <juergen(a)wondzinski.de> 12. 2 Richard Kaye 13. 2 Christof Wollenhaupt 14. 2 Bill Anderson 15. 2 Martin Rochford 16. 2 Jürgen Wondzinski 17. 1 List Administrator Account 18. 1 Robert Sullivan 19. 1 Ted Roche 20. 1 Paul H. Tarver Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Paul Newton 2. 4 Charles Hart Enzer, M.D. 3. 2 Stephen Russell 4. 2 Jürgen Wondzinski 5. 2 Martin Rochford 6. 2 Chris Davis 7. 1 List Administrator Account 8. 1 <juergen(a)wondzinski.de> 9. 1 MB Software Solutions, LLC 10. 1 Rick Schummer 11. 1 Ken McGinnis 12. 1 Alan Bourke Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Free Visual Foxpro 2. 10 Problem with APPEND FROM <Filename> TYPE DELIMITED 3. 9 Opinions on Servers 4. 5 Record width 5. 4 VFP and VSS Database does not exist 6. 4 Desktop Alerts 7. 3 [NF] Missing codec - This item was encoded in a format that's not supported 8. 3 Do you have code in place for DST? 9. 3 XLSX-Workbook-Class 10. 3 need windows hosting for 4 users to run VFP9 SP2 simultaneous. 11. 2 Virtual Fox Fest 2020: Follow-up 12. 2 [NF] Location of Folders: Desktop and Downloads 13. 2 [NF] Messed up Desktop WIN 10 14. 2 ParallelFox - anyone using it in production? 15. 2 Error when running report 16. 2 SourceSafe from within Foxpro 17. 1 ProFox List Statistics for October 2020 18. 1 NF[ .net 5 conference] 19. 1 AW: XLSX-Workbook-Class 20. 1 Bookmarks in XFRX report previewer Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Free Visual Foxpro 2. 10 Problem with APPEND FROM <Filename> TYPE DELIMITED 3. 9 Opinions on Servers 4. 5 Record width 5. 4 VFP and VSS Database does not exist 6. 4 Desktop Alerts 7. 3 [NF] Missing codec - This item was encoded in a format that's not supported 8. 3 Do you have code in place for DST? 9. 3 XLSX-Workbook-Class 10. 3 need windows hosting for 4 users to run VFP9 SP2 simultaneous. 11. 2 Virtual Fox Fest 2020: Follow-up 12. 2 [NF] Location of Folders: Desktop and Downloads 13. 2 [NF] Messed up Desktop WIN 10 14. 2 ParallelFox - anyone using it in production? 15. 2 Error when running report 16. 2 SourceSafe from within Foxpro 17. 1 ProFox List Statistics for October 2020 18. 1 NF[ .net 5 conference] 19. 1 AW: XLSX-Workbook-Class 20. 1 Bookmarks in XFRX report previewer

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2020