ProFox

profox@leafe.com

2704 discussions

ProFox List Statistics for February 2023
by List Administrator Account 01 Mar '23

01 Mar '23

================================================== ProFox List Statistics February 2023 ================================================== Subscriber Count at End of Month: ProFox: 304 ProFoxTech: 183 ================================================== Total Posts: 35 (Up 40.0% from January 2023) Total [OT] Posts: 0 (Unchanged from January 2023) Total [NF] Posts: 14 (Up 100.0% from January 2023) Daily Message Counts for February 2023 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 1 F 3 - 2 S 4 - 2 S 5 - 1 M 6 - 1 T 7 - 6 W 8 - 4 W 15 - 1 T 16 - 6 F 17 - 6 S 18 - 1 W 22 - 2 T 23 - 2 Message Counts By Day of Week for February 2023 ------------------------------------------------ DOW Count --- ----- Sun - 1 Mon - 1 Tue - 6 Wed - 8 Thu - 8 Fri - 8 Sat - 3 Distinct Posters to the List (changes relative to January 2023) ------------------------------------------------ Non-OT messages: 14 (Up 27.27%) OT messages: 0 (Unchanged) NF messages: 6 (Up 100.0%) Total number: 14 (Up 27.27%) Top 14 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 9 Alan Bourke 2. 6 Kurt @ Gmail 3. 4 Man-wai Chang 4. 3 Jeff Roberts 5. 2 Ed Leafe 6. 2 Vince Teachout 7. 2 Eric Selje 8. 1 Paul Hill 9. 1 List Administrator Account 10. 1 Christof Wollenhaupt 11. 1 AndyHC 12. 1 Paul H. Tarver 13. 1 <John(a)johnweller.co.uk> 14. 1 Michael Glassman Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 6 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Kurt @ Gmail 2. 3 Alan Bourke 3. 2 Ed Leafe 4. 2 Vince Teachout 5. 1 Eric Selje 6. 1 Christof Wollenhaupt Top 14 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 9 Alan Bourke 2. 6 Kurt @ Gmail 3. 4 Man-wai Chang 4. 3 Jeff Roberts 5. 2 Ed Leafe 6. 2 Vince Teachout 7. 2 Eric Selje 8. 1 Paul Hill 9. 1 List Administrator Account 10. 1 Christof Wollenhaupt 11. 1 AndyHC 12. 1 Paul H. Tarver 13. 1 <John(a)johnweller.co.uk> 14. 1 Michael Glassman Top 2 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 List Administrator Account 2. 1 Man-wai Chang Top 4 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 16 Using OpenAI like ChatGPT? 2. 14 [NF] Queries re: Python & Such... 3. 4 CDO Email 4. 1 ProFox List Statistics for January 2023 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 4 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 16 Using OpenAI like ChatGPT? 2. 14 [NF] Queries re: Python & Such... 3. 4 CDO Email 4. 1 ProFox List Statistics for January 2023

1 0

CDO Email
by John＠johnweller.co.uk 24 Feb '23

24 Feb '23

About 12 years ago I wrote a membership program for a local charity in VFP. It has continued to work with the odd tweak ever since. It uses Microsoft CDO to send emails – I know CDO is obsolete, so is VFP but it works! 😊. The code is below, cribbed from SweetPotatoSoftware many years ago: lcSchema = http://schemas.microsoft.com/cdo/configuration/ loConfig = CREATEOBJECT("CDO.Configuration") WITH loConfig.FIELDS .ITEM(lcSchema + "smtpserver") = "smtp.ionos.co.uk" .ITEM(lcSchema + "smtpserverport") = 587 .ITEM(lcSchema + "sendusing") = 2 .ITEM(lcSchema + "smtpauthenticate") = .T. .ITEM(lcSchema + "smtpusessl") = .F. .ITEM(lcSchema + "sendusername") = lcUserName .ITEM(lcSchema + "sendpassword") = lcPassword .UPDATE ENDWITH I have been advised by our email provider that we must upgrade to TLS 1.2. I had hoped that it would be as simple as changing usessl to True but that doesn’t appear to be the case. I am out of my depth having been away from serious programming for many years. Any help or suggestions would be gratefully received! John Weller 07976 393631 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 5

You are Todays Winner
by At&t iPhone 14 04 Feb '23

04 Feb '23

You are Todays Winner http://www.sam-club.rest/l/lt7M11309E186UY/5299SX9807RI12689VG224SM26004499… http://www.sam-club.rest/l/lt8P11309D186IL/5299FJ9807RX12689WU224GF26004499… n an interview with Pitchfork in October 2007, Taylor said there would be an equal proportion of electronic elements to live material, as the band doesn't "do things by adding one thing and taking something else away".[4] The album contained maximalist and minimalist songs; several tracks on the album were influenced by rock and heavy metal music, and the track "Wrestlers" started taking a new direction because the band was "wrestling with the idea of making an R. Kelly kind of slick R and B number" and ultimately "[sounded] more like Randy Newman's "Short People".[4] He said, "if the press release says it's faster and rockier it doesn't account for the fact that there are more ballads on this record than any other record."[4] Taylor said that feelings of happiness and love influenced the album's romantic feel.[6] Martin told The Georgia Straight that the group are "afflicted with something akin to musical attention-deficit disorder" and said that the group "get bored quite easily [...] with [their] own records at times". He elaborated by saying that the group aren't "really interested in reproducing the same sound" because they don't find it exciting.[14] Taylor stated Hot Chip "didn't set out to make something with one mood" and that he thought the band's style of "jump[ing] all over the place stylistically" made sense as a record.[4] In an interview with The Georgia Straight, Martin expressed that Hot Chip didn't want to create a "'classic' record that would have a particular sound" as they wanted to make music that was "quite experimental and out-there".[14] Made in the Dark was intended to represent the "whole live sound of the band" and they are "a band as much as originally having been a duo".[4] Lyrics Alexis Taylor The song "Ready for the Floor" contains an allusion to the 1989 film, Batman, with the line, "You're my number one guy". In an interview with The Fader magazine, Taylor said the reference was a result of thinking about the Batman film, which has many things that Taylor is fond of, such as the Prince soundtrack. He commented that sometimes those items "seep into what we're writing about" and said that he likes to reference "in an oblique way". He conjectured that he had included the line to say something to "ev --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox List Statistics for January 2023
by List Administrator Account 01 Feb '23

01 Feb '23

================================================== ProFox List Statistics January 2023 ================================================== Subscriber Count at End of Month: ProFox: 304 ProFoxTech: 183 ================================================== Total Posts: 25 (Down 13.79% from December 2022) Total [OT] Posts: 0 (Unchanged from December 2022) Total [NF] Posts: 0 (Unchanged from December 2022) Daily Message Counts for January 2023 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 2 T 5 - 3 T 12 - 1 F 13 - 3 S 15 - 6 M 16 - 6 T 17 - 3 S 28 - 1 Message Counts By Day of Week for January 2023 ------------------------------------------------ DOW Count --- ----- Sun - 8 Mon - 6 Tue - 3 Thu - 4 Fri - 3 Sat - 1 Distinct Posters to the List (changes relative to December 2022) ------------------------------------------------ Non-OT messages: 11 (Unchanged) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 11 (Unchanged) Top 11 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Chris Davis 2. 4 Alan Bourke 3. 2 Richard Kaye 4. 2 Tracy Pearson 5. 2 List Administrator Account 6. 2 Jeff Roberts 7. 1 MB Software Solutions, LLC 8. 1 Bill Anderson 9. 1 Ed Leafe 10. 1 Man-wai Chang 11. 1 Ted Roche Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 11 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Chris Davis 2. 4 Alan Bourke 3. 2 Richard Kaye 4. 2 Tracy Pearson 5. 2 List Administrator Account 6. 2 Jeff Roberts 7. 1 MB Software Solutions, LLC 8. 1 Bill Anderson 9. 1 Ed Leafe 10. 1 Man-wai Chang 11. 1 Ted Roche Top 6 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 List Administrator Account 2. 1 Richard Kaye 3. 1 Chris Davis 4. 1 Tracy Pearson 5. 1 Jeff Roberts 6. 1 Bill Anderson Top 7 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 Small Report/Label Designs 2. 3 VFP6 vs VFP9 query time on large table 3. 3 Archive search down? 4. 2 Report with 2 Columns, Left to Right and Groups 5. 1 ProFox List Statistics for 2022 6. 1 ChilkatVFP 1.2 released 7. 1 ProFox List Statistics for December 2022 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 7 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 Small Report/Label Designs 2. 3 VFP6 vs VFP9 query time on large table 3. 3 Archive search down? 4. 2 Report with 2 Columns, Left to Right and Groups 5. 1 ProFox List Statistics for 2022 6. 1 ChilkatVFP 1.2 released 7. 1 ProFox List Statistics for December 2022

1 0

ChilkatVFP 1.2 released
by Bill Anderson 29 Jan '23

29 Jan '23

Folks, ChikatVFP can be found here: https://github.com/billand88/ChilkatVFP The big update for me is the ability to pass ChilkatVFP objects as object parameters to Chilkat methods. ChilkatVFP will recognize that the passed object is a ChilkatVFP object, grab the associated Chilkat object and pass that to the Chilkat method, and reattach it upon retrieval. The motivation was matching all the Chilkat examples. It was getting hard to constantly remember that prior to this version, one had to write (for instance) *loChilkatVFPEmail.oChilkat *as the object parameter. Now one can simply pass the ChilkatVFP object and ChilkatVFP handles it for you. There's also an enhancement/kinda bug fix involving the handling of non-implemented features in source code. Implementing both of these enhancements involved deep dives into the source, which encouraged other side fixes for things noticed while I happened to be there... Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

VFP6 vs VFP9 query time on large table
by Jeff Roberts 18 Jan '23

18 Jan '23

I have a large table, about 1.5GB with an index on invno which is a char 6. Files are on a file server, client machine where I am running VFP6 and VFP9 is connected via gigabit ethernet. I run SELECT * FROM invoicdt WHERE invno = '989426' In VFP6 it takes about 6 seconds. In VFP9 it takes about 60 seconds. Anybody have any idea why it is so much slower in VFP9? -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Report with 2 Columns, Left to Right and Groups
by Tracy Pearson 16 Jan '23

16 Jan '23

Hello everyone, I don't work with the VFP reports very often. My coworker brought up a problem he has found when building a custom report for a customer. Using a single flat table and building a report with multiple columns and have it go left to right the details properly go left to right. Once a grouping is added to the report, everything prints in the left column only. Switch the report to be Top to Bottom and both columns are used. For what is in this report, it would be better to have this left to right. Custom programming to group things before going to the report is not an option. Creating a similar report in the IDE, not the runtime, does not exhibit this behavior. Does anyone have an idea on how to get the report to behave? We have tried this in VFP 9 SP 2 HF 3 Thank you, Tracy

1 1

Small Report/Label Designs
by Chris Davis 16 Jan '23

16 Jan '23

Anyone got any tips for working easier on small label designs? TIA Chris. Chris Davis Acton Gate Systems Limited Please note our new address from 1st May 2022: 1 Nightingale Place Pendeford Business Park Wolverhampton WV9 5HF M: 07966 020 473 T: 01902 249299 *: chrisd(a)actongate.co.uk Web<mailto:chrisd@actongate.co.uk%0bWeb>: www.actongate.co.uk<http://www.actongate.co.uk/> This email is confidential and may be privileged; it is for use of the named recipient(s) only. If you have received it in error, please notify us immediately; please do not copy or disclose its contents to any person or body, and delete it from your computer systems. Any views or opinions expressed within this email are personal and may not necessarily reflect those of Acton Gate Systems Limited, unless explicitly stated otherwise. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by Acton Gate Systems Limited in this regard and the recipient should carry out such virus and other checks as it considers appropriate. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 8

Archive search down?
by Richard Kaye 05 Jan '23

05 Jan '23

Just tried to hit the archive search link ang got a 502 from nginx. -- rk

2 2

ProFox List Statistics for 2022
by List Administrator Account 01 Jan '23

01 Jan '23

================================================== ProFox List Statistics 2022 ================================================== Subscriber Count at End of Year: ProFox: 304 ProFoxTech: 183 ================================================== Total Posts: 629 (Down 16.69% from 2021) Total [OT] Posts: 0 (Unchanged from 2021) Total [NF] Posts: 114 (Down 21.38% from 2021) Daily Message Counts for 2022 ------------------------------------------------ Date Count ---- ----- 1 - 27 2 - 10 3 - 18 4 - 38 5 - 23 6 - 20 7 - 28 8 - 18 9 - 22 10 - 13 11 - 37 12 - 40 13 - 55 14 - 4 15 - 51 16 - 24 17 - 9 18 - 9 19 - 10 20 - 4 21 - 18 22 - 9 23 - 12 24 - 14 25 - 12 26 - 11 27 - 24 28 - 5 29 - 13 30 - 31 31 - 20 Message Counts By Day of Week for 2022 ------------------------------------------------ DOW Count --- ----- Sun - 55 Mon - 133 Tue - 129 Wed - 99 Thu - 79 Fri - 97 Sat - 37 Distinct Posters to the List (changes relative to 2021) ------------------------------------------------ Non-OT messages: 51 (Down 16.39%) OT messages: 0 (Unchanged) NF messages: 22 (Down 29.03%) Total number: 51 (Down 16.39%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 83 Paul Newton 2. 56 Alan Bourke 3. 53 <paul.newton.hudl(a)gmail.com> 4. 42 Richard Kaye 5. 30 Jürgen Wondzinski 6. 26 Tracy Pearson 7. 26 MB Software Solutions, LLC 8. 21 Ted Roche 9. 20 Ed Leafe 10. 20 Kurt @ Gmail 11. 19 Dave Crozier 12. 18 Eric Selje 13. 17 Bill Anderson 14. 16 Jeff Roberts 15. 15 Frank Cazabon 16. 14 Rick Schummer 17. 13 List Administrator Account 18. 12 Paul H. Tarver 19. 10 Man-wai Chang 20. 8 Carl Lindner Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 25 Paul Newton 2. 13 Alan Bourke 3. 11 Ed Leafe 4. 10 MB Software Solutions, LLC 5. 9 Kurt @ Gmail 6. 8 Frank Cazabon 7. 7 Ted Roche 8. 5 Man-wai Chang 9. 3 Jürgen Wondzinski 10. 3 <John(a)johnweller.co.uk> 11. 3 Eric Selje 12. 2 Paul H. Tarver 13. 2 AndyHC 14. 2 Dave Crozier 15. 2 Stephen Russell 16. 2 Christof Wollenhaupt 17. 1 <paul.newton.hudl(a)gmail.com> 18. 1 Darren 19. 1 Johan Nel 20. 1 Michael Glassman Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 83 Paul Newton 2. 56 Alan Bourke 3. 53 <paul.newton.hudl(a)gmail.com> 4. 42 Richard Kaye 5. 30 Jürgen Wondzinski 6. 26 Tracy Pearson 7. 26 MB Software Solutions, LLC 8. 21 Ted Roche 9. 20 Ed Leafe 10. 20 Kurt @ Gmail 11. 19 Dave Crozier 12. 18 Eric Selje 13. 17 Bill Anderson 14. 16 Jeff Roberts 15. 15 Frank Cazabon 16. 14 Rick Schummer 17. 13 List Administrator Account 18. 12 Paul H. Tarver 19. 10 Man-wai Chang 20. 8 Carl Lindner Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 Paul Newton 2. 15 <paul.newton.hudl(a)gmail.com> 3. 13 List Administrator Account 4. 10 Rick Schummer 5. 6 MB Software Solutions, LLC 6. 6 Dave Crozier 7. 5 Ted Roche 8. 5 Alan Bourke 9. 5 Jeff Roberts 10. 4 Richard Kaye 11. 3 Joe Yoder 12. 3 Ken Watkins 13. 3 Tracy Pearson 14. 3 Bill Anderson 15. 2 <John(a)johnweller.co.uk> 16. 2 Graham Brown 17. 2 Carl Lindner 18. 2 Paul H. Tarver 19. 2 Kurt @ Gmail 20. 1 Ajit Abraham Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 29 Need Help - Foxpro & Chilkat & Rest API 2. 19 Accessing/processing archived emails 3. 16 [NF] Facets Database??? 4. 15 Problem trying to run a Powershell script as an Explorer shell command (Fox related) 5. 14 VFP9 installation on a new machine 6. 14 [NF] Understanding Rackspace documentation 7. 14 Last Chapter 8. 13 <Sigh Time to enjoy life. 9. 12 Config.FPW command ignored when double-clicking on PJX in Explorer 10. 10 Howdy Folks 11. 10 VRunFox 12. 10 Problem setting ActiveX control property (Folderview and Fileview controls) 13. 10 [NF] Those were the days ... ISP charges 14. 10 [NF] Microsoft wrongly blocking lots of emails 15. 10 A better way to create directories? 16. 9 [NF] Beyond Quickbooks 17. 9 Foxfest Tomorrow.... Help 18. 9 Help with a regular expression 19. 9 VFP9 and SQL memo fields 20. 8 GDIPlusX GetHue() and GetBrightness() Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 29 Need Help - Foxpro & Chilkat & Rest API 2. 19 Accessing/processing archived emails 3. 16 [NF] Facets Database??? 4. 15 Problem trying to run a Powershell script as an Explorer shell command (Fox related) 5. 14 VFP9 installation on a new machine 6. 14 [NF] Understanding Rackspace documentation 7. 14 Last Chapter 8. 13 <Sigh Time to enjoy life. 9. 12 Config.FPW command ignored when double-clicking on PJX in Explorer 10. 10 Howdy Folks 11. 10 VRunFox 12. 10 Problem setting ActiveX control property (Folderview and Fileview controls) 13. 10 [NF] Those were the days ... ISP charges 14. 10 [NF] Microsoft wrongly blocking lots of emails 15. 10 A better way to create directories? 16. 9 [NF] Beyond Quickbooks 17. 9 Foxfest Tomorrow.... Help 18. 9 Help with a regular expression 19. 9 VFP9 and SQL memo fields 20. 8 GDIPlusX GetHue() and GetBrightness()

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox