ProFox April 2021

profox@leafe.com

25 participants
16 discussions

RE: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1
by Jürgen Wondzinski 15 Apr '21

15 Apr '21

Just a heads-up for SMB3: VFP is completely capable of SMB3. I have a customer with a clustered Hyper-V Server (i.e two identical boxes in parallel mode), running a VM with my DBF files as a regular fileserver-share. That's a Restaurant-System in 24/7 mode; i.e. those DBF files are always in use. The HyperV-server does his routinely updates and occasionally reboots and then switches the VMs from one machine to the other without interruption of the SMB3 connection, even though the other box has (of course) a different network card, IPs etc. Just for testing, I tried to run a Client with SMB1 only connection and got plenty problems with lost connections and dataaccess troubles. SMB3 is vital and necessary for all modern Windows Server operations, don't shut that off or you will get killed by some admin. SMB1 is not needed anymore in todays worlds. As long as you have local (Client) DataCaching and OpLocks disabled, everything is ok. In your VFP EXE at startup check those Registry keys from Christof's list, and yell if they are wrong. No, you can't change them from inside your EXE, since those are machinewide settings and therefor require AdminRights. wOOdy

1 0

Virtual Fox Fest 2021 (May): Procrastinators Unite and Register Today!
by Rick Schummer 12 Apr '21

12 Apr '21

We're glad so many have already registered for the May 6th Virtual Fox Fest. We still have room for many more. If you're planning to attend, please register sooner rather than later. Our hard-working registration staff is an organizer, and has a full-time job and then some working on customer projects. If too many of you wait until the week of the conference to register, some people may not get the credentials in time to see the first session on May 6th. It literally takes minutes for you to register, but it takes us longer to process your registration. We don't want you to miss all the details about the conference we'll be sharing over the next couple of weeks. We want you to have a chance to read the white papers and download the examples once we release them before the conference starts. We'd hate to see you miss the opportunity to get a head start on all the goodies. Go get registered! Now, really, don't waste another minute. Here is the link: http://geekgatherings.com/Registration Virtual Fox Fest is May 6th, 2021! Only 24 days until we gather virtually via the Internet! Again, don't forget to register today! Conference website: https://virtualfoxfest.com/ Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Paul McNett
by MB Software Solutions, LLC 09 Apr '21

09 Apr '21

Ed's recent post about the 2010 Dabo video made me wonder about Paul. Anybody know what he's up to nowadays? Haven't seen him here in years. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 5

Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5
by MB Software Solutions, LLC 09 Apr '21

09 Apr '21

I get this error when executing a COPY TO .... TYPE XL5 line in a program designed over a decade ago: /OLE error code 0x80030003: Unknown COM status code. / Interesting. I remoted into the guy's computer. He said it's a fairly new laptop (3 months old?) and it's version is 2102 (Build 13801.20360). I fired up vRunFox.exe and did a simple xx = CREATEOBJECT("Excel.Application") and it worked fine. What's strange to me is that the line throwing that Error 1426 is not an Excel automation line, but the COPY TO line. I believe the problem is the lcFile variable. When this code was written, Vista was the latest operating system. You can see how I look at the OS() to select the proper area for My Documents. *** mjb 03/03/2010 - changed for Vista and beyond IF VAL(SUBSTR(OS(),9,1)) >= 6 THEN && Vista doesn't use My lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\" ELSE && XP and below use My lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "My Documents\" ENDIF lcFile = ADDBS(lcDir) + "Inventory_" + DTOC(DATE(),1) *** mjb 06/26/2017 - added nbrdft, ntotbf IF this.lShowZeroQty THEN COPY TO (lcFile) FIELDS ccompany, cpalletsize, cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR this.CustomerSelected(icustid) TYPE XL5 ELSE COPY TO (lcFile) FIELDS ccompany, cpalletsize, cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR this.CustomerSelected(icustid) AND nQtyOnHand > 0 TYPE XL5 ENDIF So in short, I think the fact that it's Error 1426 is misleading...I doubt it's an Excel problem at all but in fact a problem with that lcFile actual path derived. I think somebody recently mentioned a Doug Hennig bit of code to look at the user's ACTUAL path to his documents area, iirc? I'll dig for that later after an appt but wanted to throw this out there in the meanwhile in case others have the "I had that happen to me and this is how I fixed it!" kind of memory recall. ;-) 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 ---

4 7

Virtual Fox Fest 2021 (May): Time to Register
by Rick Schummer 07 Apr '21

07 Apr '21

Thanks to all who have already registered for Virtual Fox Fest (https://virtualfoxfest.com; May 6, 2021); we appreciate your support and our speakers are excited to share their sessions with you soon. That said, we know there are those who have not registered and have good intentions to do so before the conference starts. Please do so sooner than later. It literally takes minutes to register. Here is the link: http://geekgatherings.com/Registration Our Virtual Fox Fest shirt store has been updated for 2021! Check it out at https://geekgatherings.logosoftwear.com/. You can choose your favorite color or put the VFF logo on any item LogoSoftwear sells. You'll find instructions for customizing your purchase at https://virtualfoxfest.com/geekwear.aspx. After much consideration, we've decided to stick with a virtual event this fall. It will be structured similarly to Virtual Fox Fest 2020. Dates will be announced later. We're already looking forward to a live Southwest Fox in 2022. Rick White Light Computing, Inc. www.whitelightcomputing.com

5 4

ProFox List Statistics for March 2021
by List Administrator Account 01 Apr '21

01 Apr '21

================================================== ProFox List Statistics March 2021 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 183 ================================================== Total Posts: 82 (Up 3.8% from February 2021) Total [OT] Posts: 0 (Unchanged from February 2021) Total [NF] Posts: 16 (Down 46.67% from February 2021) Daily Message Counts for March 2021 ------------------------------------------------ DOW Date Count --- ---- ----- M 1 - 6 T 2 - 3 M 8 - 4 T 9 - 15 W 10 - 11 M 15 - 2 T 16 - 11 W 17 - 1 F 19 - 2 S 21 - 2 M 22 - 6 T 23 - 3 W 24 - 3 M 29 - 3 T 30 - 4 W 31 - 6 Message Counts By Day of Week for March 2021 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 21 Tue - 36 Wed - 21 Fri - 2 Distinct Posters to the List (changes relative to February 2021) ------------------------------------------------ Non-OT messages: 23 (Down 4.17%) OT messages: 0 (Unchanged) NF messages: 8 (Down 42.86%) Total number: 23 (Down 4.17%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 MB Software Solutions, LLC 2. 8 Ted Roche 3. 7 Vince Teachout 4. 7 Alan Bourke 5. 6 Tracy Pearson 6. 5 Jürgen Wondzinski 7. 5 Bill Anderson 8. 5 Paul Newton 9. 4 Richard Kaye 10. 3 Eric Selje 11. 3 Frank Cazabon 12. 2 Stephen Russell 13. 2 List Administrator Account 14. 2 Ajit Abraham 15. 2 Philip Borkholder 16. 2 Charles Hart Enzer, M.D. 17. 1 John Weller 18. 1 Paul Hemans 19. 1 Ed Leafe 20. 1 Richard Caruso Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 8 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Paul Newton 2. 3 Alan Bourke 3. 2 Jürgen Wondzinski 4. 2 Stephen Russell 5. 1 Tracy Pearson 6. 1 Eric Selje 7. 1 MB Software Solutions, LLC 8. 1 Paul Hemans Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 MB Software Solutions, LLC 2. 8 Ted Roche 3. 7 Vince Teachout 4. 7 Alan Bourke 5. 6 Tracy Pearson 6. 5 Jürgen Wondzinski 7. 5 Bill Anderson 8. 5 Paul Newton 9. 4 Richard Kaye 10. 3 Eric Selje 11. 3 Frank Cazabon 12. 2 Stephen Russell 13. 2 List Administrator Account 14. 2 Ajit Abraham 15. 2 Philip Borkholder 16. 2 Charles Hart Enzer, M.D. 17. 1 John Weller 18. 1 Paul Hemans 19. 1 Ed Leafe 20. 1 Richard Caruso Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 List Administrator Account 2. 2 Vince Teachout 3. 2 Bill Anderson 4. 1 Tracy Pearson 5. 1 MB Software Solutions, LLC 6. 1 Charles Hart Enzer, M.D. 7. 1 Paul Newton 8. 1 Rick Schummer 9. 1 Philip Borkholder 10. 1 Stephen Russell Top 14 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Debenu.com/FoxItSoftware for creating PDFs 2. 9 ProFox List Statistics for February 2021 3. 9 CRS and Generating a Data Dictionary. 4. 9 [NF] New hardware - network port and HDD 5. 8 VFP 9 SP2 3 Hot Fix descriptions 6. 7 Bizarre Desktop write problem driving me mad 7. 6 Grid with an centered image 8. 6 [NF] Desktop Development in the roaring 20s 9. 5 VFP on 64bit Machine 10. 5 Citrix issue or network issue? 11. 3 Reports and Insufficient GDI resources (Error 2203) 12. 2 AW: VFP on 64bit Machine 13. 1 Virtual Fox Fest 2021 (May): Time to Register 14. 1 AW: [NF] New hardware - network port and HDD Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 14 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Debenu.com/FoxItSoftware for creating PDFs 2. 9 ProFox List Statistics for February 2021 3. 9 CRS and Generating a Data Dictionary. 4. 9 [NF] New hardware - network port and HDD 5. 8 VFP 9 SP2 3 Hot Fix descriptions 6. 7 Bizarre Desktop write problem driving me mad 7. 6 Grid with an centered image 8. 6 [NF] Desktop Development in the roaring 20s 9. 5 VFP on 64bit Machine 10. 5 Citrix issue or network issue? 11. 3 Reports and Insufficient GDI resources (Error 2203) 12. 2 AW: VFP on 64bit Machine 13. 1 Virtual Fox Fest 2021 (May): Time to Register 14. 1 AW: [NF] New hardware - network port and HDD

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2021