ProFox December 2023

profox@leafe.com

13 participants
8 discussions

Class definition is cyclical error
by Tracy Pearson 27 Dec '23

27 Dec '23

I have a base class library. In it I have a ccontainer class that is (no surprise here) based on the vfp container. I have a test class library (testlibrary) that I have subsclassed ccontainer (testcon) and added a ccontainer (innerContainer) in. Then added another container (innerInnerContainer). When I add the testlibrary to the Form Controls Toolbar and attempt to add the testcon class to a form I get the following: Error loading file - record number 21. innerInnerContainer <or one of its members>. Parent : Cannot add INNERINNERCONTAINER. Class definition is cyclical If you drag the control from the Project Explorer (Project Manager) the error appears during runtime. In all the time I have been building apps, I'm not sure I have ever seen this happen. It was originally seen as a problem when my coworker was building a new class that gets loaded dynamically. He was building a UI that changes what is visible depending on what options are set. A pageframe changes pages depending what is selected. His is container with a pageframe and another pageframe on page2. Error loading file - record number 25. InnerPageFrame <or one of its members>. Parent : Cannot add INNERPAGEFRAME. Class definition is cyclical Is there a way around this? Thank you, Tracy

1 0

[NF] T'was the Night Before Crisis
by Ted Roche 23 Dec '23

23 Dec '23

'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!

3 2

Geek Gatherings 2024: Save the Dates!
by Rick Schummer 21 Dec '23

21 Dec '23

We have locked in our dates for our 2024 conferences and hope you will save the dates to attend. Our one-day Virtual Fox Fest 2024 will be Wednesday, May 8, 2024. It still has the same great features everyone loves about VFF: great speakers delivering great sessions, live chatting during presentations, and getting to hang out virtually with new and old friends. This event will feature classic sessions from previous conferences, updated for 2024. We're excited to offer you Southwest Fox 2024, a hybrid conference, September 26-29, 2024. You decide whether to come in person or watch online! The in-person event will be held at the Hampton Inn & Suites Phoenix-Scottsdale in Scottsdale, Arizona. The virtual event will use the Ring Central Hopin platform (the same platform we use for Virtual Fox Fest). Web sites will be updated in the new year. Call for speakers will be announced later in February so get your ideas prepared. Rick White Light Computing, Inc.

1 0

Printer Dialogue
by Chris Davis 21 Dec '23

21 Dec '23

I'm not certain when but in Windows 11 the printer dialogue for 32 bits apps changed ... If you leave the new dialogue active (you can change registry settings to force the old one) then anything you do with set printer before printing a report with printer prompt brings up the dialogue but it just displays the default printer, is forcing the old dialogue the only solution for vfp apps or is there a way to get vfp to work nicely with it? TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Index & Seek Question
by Paul H. Tarver 18 Dec '23

18 Dec '23

Been quiet in here for a while, so I thought I'd toss out something I'm tinkering with and ask for your advice. Besides, I want to keep my name on the monthly top 10! J I have a large table populated with the IP2LOCATION-LITE-DB3 list. I'm running a process to convert an IPV4 address into a decimal number and then locate the first record in my table where the value I'm looking up is between the From_IP numeric value and the To_IP numeric value in the table Here's the code snippet I have working now: ---------------------------------------------------------------------- LPARAMETERS toParams LOCAL lcBase2IP, lnElements, lnIpNumber IF USED("ip_locs") lcCurrSel = ALIAS() lnElements = ALINES(ipsegment, toParams.ocClientIp, 1, ".") IF lnElements = 4 lcBase2IP = PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[1])), 2), 8, "0") + ; PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[2])), 2), 8, "0") + ; PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[3])), 2), 8, "0") + ; PADL(THISFORM.utilities.DEC2BASX(VAL(ALLTRIM(ipsegment[4])), 2), 8, "0") lnIpNumber = THISFORM.utilities.bin2dec(lcBase2IP) SELECT ip_locs LOCATE FOR lnIpNumber => ip_locs.ip_from AND lnIpNumber <= ip_locs.ip_to IF FOUND('ip_locs') toParams.ocCountry_Code = ip_locs.Country_Code toParams.ocCountry_Name = ip_locs.Country_Name toParams.ocRegion_Name = ip_locs.Region_Name toParams.ocCity_Name = ip_locs.City_Name ENDIF ENDIF SELECT (lcCurrSel) ENDIF RETURN ----------------------------------------------------------- This works fine and it really isn't that slow. It takes about 30 - 60 seconds to do the location look up on a list of 50,000+ ip address records. I'm pretty sure I'm getting Rushmore optimization on the LOCATE FOR line, but I've been wondering if there is a way to use SEEK with an index to find a value between the numeric IP_FROM field and the numeric IP_TO field. But I cannot figure out how I can create an index that would give me Rushmore optimization and let me use the SEEK command for a value between those to numerics. FYI, I tried doing a simple SQL query to a temporary cursor, but surprisingly, the LOCATE FOR command is actually faster. Hey, I know I'm being greedy, but I'm wondering if it is possible to squeeze any more speed out of this process. I may be using the best method, but I figured if y'all had a minute you might give me a little feedback. Thanks in advance! Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

Chilkat version 1.3 release
by Bill Anderson 08 Dec '23

08 Dec '23

Folks, Version 96 compatibility completed. Version 96 is a pretty big release, including the new DNS class. Located some methods and properties missing from the Chilkat release notes and added them. Found one more class missing a Version property. As ever, documentation fixes and additions, minor code fixes. Let me know what you think... https://github.com/billand88/ChilkatVFP Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

[OT[ Other languages
by Graham Brown 01 Dec '23

01 Dec '23

Hi Dumb question time. Vis Fox has been a huge part of my career since the late 90s, I still support my VFP apps but I now find my new developments are either PHP or VS.NET. Has there been any thought to creating lists for other languages like Web, mobile, VB.Net and C#? Is there a requirement for this within the group? Just wondering about our brave new world! Regards Graham --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

ProFox List Statistics for November 2023
by List Administrator Account 01 Dec '23

01 Dec '23

================================================== ProFox List Statistics November 2023 ================================================== Subscriber Count at End of Month: ProFox: 305 ProFoxTech: 184 ================================================== Total Posts: 23 (Down 37.84% from October 2023) Total [OT] Posts: 0 (Unchanged from October 2023) Total [NF] Posts: 0 (Unchanged from October 2023) Daily Message Counts for November 2023 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 3 T 7 - 3 M 13 - 7 T 14 - 3 W 15 - 6 T 30 - 1 Message Counts By Day of Week for November 2023 ------------------------------------------------ DOW Count --- ----- Mon - 7 Tue - 6 Wed - 9 Thu - 1 Distinct Posters to the List (changes relative to October 2023) ------------------------------------------------ Non-OT messages: 9 (Down 30.77%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 9 (Down 30.77%) Top 9 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 9 Chris Davis 2. 3 <juergen(a)wondzinski.de> 3. 3 Paul H. Tarver 4. 2 Richard Kaye 5. 2 Dr. Joerg Arand 6. 1 Ted Roche 7. 1 List Administrator Account 8. 1 Bill Anderson 9. 1 António Tavares Lopes Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 9 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 9 Chris Davis 2. 3 <juergen(a)wondzinski.de> 3. 3 Paul H. Tarver 4. 2 Richard Kaye 5. 2 Dr. Joerg Arand 6. 1 Ted Roche 7. 1 List Administrator Account 8. 1 Bill Anderson 9. 1 António Tavares Lopes Top 5 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 List Administrator Account 2. 1 Dr. Joerg Arand 3. 1 Chris Davis 4. 1 Bill Anderson 5. 1 <juergen(a)wondzinski.de> Top 7 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 15 ZPL 2. 3 ProFox List Statistics for October 2023 3. 1 Base64 and Excel automation 4. 1 Chilkat version 1.3 release 5. 1 AW: Base64 and Excel automation 6. 1 WG: Base64 and Excel automation 7. 1 ChdkDsk from VFP Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 7 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 15 ZPL 2. 3 ProFox List Statistics for October 2023 3. 1 Base64 and Excel automation 4. 1 Chilkat version 1.3 release 5. 1 AW: Base64 and Excel automation 6. 1 WG: Base64 and Excel automation 7. 1 ChdkDsk from VFP

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox December 2023