ProFox December 2022

profox@leafe.com

11 participants
6 discussions

T'was The Night Before...
by Ted Roche 23 Dec '22

23 Dec '22

'Twas the night before crisis, and all through the house, Not a program was working, not even a browse. The programmers were wrung out, too mindless to care, Knowing chances of shipping hadn't a prayer. The users were nestled all snug in their beds, While visions of inquiries danced in their heads. When out in the lobby there arose such a clatter, That I sprang from my cube to see what was the matter. And what to my wondering eyes should appear, But a SUPER PROGRAMMER, oblivious to fear. More rapid than eagles, his programs they came, And he whistled and shouted and called them by name: On Update! On Add! On Inquiry! On Delete! On Batch Jobs! On Closing! On Functions Complete! His eyes were glazed over, his fingers were lean, >From weekends and nights in front of the screen. A wink of his eye, and a twist of his head, Soon gave me to know I had nothing to dread. He spoke not a word, but went straight to his work, Turning specs into code, then he turned with a jerk. And laying his finger on the ENTER key, The system came up, and worked perfectly. The updates, updated; the deletes, they deleted; The inquiries, inquired; and the closing completed. He tested each whistle, he tested each bell, With nary an abend, and all had gone well. The system was finished, the tests were concluded, The client's last changes were even included! And the client exclaimed with a snarl and a taunt, "It's just what I asked for, but NOT what I want" (attributed variously, my copy came from here[1]) [1] http://www.mdarwin.ca/humour/night-before-xmas/night-before-crisis.phtml https://web.archive.org/web/20070923102738/http://www.mdarwin.ca/humour/nig… Merry Christmas, Chag Hanukkah sameach, happy Qwanza, merry Solstice, happy Saturnalia and so forth to all!

1 0

Equation solving from VFP
by Paul Newton 20 Dec '22

20 Dec '22

I have the following equation Vb = Va*[(Ca/(1 + H/Ka) - H + Kw/H)/(Cb/(1 + Kw⁄ (H*Kb)) + H - Kw/H)] Va, Ca, Ka, Cb, Kb and Kw are known or can be provided for any given "run" of the calculation. Typical values might be Va = 10, Ca = 0.1, Ka = 1.8E-5, Cb = 0.1, Kb = 0.63, Kw = 1.0E-14 The aim is to calculate H for various values of Vb and this requires "solving" for H. Various software packages do this in pretty much the same way but the terminology varies: Matlab uses "fsolve", Mathcad uses "find", Maple uses "solve" and Excel uses "GoalSeek". I would like to try to find a way of doing this from VFP. Perhaps there is already a .NET DLL that could be called from VFP? Perhaps with a wrapper to act as a sort of mediator? Failing that, would it be a major task to create something in .NET (perhaps using an existing package)? I really don't know, just thinking aloud ... Paul Newton

4 5

[ADMIN] 502 Bad Gateway
by Ted Roche 18 Dec '22

18 Dec '22

I looks like leafe.com is having a bad day. Getting 502 Bad Gateway

2 2

Fun with REPORT FORM...SUMMARY
by Richard Kaye 15 Dec '22

15 Dec '22

Anyone have any tricks for printing a summary band ONLY when the SUMMARY clause is used. IOW if I make a plain old REPORT FORM blah I don't want the summary band to print. -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

Help with a regular expression
by Paul Newton 12 Dec '22

12 Dec '22

Hi all I've been very quiet for a while so I thought it was about time I chimed in again. I have come across the use of a regex expression in another language which works like this: acid1 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid (2.13)" acid2 = "Methionine = (S)-2-amino-4-(methylsulfanyl)-butanoic acid" NumberAtEnd:= proc(S::string) description "Extract a parenthesized number, possibly containing periods, from the end of a string": local r; if StringTools:-RegMatch("\$([0-9.]*)\$$", S, r$2) then r else FAIL fi end proc: NumberAtEnd(acid1) returns "2.13" NumberAtEnd(acid2) returns "FAIL" How can this be done in VFP? Many thanks Paul Newton *** *

5 13

ProFox List Statistics for November 2022
by List Administrator Account 01 Dec '22

01 Dec '22

================================================== ProFox List Statistics November 2022 ================================================== Subscriber Count at End of Month: ProFox: 303 ProFoxTech: 183 ================================================== Total Posts: 33 (Up 22.22% from October 2022) Total [OT] Posts: 0 (Unchanged from October 2022) Total [NF] Posts: 14 (Up 100.0% from October 2022) Daily Message Counts for November 2022 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 1 F 4 - 6 S 12 - 1 S 13 - 8 T 15 - 13 W 16 - 3 T 17 - 1 Message Counts By Day of Week for November 2022 ------------------------------------------------ DOW Count --- ----- Sun - 8 Tue - 14 Wed - 3 Thu - 1 Fri - 6 Sat - 1 Distinct Posters to the List (changes relative to October 2022) ------------------------------------------------ Non-OT messages: 16 (Up 6.67%) OT messages: 0 (Unchanged) NF messages: 5 (Up 100.0%) Total number: 16 (Up 6.67%) Top 16 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Paul Newton 2. 4 Virgil Bierschwale 3. 2 Bill Anderson 4. 2 Eric Selje 5. 2 Michael Oke, II 6. 2 Ed Leafe 7. 2 Ted Roche 8. 1 Michael Glassman 9. 1 Alan Bourke 10. 1 Frank Cazabon 11. 1 Paul H. Tarver 12. 1 Graham Brown 13. 1 Darren 14. 1 List Administrator Account 15. 1 Tracy Pearson 16. 1 Jürgen Wondzinski Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 5 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Paul Newton 2. 2 Ed Leafe 3. 2 Ted Roche 4. 1 Alan Bourke 5. 1 Frank Cazabon Top 16 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Paul Newton 2. 4 Virgil Bierschwale 3. 2 Bill Anderson 4. 2 Eric Selje 5. 2 Michael Oke, II 6. 2 Ed Leafe 7. 2 Ted Roche 8. 1 Michael Glassman 9. 1 Alan Bourke 10. 1 Frank Cazabon 11. 1 Paul H. Tarver 12. 1 Graham Brown 13. 1 Darren 14. 1 List Administrator Account 15. 1 Tracy Pearson 16. 1 Jürgen Wondzinski Top 5 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Paul Newton 2. 1 Graham Brown 3. 1 Virgil Bierschwale 4. 1 List Administrator Account 5. 1 Bill Anderson Top 7 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Howdy Folks 2. 7 [NF] PyWin32 for Python 2.3.1 3. 7 [NF] Right-click Open with options 4. 4 VFP9 starts in a folder it creates instead of the HOME() folder 5. 2 Dymo Twin Turbo 6. 2 ChilkatVFP 1.1 released - Now with Events support! 7. 1 ProFox List Statistics for October 2022 Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 7 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Howdy Folks 2. 7 [NF] PyWin32 for Python 2.3.1 3. 7 [NF] Right-click Open with options 4. 4 VFP9 starts in a folder it creates instead of the HOME() folder 5. 2 Dymo Twin Turbo 6. 2 ChilkatVFP 1.1 released - Now with Events support! 7. 1 ProFox List Statistics for October 2022

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2022