ProFox October 2019

profox@leafe.com

40 participants
47 discussions

APPEND BLANK with immediate field values set right after
by MB Software Solutions, LLC 03 Oct '19

03 Oct '19

In trying to find the "demons" in this legacy VFP app (shared/used by both desktop and internet/website users), I find there's a lot of APPEND BLANKS everywhere followed by an immediate REPLACE (and sometimes more than 1). Here's a sample of my findings: SELECT notes APPEND BLANK REPLACE notes.id WITH order.invoice REPLACE notes.dtg WITH DATETIME() LOCAL lnnotes_id lnnotes_id = notes.notes_id = TABLEUPDATE(.T.) GOTO BOTTOM = SEEK(lnnotes_id, 'notes', 'notes_id') SET ORDER TO ID thisform.pgf1.page5.grdnotes.coldetail.setfocus() Now, 1st, I'd say "switch this over to explicit INSERT INTO MyTable (ID, Dtg) VALUES (order.invoice,datetime())" Also, not sure why they're go to the bottom and then reposition the record pointer immediately afterwards. That's wasted moves/cycles, imo, although perhaps minuscule. If the user did NOT have table buffering in place, I can see a bigger knock against this approach because with every update, the table's CDX indexes would all have to be updated (if those fields were involved). The backend table's CDX file isn't updated on changes to the buffered cursor. Question: if you update fields that are indexed, I know the index file has to update to reflect those changes. If you update fields that are NOT IN ANY INDEXES, there's no update needed for the CDX then...right? Any other tips? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 6

Another refactoring question regarding unused columns in a DBF table
by MB Software Solutions, LLC 03 Oct '19

03 Oct '19

The main table in your inherited legacy application has 243 fields. Through looking at the database columns individually, you have determined that only 139 of those are used. (really!) They're of mixed types (characters, numbers, logicals, date/time, etc.). Getting rid of them takes you from a record size of 3093 down to 1982. In one instance, testing showed it reduced the size of the DBF by 1/3! Some of those unused fields have indexes on them. Let's assume I dropped the indexes on those fields. Do you: 1. do nothing...leave them as-is. 2. rename them to "X<fieldname>" so that you can basically mark them useless (to be later dropped) but have the ability to rename back to original if the app hits a snag showing a dependence on that useless field. 3. do something else I haven't considered? (Dropping them immediately is not an option as it's too radical/nuclear and offers no failsafe at time of change) tia, --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 ---

6 6

Question regarding updates to backend DBF table
by MB Software Solutions, LLC 03 Oct '19

03 Oct '19

Scenario: VFP9SP2 on modern Windows operating system using DBFs. Let's assume NO BUFFERING for this scenario, but there IS an index (1 or more) using the MyField field in the .CDX file. If the MyTable.MyField current value is "MyValue", will this code cause any network traffic with the backend table even though the value is the same? REPLACE MyField WITH "MyValue" IN MyTable Or is VFP smart enough to say "yeah, I'm not updating it with the same value. Next." ??? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 3

It is FP this time
by Stephen Russell 02 Oct '19

02 Oct '19

Ok, it is a twitter feed from prior devs who have to go back for and OLD app that still is working. https://twitter.com/julielerman/status/1179048076285284353 -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Status Bar problem
by Paul Newton 02 Oct '19

02 Oct '19

Hi all I have SET STATUS BAR ON and SET NOTIFY MODIFY but when I browse a table I am not seeing the table name or record numder/count in the status bar. Any ideas? I am running fully patched VFP9 under Windows 10. Thanks Paul Newton

2 4

bullet point symbols in your label captions
by MB Software Solutions, LLC 01 Oct '19

01 Oct '19

I'm just throwing together a quick mockup for some project here at the Corporate gig and wanted to use bullet points in some of my captions. What's the easiest way to do that? --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 3

ProFox List Statistics for September 2019
by List Administrator Account 01 Oct '19

01 Oct '19

================================================== ProFox List Statistics September 2019 ================================================== Subscriber Count at End of Month: ProFox: 291 ProFoxTech: 182 ================================================== Total Posts: 116 (Down 43.14% from August 2019) Total [OT] Posts: 0 (Unchanged from August 2019) Total [NF] Posts: 49 (Unchanged from August 2019) Daily Message Counts for September 2019 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 2 - 7 T 3 - 14 W 4 - 9 F 6 - 12 S 7 - 1 W 11 - 11 T 12 - 12 F 13 - 5 M 16 - 3 T 17 - 2 W 18 - 8 T 19 - 10 S 22 - 3 M 23 - 1 W 25 - 2 T 26 - 3 F 27 - 5 S 28 - 2 M 30 - 5 Message Counts By Day of Week for September 2019 ------------------------------------------------ DOW Count --- ----- Sun - 4 Mon - 16 Tue - 16 Wed - 30 Thu - 25 Fri - 22 Sat - 3 Distinct Posters to the List (changes relative to August 2019) ------------------------------------------------ Non-OT messages: 29 (Down 27.5%) OT messages: 0 (Unchanged) NF messages: 17 (Down 10.53%) Total number: 29 (Down 27.5%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 Alan Bourke 2. 12 MB Software Solutions, LLC 3. 12 Kurt at VR-FX 4. 8 Richard Kaye 5. 8 Ted Roche 6. 8 Paul Newton 7. 5 Johan Nel 8. 5 Tracy Pearson 9. 3 Mike 10. 3 Eric Selje 11. 3 Desmond Lloyd 12. 3 John Weller 13. 3 Kurt @ Gmail 14. 3 Gene Wirchenko 15. 3 Frank Cazabon 16. 2 <juergen(a)wondzinski.de> 17. 2 Chris Davis 18. 2 Charles Hart Enzer, M.D. 19. 1 List Administrator Account 20. 1 Dave Crozier Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 17 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 9 Alan Bourke 2. 9 Kurt at VR-FX 3. 5 Richard Kaye 4. 4 Johan Nel 5. 3 Ted Roche 6. 3 Gene Wirchenko 7. 3 Mike 8. 2 John Weller 9. 2 MB Software Solutions, LLC 10. 2 Tracy Pearson 11. 1 Stephen Russell 12. 1 Eric Selje 13. 1 Charlie Coleman 14. 1 Jean Laeremans 15. 1 Charles Hart Enzer, M.D. 16. 1 Ed Leafe 17. 1 Dave Crozier Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 Alan Bourke 2. 12 MB Software Solutions, LLC 3. 12 Kurt at VR-FX 4. 8 Richard Kaye 5. 8 Ted Roche 6. 8 Paul Newton 7. 5 Johan Nel 8. 5 Tracy Pearson 9. 3 Mike 10. 3 Eric Selje 11. 3 Desmond Lloyd 12. 3 John Weller 13. 3 Kurt @ Gmail 14. 3 Gene Wirchenko 15. 3 Frank Cazabon 16. 2 <juergen(a)wondzinski.de> 17. 2 Chris Davis 18. 2 Charles Hart Enzer, M.D. 19. 1 List Administrator Account 20. 1 Dave Crozier Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Johan Nel 2. 2 MB Software Solutions, LLC 3. 2 Paul Newton 4. 2 Desmond Lloyd 5. 2 <juergen(a)wondzinski.de> 6. 1 List Administrator Account 7. 1 Alan Bourke 8. 1 Stephen Russell 9. 1 John Weller 10. 1 Charles Hart Enzer, M.D. Top 17 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 29 [NF] Windows File Manager Reborn 2. 14 Outlook Redemption tool 3. 12 Detecting mouse click with modifier 4. 11 [NF] X# V2.07 public release announcement 5. 10 FoxPro 2.6a for Chromebooks 6. 9 VFP9 App: Running on Windows 7 and Windows 10 7. 6 VFP Application Support 8. 6 SMB 9. 4 Status Bar problem 10. 3 [NF] true or false? 11. 3 [NF] Macrium Reflect - CRC Error 12. 2 bullet point symbols in your label captions 13. 2 [NF] Congradulation, Ed 14. 2 AW: VFP9 App: Running on Windows 7 and Windows 10 15. 1 ProFox List Statistics for August 2019 16. 1 [NF] X# and VFP support 17. 1 VFP advice required regarding X# support Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 17 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 29 [NF] Windows File Manager Reborn 2. 14 Outlook Redemption tool 3. 12 Detecting mouse click with modifier 4. 11 [NF] X# V2.07 public release announcement 5. 10 FoxPro 2.6a for Chromebooks 6. 9 VFP9 App: Running on Windows 7 and Windows 10 7. 6 VFP Application Support 8. 6 SMB 9. 4 Status Bar problem 10. 3 [NF] true or false? 11. 3 [NF] Macrium Reflect - CRC Error 12. 2 bullet point symbols in your label captions 13. 2 [NF] Congradulation, Ed 14. 2 AW: VFP9 App: Running on Windows 7 and Windows 10 15. 1 ProFox List Statistics for August 2019 16. 1 [NF] X# and VFP support 17. 1 VFP advice required regarding X# support

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2019