ProFox January 2021

profox@leafe.com

13 participants
8 discussions

[NF] A tale of two Pythons
by Ed Leafe 31 Jan '21

31 Jan '21

This thread is wonderful, especially if you are a Monty Python fan: https://twitter.com/gvanrossum/status/1355310333875773444 -- Ed Leafe

1 0

Re: Setting Class Libraries
by Philip Borkholder 15 Jan '21

15 Jan '21

Thanks Frank, Second question. What if I set CLASSLIBRARY TO mynewerclass.vcx ADDITIVE IN a hook provided by the author after the EXE starts? Thanks Philip ---------- Original Message ---------- From: Frank Cazabon <frank.cazabon(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: Setting Class Libraries Date: Fri, 15 Jan 2021 13:21:13 -0400 What is in the exe will be used Frank. Frank Cazabon On 15/01/2021 1:03 pm, Philip Borkholder wrote: > Hi all, > Quick question that I can't remember the hierarchy. > > Situation: > > Running a VFP App compiled in an EXE. > This EXE has a VCX class library file compiled into it that the author used. > > If I have a newer version of the VCX that performs some of the methods cleaner/faster than the one the author used, > Can I simply place the newer VCX into the root of the application folder? > > Will the newer VCX take precedence when the SET CLASSLIBRARY TO command runs in the EXE? > > > > Thanks > > Philip B > Vicksburg, MI > > [excessive quoting removed by server]

2 1

Setting Class Libraries
by Philip Borkholder 15 Jan '21

15 Jan '21

Hi all, Quick question that I can't remember the hierarchy. Situation: Running a VFP App compiled in an EXE. This EXE has a VCX class library file compiled into it that the author used. If I have a newer version of the VCX that performs some of the methods cleaner/faster than the one the author used, Can I simply place the newer VCX into the root of the application folder? Will the newer VCX take precedence when the SET CLASSLIBRARY TO command runs in the EXE? Thanks Philip B Vicksburg, MI

2 1

Automation & Office 365
by Frank Cazabon 15 Jan '21

15 Jan '21

Hi, I've got an old VFP app that uses Word 2007 to do a mail merge using automation. The client has now moved to Office 365 and of course this breaks the automation. I am seeing some evidence that if the 32 bit of Office 365 is installed locally then the automation should work. Office 365 and OLE Word Merge in Visual Foxpro Application (microsoft.com) <https://social.msdn.microsoft.com/Forums/en-US/496b97f2-239b-4981-b7c5-8819…> Has anyone actually got this to work? If not, what alternatives are there for generating Word documents from VFP? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 8

ProFox List Statistics for 2020
by List Administrator Account 09 Jan '21

09 Jan '21

================================================== ProFox List Statistics 2020 ================================================== Subscriber Count at End of Year: ProFox: 296 ProFoxTech: 182 ================================================== Total Posts: 1105 (Down 44.56% from 2019) Total [OT] Posts: 0 (Down 100.0% from 2019) Total [NF] Posts: 279 (Down 43.75% from 2019) Daily Message Counts for 2020 ------------------------------------------------ Date Count ---- ----- 1 - 33 2 - 35 3 - 39 4 - 28 5 - 30 6 - 23 7 - 34 8 - 50 9 - 30 10 - 46 11 - 19 12 - 9 13 - 20 14 - 15 15 - 22 16 - 37 17 - 45 18 - 24 19 - 2 20 - 40 21 - 67 22 - 38 23 - 76 24 - 73 25 - 37 26 - 50 27 - 31 28 - 46 29 - 33 30 - 53 31 - 20 Message Counts By Day of Week for 2020 ------------------------------------------------ DOW Count --- ----- Sun - 35 Mon - 181 Tue - 213 Wed - 232 Thu - 199 Fri - 182 Sat - 63 Distinct Posters to the List (changes relative to 2019) ------------------------------------------------ Non-OT messages: 71 (Down 18.39%) OT messages: 0 (Down 100.0%) NF messages: 42 (Down 30.0%) Total number: 71 (Down 21.11%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 155 MB Software Solutions, LLC 2. 87 Alan Bourke 3. 76 Richard Kaye 4. 60 Tracy Pearson 5. 55 Eric Selje 6. 55 Stephen Russell 7. 50 Paul Newton 8. 50 Ted Roche 9. 38 Ed Leafe 10. 36 Jürgen Wondzinski 11. 31 Charles Hart Enzer, M.D. 12. 29 Paul H. Tarver 13. 22 John Weller 14. 20 Frank Cazabon 15. 18 Malcolm Greene 16. 17 Philip Borkholder 17. 17 Dave Crozier 18. 16 Koen Piller 19. 15 Johan Nel 20. 15 Vince Teachout Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 28 MB Software Solutions, LLC 2. 26 Eric Selje 3. 25 Alan Bourke 4. 23 Charles Hart Enzer, M.D. 5. 22 Stephen Russell 6. 17 Paul Newton 7. 17 Richard Kaye 8. 12 Johan Nel 9. 11 Malcolm Greene 10. 11 Ted Roche 11. 10 Tracy Pearson 12. 6 John Weller 13. 5 Jürgen Wondzinski 14. 5 Ed Leafe 15. 5 Vince Teachout 16. 4 Kurt Wendt 17. 4 Paul H. Tarver 18. 4 Frank Cazabon 19. 3 Koen Piller 20. 3 Paul Hill Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 155 MB Software Solutions, LLC 2. 87 Alan Bourke 3. 76 Richard Kaye 4. 60 Tracy Pearson 5. 55 Eric Selje 6. 55 Stephen Russell 7. 50 Paul Newton 8. 50 Ted Roche 9. 38 Ed Leafe 10. 36 Jürgen Wondzinski 11. 31 Charles Hart Enzer, M.D. 12. 29 Paul H. Tarver 13. 22 John Weller 14. 20 Frank Cazabon 15. 18 Malcolm Greene 16. 17 Philip Borkholder 17. 17 Dave Crozier 18. 16 Koen Piller 19. 15 Johan Nel 20. 15 Vince Teachout Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 27 MB Software Solutions, LLC 2. 15 Paul Newton 3. 13 List Administrator Account 4. 12 Charles Hart Enzer, M.D. 5. 11 Johan Nel 6. 8 Stephen Russell 7. 8 Rick Schummer 8. 6 Ted Roche 9. 6 Ed Leafe 10. 6 Philip Borkholder 11. 5 John Weller 12. 5 Michael Savage 13. 4 Alan Bourke 14. 4 Tracy Pearson 15. 3 Rafael Copquin 16. 3 Desmond Lloyd 17. 3 Kurt Wendt 18. 2 Frank Cazabon 19. 2 Malcolm Greene 20. 2 Richard Kaye Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 26 GoFish problem 3. 20 Unit tests (was [NF] I will .....) 4. 19 NF Windows 11 ? 5. 19 Office automation using VFP 10 64-bit version 6. 18 [NF] Recommendations on a balance board for standup desk use 7. 17 VFP Apps/DBFs with AMD Processor 8. 17 Test 9. 17 [NF] USB wireless 10. 17 Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time?? 11. 16 Looking for a "side by side" editor for PRGs 12. 15 [NF] I will ..... 13. 15 DBFs Server 2012 R2 very slow with Certain Processors 14. 15 File sharing services 15. 14 SQLite 16. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 17. 14 [NF] Lost product key for Office Professional Plus 2016 18. 14 SQL Server Shared Management Objects (SMO) 19. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 20. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 26 GoFish problem 3. 20 Unit tests (was [NF] I will .....) 4. 19 NF Windows 11 ? 5. 19 Office automation using VFP 10 64-bit version 6. 18 [NF] Recommendations on a balance board for standup desk use 7. 17 VFP Apps/DBFs with AMD Processor 8. 17 Test 9. 17 [NF] USB wireless 10. 17 Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time?? 11. 16 Looking for a "side by side" editor for PRGs 12. 15 [NF] I will ..... 13. 15 DBFs Server 2012 R2 very slow with Certain Processors 14. 15 File sharing services 15. 14 SQLite 16. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 17. 14 [NF] Lost product key for Office Professional Plus 2016 18. 14 SQL Server Shared Management Objects (SMO) 19. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 20. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible?

5 4

RE: ProFox List Statistics for 2020
by Jürgen Wondzinski 04 Jan '21

04 Jan '21

Somehow that calculation is broken. It lists me as the one with the most started threads. Definitely not true ... It also can't get my name / umlaut correctly. Duh.. wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von List Administrator Account Gesendet: Freitag, 1. Januar 2021 07:13 An: profox(a)leafe.com Betreff: ProFox List Statistics for 2020 Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 31 JC<rgen Wondzinski 2. 27 MB Software Solutions, LLC 3. 15 Paul Newton 4. 13 List Administrator Account 5. 12 Charles Hart Enzer, M.D.

3 4

ProFox List Statistics for 2020
by List Administrator Account 03 Jan '21

03 Jan '21

================================================== ProFox List Statistics 2020 ================================================== Subscriber Count at End of Year: ProFox: 296 ProFoxTech: 182 ================================================== Total Posts: 1105 (Down 44.56% from 2019) Total [OT] Posts: 0 (Down 100.0% from 2019) Total [NF] Posts: 279 (Down 43.75% from 2019) Daily Message Counts for 2020 ------------------------------------------------ Date Count ---- ----- 1 - 33 2 - 35 3 - 39 4 - 28 5 - 30 6 - 23 7 - 34 8 - 50 9 - 30 10 - 46 11 - 19 12 - 9 13 - 20 14 - 15 15 - 22 16 - 37 17 - 45 18 - 24 19 - 2 20 - 40 21 - 67 22 - 38 23 - 76 24 - 73 25 - 37 26 - 50 27 - 31 28 - 46 29 - 33 30 - 53 31 - 20 Message Counts By Day of Week for 2020 ------------------------------------------------ DOW Count --- ----- Sun - 35 Mon - 181 Tue - 213 Wed - 232 Thu - 199 Fri - 182 Sat - 63 Distinct Posters to the List (changes relative to 2019) ------------------------------------------------ Non-OT messages: 71 (Down 18.39%) OT messages: 0 (Down 100.0%) NF messages: 42 (Down 30.0%) Total number: 71 (Down 21.11%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 155 MB Software Solutions, LLC 2. 87 Alan Bourke 3. 76 Richard Kaye 4. 60 Tracy Pearson 5. 55 Eric Selje 6. 55 Stephen Russell 7. 50 Paul Newton 8. 50 Ted Roche 9. 38 Ed Leafe 10. 36 Jürgen Wondzinski 11. 31 Charles Hart Enzer, M.D. 12. 29 Paul H. Tarver 13. 22 John Weller 14. 20 Frank Cazabon 15. 18 Malcolm Greene 16. 17 Philip Borkholder 17. 17 Dave Crozier 18. 16 Koen Piller 19. 15 Johan Nel 20. 15 Vince Teachout Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 28 MB Software Solutions, LLC 2. 26 Eric Selje 3. 25 Alan Bourke 4. 23 Charles Hart Enzer, M.D. 5. 22 Stephen Russell 6. 17 Paul Newton 7. 17 Richard Kaye 8. 12 Johan Nel 9. 11 Malcolm Greene 10. 11 Ted Roche 11. 10 Tracy Pearson 12. 6 John Weller 13. 5 Jürgen Wondzinski 14. 5 Ed Leafe 15. 5 Vince Teachout 16. 4 Kurt Wendt 17. 4 Paul H. Tarver 18. 4 Frank Cazabon 19. 3 Koen Piller 20. 3 Paul Hill Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 155 MB Software Solutions, LLC 2. 87 Alan Bourke 3. 76 Richard Kaye 4. 60 Tracy Pearson 5. 55 Eric Selje 6. 55 Stephen Russell 7. 50 Paul Newton 8. 50 Ted Roche 9. 38 Ed Leafe 10. 36 Jürgen Wondzinski 11. 31 Charles Hart Enzer, M.D. 12. 29 Paul H. Tarver 13. 22 John Weller 14. 20 Frank Cazabon 15. 18 Malcolm Greene 16. 17 Philip Borkholder 17. 17 Dave Crozier 18. 16 Koen Piller 19. 15 Johan Nel 20. 15 Vince Teachout Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 31 Jürgen Wondzinski 2. 27 MB Software Solutions, LLC 3. 15 Paul Newton 4. 13 List Administrator Account 5. 12 Charles Hart Enzer, M.D. 6. 11 Johan Nel 7. 8 Stephen Russell 8. 8 Rick Schummer 9. 6 Ted Roche 10. 6 Ed Leafe 11. 6 Philip Borkholder 12. 5 John Weller 13. 5 Michael Savage 14. 4 Alan Bourke 15. 4 Tracy Pearson 16. 3 Kurt Wendt 17. 3 Rafael Copquin 18. 3 Desmond Lloyd 19. 2 Frank Cazabon 20. 2 Malcolm Greene Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 26 GoFish problem 3. 20 Unit tests (was [NF] I will .....) 4. 19 NF Windows 11 ? 5. 19 Office automation using VFP 10 64-bit version 6. 18 [NF] Recommendations on a balance board for standup desk use 7. 17 VFP Apps/DBFs with AMD Processor 8. 17 Test 9. 17 [NF] USB wireless 10. 17 Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time?? 11. 16 Looking for a "side by side" editor for PRGs 12. 15 [NF] I will ..... 13. 15 DBFs Server 2012 R2 very slow with Certain Processors 14. 15 File sharing services 15. 14 SQLite 16. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 17. 14 [NF] Lost product key for Office Professional Plus 2016 18. 14 SQL Server Shared Management Objects (SMO) 19. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 20. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 26 GoFish problem 3. 20 Unit tests (was [NF] I will .....) 4. 19 NF Windows 11 ? 5. 19 Office automation using VFP 10 64-bit version 6. 18 [NF] Recommendations on a balance board for standup desk use 7. 17 VFP Apps/DBFs with AMD Processor 8. 17 Test 9. 17 [NF] USB wireless 10. 17 Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time?? 11. 16 Looking for a "side by side" editor for PRGs 12. 15 [NF] I will ..... 13. 15 DBFs Server 2012 R2 very slow with Certain Processors 14. 15 File sharing services 15. 14 SQLite 16. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 17. 14 [NF] Lost product key for Office Professional Plus 2016 18. 14 SQL Server Shared Management Objects (SMO) 19. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 20. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible?

3 2

ProFox List Statistics for December 2020
by List Administrator Account 01 Jan '21

01 Jan '21

================================================== ProFox List Statistics December 2020 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 182 ================================================== Total Posts: 60 (Down 22.08% from November 2020) Total [OT] Posts: 0 (Unchanged from November 2020) Total [NF] Posts: 0 (Down 100.0% from November 2020) Daily Message Counts for December 2020 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 1 T 3 - 3 F 4 - 4 S 5 - 3 S 6 - 4 M 7 - 8 T 8 - 9 W 9 - 12 T 15 - 5 W 16 - 5 T 22 - 4 W 23 - 1 T 24 - 1 Message Counts By Day of Week for December 2020 ------------------------------------------------ DOW Count --- ----- Sun - 4 Mon - 8 Tue - 19 Wed - 18 Thu - 4 Fri - 4 Sat - 3 Distinct Posters to the List (changes relative to November 2020) ------------------------------------------------ Non-OT messages: 20 (Down 20.0%) OT messages: 0 (Unchanged) NF messages: 0 (Down 100.0%) Total number: 20 (Down 20.0%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 18 MB Software Solutions, LLC 2. 6 Richard Kaye 3. 5 Tracy Pearson 4. 4 Stephen Russell 5. 4 Alan Bourke 6. 4 Frank Cazabon 7. 2 Eric Selje 8. 2 Ajit Abraham 9. 2 Jürgen Wondzinski 10. 2 Paul H. Tarver 11. 2 Srikanth Bhandari 12. 1 List Administrator Account 13. 1 Charlie 14. 1 Christof Wollenhaupt 15. 1 Koen Piller 16. 1 Ted Roche 17. 1 Vince Teachout 18. 1 M Jarvis 19. 1 Rick Schummer 20. 1 Rick Borup Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 18 MB Software Solutions, LLC 2. 6 Richard Kaye 3. 5 Tracy Pearson 4. 4 Stephen Russell 5. 4 Alan Bourke 6. 4 Frank Cazabon 7. 2 Eric Selje 8. 2 Ajit Abraham 9. 2 Jürgen Wondzinski 10. 2 Paul H. Tarver 11. 2 Srikanth Bhandari 12. 1 List Administrator Account 13. 1 Charlie 14. 1 Christof Wollenhaupt 15. 1 Koen Piller 16. 1 Ted Roche 17. 1 Vince Teachout 18. 1 M Jarvis 19. 1 Rick Schummer 20. 1 Rick Borup Top 4 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 MB Software Solutions, LLC 2. 1 List Administrator Account 3. 1 Tracy Pearson 4. 1 Ted Roche Top 8 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 7 Error 108 - File is in use by another user on INSERT INTO line 3. 6 MDI window theme github issue 4. 5 'Twas The Night Before Crisis... 5. 3 ParallelFox - anyone using it in production? 6. 2 SourceSafe from within Foxpro 7. 1 ProFox List Statistics for November 2020 8. 1 Virtual Fox Fest Future: Survey Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 8 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 35 SCX form included in EXE is not found on DO FORM line 2. 7 Error 108 - File is in use by another user on INSERT INTO line 3. 6 MDI window theme github issue 4. 5 'Twas The Night Before Crisis... 5. 3 ParallelFox - anyone using it in production? 6. 2 SourceSafe from within Foxpro 7. 1 ProFox List Statistics for November 2020 8. 1 Virtual Fox Fest Future: Survey

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox January 2021