ProFox May 2020

profox@leafe.com

21 participants
13 discussions

[NF] Ideal language/Framework for web-based functionality like off-line views?
by Ted Roche 10 May '20

10 May '20

Calling on the collective wisdom for some technical recommendations. There are only a few hard problems in computer science and offline master-master server replication is one of them... The charity I'm trying to help has a single-user FPW app currently. When a second user wants to add data, the Master user has to export lists of available serial numbers and export the existing inventory, the non-master user imports those files, does the data entry, and exports the new data that the Master must now re-import. Export/Import uses an ancient PKZIP to pass ZIP files back and forth, which they email or floppy-transport. Ah, the memories. In the best of all possible worlds, the data would go up on the net to be immediately accessed by all. Unfortunately, these folks are working in a developing country with unreliable internet, and are working in a brief time period and high throughput environment. They need both the ability to function when disconnected, and to re-connect and resync changes, with all the edge case issues that brings up. Years ago, Fox shipped with an "off-line view" method that had hooks to solve a lot of the typical conflict problems, though I really thought it was more of a curiosity than a robust framework. In the decades (and decades) since then, surely someone has come out with a replication scheme that can be managed without a post-graduate degree in database set theory. Has anyone come across a web framework with an offline component support like this? The core data the client is using is pretty small (~10,000 records in the main table) Something like: https://developers.google.com/web/fundamentals/instant-and-offline/web-stor… (Just the first hit in a web search, not a recommendation). I'm hoping to find some appropriate technology and then line up a dev in that technology (or a college-level project if appropriate) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

SQL Server Shared Management Objects (SMO)
by Paul Newton 01 May '20

01 May '20

Hi all We have been using the following to get a list of available servers loDMO = CreateObject("sqlSMO.Application") loServerList = loDMO.ListAvailableSQLServers However SQL-DMO was apparently deprecated with SQL Server 2005 and succeeded by SQL-SMO. Has anybody used SQL Server Shared Management Objects in VFP and, if so, can they please give me some pointers on what I need to install and how to implement code to replace that above. Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 13

ProFox List Statistics for April 2020
by List Administrator Account 01 May '20

01 May '20

================================================== ProFox List Statistics April 2020 ================================================== Subscriber Count at End of Month: ProFox: 295 ProFoxTech: 181 ================================================== Total Posts: 190 (Up 134.57% from March 2020) Total [OT] Posts: 0 (Unchanged from March 2020) Total [NF] Posts: 29 (Down 17.14% from March 2020) Daily Message Counts for April 2020 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 5 T 2 - 2 S 4 - 4 S 5 - 1 M 6 - 3 T 7 - 2 W 8 - 9 T 9 - 7 F 10 - 6 S 11 - 1 S 12 - 3 T 16 - 9 F 17 - 12 S 18 - 4 M 20 - 4 T 21 - 14 W 22 - 4 T 23 - 22 F 24 - 9 S 25 - 3 S 26 - 1 M 27 - 2 T 28 - 18 W 29 - 19 T 30 - 26 Message Counts By Day of Week for April 2020 ------------------------------------------------ DOW Count --- ----- Sun - 5 Mon - 9 Tue - 34 Wed - 37 Thu - 66 Fri - 27 Sat - 12 Distinct Posters to the List (changes relative to March 2020) ------------------------------------------------ Non-OT messages: 34 (Up 13.33%) OT messages: 0 (Unchanged) NF messages: 9 (Down 40.0%) Total number: 34 (Up 13.33%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 MB Software Solutions, LLC 2. 19 Richard Kaye 3. 14 Alan Bourke 4. 13 Tracy Pearson 5. 11 Eric Selje 6. 9 Malcolm Greene 7. 9 Paul H. Tarver 8. 9 Ted Roche 9. 8 Paul Newton 10. 7 Dave Crozier 11. 7 Kurt Wendt 12. 7 Stephen Russell 13. 6 Jürgen Wondzinski 14. 5 Frank Cazabon 15. 5 Charlie Coleman 16. 5 António Tavares Lopes 17. 4 Johan Nel 18. 4 Michael Savage 19. 3 Mike 20. 3 John Weller Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 9 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Malcolm Greene 2. 5 MB Software Solutions, LLC 3. 4 Johan Nel 4. 4 Alan Bourke 5. 4 Eric Selje 6. 3 Richard Kaye 7. 1 Vince Teachout 8. 1 Jean Laeremans 9. 1 Paul H. Tarver Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 MB Software Solutions, LLC 2. 19 Richard Kaye 3. 14 Alan Bourke 4. 13 Tracy Pearson 5. 11 Eric Selje 6. 9 Malcolm Greene 7. 9 Paul H. Tarver 8. 9 Ted Roche 9. 8 Paul Newton 10. 7 Dave Crozier 11. 7 Kurt Wendt 12. 7 Stephen Russell 13. 6 Jürgen Wondzinski 14. 5 Frank Cazabon 15. 5 Charlie Coleman 16. 5 António Tavares Lopes 17. 4 Johan Nel 18. 4 Michael Savage 19. 3 Mike 20. 3 John Weller Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Jürgen Wondzinski 2. 3 Paul Newton 3. 3 MB Software Solutions, LLC 4. 3 Johan Nel 5. 2 Michael Savage 6. 1 List Administrator Account 7. 1 Paul H. Tarver 8. 1 Ed Leafe 9. 1 Kurt Wendt 10. 1 Frank Cazabon 11. 1 Dave Crozier 12. 1 Malcolm Greene 13. 1 Kurt at VR-FX 14. 1 Ted Roche 15. 1 Richard Kaye Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 26 GoFish problem 2. 19 Office automation using VFP 10 64-bit version 3. 17 Test 4. 15 [NF] Recommendations on a balance board for standup desk use 5. 15 File sharing services 6. 12 SQL Server Shared Management Objects (SMO) 7. 9 SQL Server 17 - ODBC or Native Client? 8. 8 Decompile FoxPro Windows 2.6? 9. 7 does Refox work in windows 10? 10. 6 Who Likes Burgers & Foxpro ( job in California) 11. 6 64-bit app via the Chen version 12. 6 AW: 64-bit app via the Chen version 13. 6 [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April 14. 5 Pandemic/Penetration Testing Job 15. 5 FoxBin2Prg Form.Property = "" becomes .F. 16. 4 =?UTF-8?Q?_[NF]_X#_Bandol_2.4_released, _public_release_next_week_and_?= LIVE Demo 23 April 17. 3 Congrats Eric Selje! 18. 3 AddObject/BindEvent Question 19. 3 ng give me my file explorer back. 20. 2 MSXML6 instead of MSXML4 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 26 GoFish problem 2. 19 Office automation using VFP 10 64-bit version 3. 17 Test 4. 15 [NF] Recommendations on a balance board for standup desk use 5. 15 File sharing services 6. 12 SQL Server Shared Management Objects (SMO) 7. 9 SQL Server 17 - ODBC or Native Client? 8. 8 Decompile FoxPro Windows 2.6? 9. 7 does Refox work in windows 10? 10. 6 Who Likes Burgers & Foxpro ( job in California) 11. 6 64-bit app via the Chen version 12. 6 AW: 64-bit app via the Chen version 13. 6 [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April 14. 5 Pandemic/Penetration Testing Job 15. 5 FoxBin2Prg Form.Property = "" becomes .F. 16. 4 =?UTF-8?Q?_[NF]_X#_Bandol_2.4_released, _public_release_next_week_and_?= LIVE Demo 23 April 17. 3 Congrats Eric Selje! 18. 3 AddObject/BindEvent Question 19. 3 ng give me my file explorer back. 20. 2 MSXML6 instead of MSXML4

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2020