ProFox September 2021

profox@leafe.com

21 participants
12 discussions

VFP equivalent of SQL Server 'script table'
by Alan Bourke 03 Sep '21

03 Sep '21

In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data. Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

ProFox List Statistics for August 2021
by List Administrator Account 01 Sep '21

01 Sep '21

================================================== ProFox List Statistics August 2021 ================================================== Subscriber Count at End of Month: ProFox: 299 ProFoxTech: 183 ================================================== Total Posts: 103 (Up 157.5% from July 2021) Total [OT] Posts: 0 (Unchanged from July 2021) Total [NF] Posts: 38 (Up 3700.0% from July 2021) Daily Message Counts for August 2021 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 T 3 - 5 W 4 - 2 F 6 - 1 M 9 - 2 T 10 - 5 W 11 - 3 T 12 - 4 S 15 - 2 M 16 - 4 T 17 - 7 W 18 - 5 T 19 - 3 F 20 - 10 M 23 - 3 T 24 - 33 W 25 - 8 T 26 - 5 Message Counts By Day of Week for August 2021 ------------------------------------------------ DOW Count --- ----- Sun - 3 Mon - 9 Tue - 50 Wed - 18 Thu - 12 Fri - 11 Distinct Posters to the List (changes relative to July 2021) ------------------------------------------------ Non-OT messages: 33 (Up 73.68%) OT messages: 0 (Unchanged) NF messages: 14 (Up 1300.0%) Total number: 33 (Up 73.68%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 MB Software Solutions, LLC 2. 9 Alan Bourke 3. 8 Dave Crozier 4. 7 Eric Selje 5. 7 Stephen Russell 6. 5 Ted Roche 7. 5 Malcolm Greene 8. 5 John Weller 9. 5 Graham Brown 10. 4 Richard Kaye 11. 4 Paul H. Tarver 12. 4 Tracy Pearson 13. 3 Matt Slay 14. 3 Michael Oke, II 15. 2 Jürgen Wondzinski 16. 2 Ken McGinnis 17. 2 Christof Wollenhaupt 18. 2 Frank Cazabon 19. 1 Robert van der Hulst 20. 1 List Administrator Account Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 15 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Alan Bourke 2. 5 Graham Brown 3. 4 Malcolm Greene 4. 3 Paul H. Tarver 5. 3 MB Software Solutions, LLC 6. 2 Eric Selje 7. 2 Dave Crozier 8. 2 Ted Roche 9. 2 Michael Oke, II 10. 2 Stephen Russell 11. 2 Matt Slay 12. 2 Christof Wollenhaupt 13. 1 John Weller 14. 1 Robert van der Hulst 15. 1 Robert van der Hulst Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 MB Software Solutions, LLC 2. 9 Alan Bourke 3. 8 Dave Crozier 4. 7 Eric Selje 5. 7 Stephen Russell 6. 5 Ted Roche 7. 5 Malcolm Greene 8. 5 John Weller 9. 5 Graham Brown 10. 4 Richard Kaye 11. 4 Paul H. Tarver 12. 4 Tracy Pearson 13. 3 Matt Slay 14. 3 Michael Oke, II 15. 2 Jürgen Wondzinski 16. 2 Ken McGinnis 17. 2 Christof Wollenhaupt 18. 2 Frank Cazabon 19. 1 Robert van der Hulst 20. 1 List Administrator Account Top 13 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Dave Crozier 2. 2 Stephen Russell 3. 2 Graham Brown 4. 1 List Administrator Account 5. 1 Ken McGinnis 6. 1 Paul H. Tarver 7. 1 Chris Davis 8. 1 Frank Cazabon 9. 1 MB Software Solutions, LLC 10. 1 Malcolm Greene 11. 1 kbelan(a)mchsi.com 12. 1 Rick Schummer 13. 1 Tracy Pearson Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 [NF] Winforms 2. 15 Retire the CSV? 3. 14 SweetPotatosoftware.com 4. 11 [NF] - Is Bigger Always Better When It Comes To Your Monitors? :) 5. 8 [NF] Recommendations on a developer seat cushion? 6. 8 Outlook Office 365 7. 6 Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 8. 5 Webfaction web site host 9. 3 Grid column text alignment shifts on first focus 10. 2 Social Media buttons 11. 2 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 12. 1 ProFox List Statistics for July 2021 13. 1 [NF] New Job & The Silence is Killing Me... 14. 1 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 15. 1 Just heard the new verbage concerning Insert/Update 16. 1 Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 17. 1 Generate Restful API for a database 18. 1 AW: Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 19. 1 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 20. 1 Google Sheets Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 [NF] Winforms 2. 15 Retire the CSV? 3. 14 SweetPotatosoftware.com 4. 11 [NF] - Is Bigger Always Better When It Comes To Your Monitors? :) 5. 8 [NF] Recommendations on a developer seat cushion? 6. 8 Outlook Office 365 7. 6 Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 8. 5 Webfaction web site host 9. 3 Grid column text alignment shifts on first focus 10. 2 Social Media buttons 11. 2 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 12. 1 ProFox List Statistics for July 2021 13. 1 [NF] New Job & The Silence is Killing Me... 14. 1 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 15. 1 Just heard the new verbage concerning Insert/Update 16. 1 Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 17. 1 Generate Restful API for a database 18. 1 AW: Disappearing pop-up windows (like the Find window dialog in Code References, and sometimes the entire Debug window) 19. 1 Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration 20. 1 Google Sheets

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox September 2021