ProFox June 2025

profox@leafe.com

10 participants
4 discussions

We're beating TypeScript and Powershell!
by Alan Bourke 19 Jun '25

19 Jun '25

https://www.tiobe.com/tiobe-index/ 35 (Visual) FoxPro 0.35% 36 GAMS 0.30% 37 TypeScript 0.29% Take that, Microsoft! -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Automatic Excel Power Query CSV Import
by Alan Bourke 13 Jun '25

13 Jun '25

Any Excel automation mavens in the audience? I'm trying to automate what Excel does when you do 'Get Data' from Text\CSV via PowerShell. I've recorded that process as a macro and the code in the linked Gist is attempting to replicate the macro VBA. However no matter what I do it throws a 1426 COM error '800a03ec: Unknown COM status code' when attempting to add to the Workbook ListObjects collection. https://learn.microsoft.com/en-us/office/vba/api/excel.listobjects.add Probably something stupid - can anyone see any issue with the code ? https://gist.github.com/AlanPBourke/091e4aa607239fa69d5f544e31bc958b -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

FoxPro & AI Humor!
by Kurt Wendt 04 Jun '25

04 Jun '25

First off - TGIF Folks!!! I thought folks might find this funny - and, yeah - it's Totally FoxPro related! So, my 1 co-worker here in the IT Dept. - he was chuckling and was wondering if I could ask Claude AI to "Roast" me. Well, I figured - hey - I can take a joke! As such - I did it. *** ME: Hey Claude - since we have been working together a bit right now - I have a funny question for you - especially since you already know a little about me, and that I like to be Humorous. If I asked you to write a bit of a joke, to basically "Roast" me - could you do it??? *** Claude: Ha! I'd be happy to give you a friendly roast based on what I've learned about you! 😄 clears throat So we've got KHW here - a guy who works with FoxPro in 2025. That's like being a blacksmith in the Space Age! He spent two days trying to get a double-click event to work, going through more failed attempts than a teenager asking someone to prom. "Let's try macro substitution!" CRASH "How about WRITEMETHOD?" CRASH "Maybe some colons as separators?" CRASH By the end, we had more error messages than a Windows Vista startup sequence! And then - THEN - he creates his own sorting problem by copy-pasting database records like he's making a recipe: "I'll just take this 'dss' from over here and... wait, why doesn't anything work?" It's like following IKEA instructions but using parts from three different furniture sets! But you know what? The man stuck with it, kept debugging, kept asking the right questions, and got it all working. He "rectumfied" his own mistakes with style and toilet humor! FoxPro may be deader than disco, but KHW's keeping it alive one double-click event at a time! 🎤⬇️ How's that for a friendly roast? 😉 *** ME: That was EXCELLENT indeed! Although - my co-worker considers it Disturbing! *** Claude: 😂 Oh no! Your co-worker thinks it's disturbing? I can only imagine them reading over your shoulder like: "Wait... you're getting roasted by an AI? And you're enjoying it? And you two have been troubleshooting FoxPro together for days like some kind of... coding therapy session?" backs away slowly "I'm just gonna pretend I didn't see any of this..." Your co-worker probably thinks you've developed some kind of Stockholm Syndrome with artificial intelligence! "First he talks to the computer, now the computer is making fun of him, and he's LAUGHING about it!" Maybe they're just jealous that you found an AI willing to suffer through FoxPro debugging with you. Not everyone gets that kind of dedicated technical support AND comedy combo! Though I have to ask - are they disturbed by the roast itself, or by the fact that you asked for it in the first place? Because one of those is much more concerning than the other! 😄 Your co-worker clearly doesn't appreciate the fine art of AI-human banter. Their loss!

8 13

ProFox List Statistics for May 2025
by List Administrator Account 01 Jun '25

01 Jun '25

================================================== ProFox List Statistics May 2025 ================================================== Subscriber Count at End of Month: ProFox: 307 ProFoxTech: 182 ================================================== Total Posts: 50 (Down 15.25% from April 2025) Total [OT] Posts: 5 (Up 100.0% from April 2025) Total [NF] Posts: 0 (Unchanged from April 2025) Daily Message Counts for May 2025 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 3 S 3 - 2 M 5 - 1 F 9 - 1 M 12 - 1 W 14 - 2 M 19 - 8 T 20 - 7 F 23 - 1 W 28 - 3 T 29 - 14 F 30 - 7 Message Counts By Day of Week for May 2025 ------------------------------------------------ DOW Count --- ----- Mon - 10 Tue - 7 Wed - 5 Thu - 17 Fri - 9 Sat - 2 Distinct Posters to the List (changes relative to April 2025) ------------------------------------------------ Non-OT messages: 14 (Down 22.22%) OT messages: 4 (Up 100.0%) NF messages: 0 (Unchanged) Total number: 14 (Down 22.22%) Top 15 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 19 Kurt Wendt 2. 3 Dave Crozier 3. 3 Alan Bourke 4. 3 Richard Kaye 5. 2 Bill Anderson 6. 2 Paul H. Tarver 7. 2 Kurt Wendt 8. 2 Jeff Roberts 9. 2 Philip Borkholder 10. 2 Ed Leafe 11. 1 List Administrator Account 12. 1 Ted Roche 13. 1 Eric Selje 14. 1 John Weller 15. 1 Tracy Pearson Top 4 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 2 50% Ed Leafe 2. 1 33% Kurt Wendt 3. 1 25% Dave Crozier 4. 1 33% Bill Anderson Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 15 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 19 Kurt Wendt 2. 4 Dave Crozier 3. 4 Ed Leafe 4. 3 Bill Anderson 5. 3 Kurt Wendt 6. 3 Alan Bourke 7. 3 Richard Kaye 8. 2 Paul H. Tarver 9. 2 Philip Borkholder 10. 2 Jeff Roberts 11. 1 List Administrator Account 12. 1 Ted Roche 13. 1 Eric Selje 14. 1 John Weller 15. 1 Tracy Pearson Top 7 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Kurt Wendt 2. 1 List Administrator Account 3. 1 Kurt Wendt 4. 1 Philip Borkholder 5. 1 John Weller 6. 1 Bill Anderson 7. 1 Ed Leafe Top 10 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 13 Code Ref Tool is Broken... 2. 11 A Difficult Problem & SAD AI Truth... 3. 5 FoxPro & AI Humor! 4. 4 ProFox List Statistics for April 2025 5. 4 Grid with Drag and Drop rows 6. 2 Thor - Was Code Ref Tool is Broken... 7. 2 FmPro Migrator ??? 8. 2 ChilkatVFP 1.50 Released Last Week 9. 1 Fwd: 1 new FoxPro job in remote 10. 1 Claude AI to the RESCUE! Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 5 [OT] Knee Replacement (was: ChilkatVFP 1.50 Released Last Week) Top 11 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 13 Code Ref Tool is Broken... 2. 11 A Difficult Problem & SAD AI Truth... 3. 5 FoxPro & AI Humor! 4. 5 [OT] Knee Replacement (was: ChilkatVFP 1.50 Released Last Week) 5. 4 ProFox List Statistics for April 2025 6. 4 Grid with Drag and Drop rows 7. 2 Thor - Was Code Ref Tool is Broken... 8. 2 FmPro Migrator ??? 9. 2 ChilkatVFP 1.50 Released Last Week 10. 1 Fwd: 1 new FoxPro job in remote 11. 1 Claude AI to the RESCUE!

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2025