ProFox

profox@leafe.com

2704 discussions

ProFox List Statistics for October 2020
by List Administrator Account 01 Nov '20

01 Nov '20

================================================== ProFox List Statistics October 2020 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 181 ================================================== Total Posts: 89 (Up 45.9% from September 2020) Total [OT] Posts: 0 (Unchanged from September 2020) Total [NF] Posts: 7 (Down 70.83% from September 2020) Daily Message Counts for October 2020 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 1 M 5 - 9 T 6 - 2 W 7 - 5 T 13 - 4 W 14 - 4 T 15 - 10 F 16 - 7 T 20 - 2 T 22 - 4 F 23 - 5 S 24 - 5 S 25 - 1 M 26 - 21 T 27 - 2 W 28 - 7 Message Counts By Day of Week for October 2020 ------------------------------------------------ DOW Count --- ----- Sun - 1 Mon - 30 Tue - 10 Wed - 16 Thu - 15 Fri - 12 Sat - 5 Distinct Posters to the List (changes relative to September 2020) ------------------------------------------------ Non-OT messages: 21 (Up 23.53%) OT messages: 0 (Unchanged) NF messages: 5 (Down 50.0%) Total number: 21 (Up 23.53%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 MB Software Solutions, LLC 2. 10 Richard Kaye 3. 8 Tracy Pearson 4. 5 Jürgen Wondzinski 5. 5 Dave Crozier 6. 5 Frank Cazabon 7. 5 Alan Bourke 8. 4 Rafael Copquin 9. 4 Stephen Russell 10. 3 Desmond Lloyd 11. 3 Eric Selje 12. 3 Bill Anderson 13. 3 Kurt Wendt 14. 3 Ted Roche 15. 3 Paul H. Tarver 16. 3 Fred Taylor 17. 2 Charlie 18. 2 Christof Wollenhaupt 19. 1 List Administrator Account 20. 1 Peter Cushing Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 5 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Ted Roche 2. 2 Richard Kaye 3. 1 Alan Bourke 4. 1 Paul H. Tarver 5. 1 Kurt Wendt Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 MB Software Solutions, LLC 2. 10 Richard Kaye 3. 8 Tracy Pearson 4. 5 Jürgen Wondzinski 5. 5 Dave Crozier 6. 5 Frank Cazabon 7. 5 Alan Bourke 8. 4 Rafael Copquin 9. 4 Stephen Russell 10. 3 Desmond Lloyd 11. 3 Eric Selje 12. 3 Bill Anderson 13. 3 Kurt Wendt 14. 3 Ted Roche 15. 3 Paul H. Tarver 16. 3 Fred Taylor 17. 2 Charlie 18. 2 Christof Wollenhaupt 19. 1 List Administrator Account 20. 1 Peter Cushing Top 11 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Jürgen Wondzinski 2. 3 MB Software Solutions, LLC 3. 2 Rafael Copquin 4. 1 List Administrator Account 5. 1 Desmond Lloyd 6. 1 Ted Roche 7. 1 Rick Schummer 8. 1 Richard Kaye 9. 1 Kurt Wendt 10. 1 Tracy Pearson 11. 1 Fred Taylor Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 2. 11 My memo field(s) Are Bloated...... 3. 10 Virtual Fox Fest 4. 9 Need way to change user to access protected folder 5. 6 Tomorrow is the last day of Virutal Fox Fest 6. 6 phdbase 7. 6 Day one Virtual FoxFest has begun 8. 5 [NF] SQL Server access via ODBC won't work from one workstation 9. 4 now it is cxi files 10. 3 This SQL didn't update just one record but ALL records....OOPS!!!!! 11. 2 AW: phdbase 12. 2 [NF] Only in Silicon Valley! 13. 2 AW: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 14. 2 AW: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 15. 2 Custom extensions (was now it is cxi files) 16. 1 ProFox List Statistics for September 2020 17. 1 Virtual Fox Fest 2020: Still time to register 18. 1 This SQL didn't update just one record but ALL records....OOPS!!!!! 19. 1 AW: now it is cxi files 20. 1 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 2. 11 My memo field(s) Are Bloated...... 3. 10 Virtual Fox Fest 4. 9 Need way to change user to access protected folder 5. 6 Tomorrow is the last day of Virutal Fox Fest 6. 6 phdbase 7. 6 Day one Virtual FoxFest has begun 8. 5 [NF] SQL Server access via ODBC won't work from one workstation 9. 4 now it is cxi files 10. 3 This SQL didn't update just one record but ALL records....OOPS!!!!! 11. 2 AW: phdbase 12. 2 [NF] Only in Silicon Valley! 13. 2 AW: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 14. 2 AW: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why? 15. 2 Custom extensions (was now it is cxi files) 16. 1 ProFox List Statistics for September 2020 17. 1 Virtual Fox Fest 2020: Still time to register 18. 1 This SQL didn't update just one record but ALL records....OOPS!!!!! 19. 1 AW: now it is cxi files 20. 1 COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?

1 0

now it is cxi files
by Rafael Copquin 26 Oct '20

26 Oct '20

Last week I wrote about this old VFP5 app that I inherited which had some files with the phd extension. I never had heard or encountered that kind of files but Dave Crozier helped me with them. However, digging more deeply into this old app (which BTW I need to upgrade to VFP9 and add some perks to it), I found that some of the DBF's are wrapped into a file with the CXI extension. Fortunately the old source code has the original program that wraps the dbfs into a CXI file. I thought all I had to do was recomplile in VFP9, but to my surprise, the dll available only works with VFP5 So my questions are: 1) how can I get the dll that works with VFP9 (I am not sure that there is an update for VFP9) 2) if there is not an update, then how can I get a VFP5 so I can compile my new code and make the CXI routines work. I'll appreciate some help on this Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Tomorrow is the last day of Virutal Fox Fest
by Tracy Pearson 26 Oct '20

26 Oct '20

Hello Everyone! I have been enjoying chatting with people and getting to see some faces of people for the first time. The sessions have been worth the time to watch live. There is a lot of chatter in the chat window as well. I haven't been paying attention to the chat much. Maybe I'll get a chance to put some more faces to the names I see here. Have a good one! Tracy

5 5

COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works with no issue. Why?
by MB Software Solutions, LLC 26 Oct '20

26 Oct '20

VFP9SP3 Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is SELECT COUNT(*) FROM SomeCursor WHERE <<yada yada yada>> ?? tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

5 18

This SQL didn't update just one record but ALL records....OOPS!!!!!
by MB Software Solutions, LLC 26 Oct '20

26 Oct '20

VFP9SP2 using DBC tables. The curWorkingGroup cursor had just ONE record in it. The Carriers_To_Process table (PK = IID field) has tens of thousands. The idea is that I'm just processing small sections at a time from Carriers_To_Process. Rather than update the one or two records in the curWorkingGroup cursor that are a subset of the Carriers_To_Process, it updated ALL of the records in Carriers_To_Process, basically not respecting the JOIN condition. UPDATE carriers_to_process ; SET cSession = this.cSession ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid What's wrong with my code for this simple UPDATE SQL ? Here's the full segment to put it in context (with curToDo being the subset of Carriers_To_Process and curUniques being the unique ven_id field (so that we don't process a ven_id twice): SELECT COUNT(*) FROM curUniques WITH (BUFFERING=.T.) WHERE lSelected INTO ARRAY laCnt liTotal = NVL(laCnt[1],0) SELECT curUniques SCAN FOR lSelected && FOR EMPTY(tProcessed) AND EMPTY(tError) AND EMPTY(tignored) AND ondemand = m.tlOnDemand liCnt = liCnt + 1 _screen.Caption = "Processing " + ALLTRIM(curUniques.ven_name) + " (" + ALLTRIM(STR(curUniques.ven_id)) + ") - " + ALLTRIM(STR(liCnt)) + " of " + ALLTRIM(STR(liTotal)) *** mjb 10/23/2020 - mark the session for the ones we're processing so that subsequent runs aren't grabbing them from the initial query above SELECT iid ; FROM curToDo ; WHERE ven_id = curUniques.ven_id ; INTO CURSOR curWorkingGroup READWRITE UPDATE carriers_to_process ; SET cSession = this.cSession ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid IF this.GetRecords('tmp',curUniques.ven_id) = 1 THEN UPDATE carriers_to_process ; SET tProcessed = DATETIME() ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid ELSE UPDATE carriers_to_process ; SET tError = DATETIME() ; FROM carriers_to_process p1 ; INNER JOIN curWorkingGroup g1 on g1.iid = p1.iid ENDIF && this.GetRecords('tmp',curUniques.ven_id) USE IN SELECT('curWorkingGroup') ENDSCAN && carriers_to_process I can revert to a simple xBASE approach with SCAN and SEEK/REPLACE but figured the UPDATE SQL was more elegant and easier to view. ;-) tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 3

[NF] Only in Silicon Valley!
by Kurt Wendt 20 Oct '20

20 Oct '20

A buddy of mine sent me this on LinkedIn - I thought it was pretty darnn funny - and I thought it would be a perfect thing to share with you folks: https://media-exp1.licdn.com/dms/image/C5622AQEWmcdYTvXRRg/feedshare-shrink… -K- --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

My memo field(s) Are Bloated......
by Desmond Lloyd 17 Oct '20

17 Oct '20

Good Morning! Have a very wide dbf with about 8 memo fields . Started acteing strange like if I tried to re-index or pack memo it would seem to go so far and then freeze! Found a utility that seemed to repair the file. The only issue is that the DBF is 710mb and the associated memo file is 1.2gb! Yikes. Have ran a pack memo (with no issues) and there is no change in the size of the memo file, which I am assuming is boated. 1.) Is the memo file really bloated. 2.) Going to look at the individual memo fields and see if any one of the records has an unusually large memo field. 3.) Open to any other suggestion that you wise people could recommend.... TIA/Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 8

Virtual Fox Fest
by MB Software Solutions, LLC 17 Oct '20

17 Oct '20

Anybody else having trouble viewing the webinar? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

5 9

Day one Virtual FoxFest has begun
by Richard Kaye 16 Oct '20

16 Oct '20

As far as I know it's not too late to register. 2 good sessions so far on SQL security and a graphics library that can be used in VFP. And cheers to Ted Roche for being a sponsor! -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 5

phdbase
by Rafael Copquin 14 Oct '20

14 Oct '20

Hi guys, it's been e long time! I just inherited an old vfp5 program that needs to be updated to VFP9, adding new routines to enhance performance and migrate the dbf's to sql server. I encountered some dbfs that have an additional file with a phd extension which I believe is generated by a program that facilitates text searches in memo files. I try to open the dbf but vfp9 says that it can't find the phd file, even though the dbf, its cdx and phd files are in the same folder. I tried to set tablevalidate to 0, set exclusive on but to no avail How can I open those dbf's? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 7

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox