ProFox March 2022

profox@leafe.com

22 participants
11 discussions

Determine if a File is Open
by Carl Lindner 01 Apr '22

01 Apr '22

I extracted "d:\test_dir\test.pdf". Then used ShellExecute to open it. The user reads the pdf and later I want to erase it. But, it will not erase if the user has not previously closed it. How can I tell if it is closed? Even better, is there a way I can close it? Carl Lindner --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

FoxBin2PRG vs TwoFox
by Richard Kaye 30 Mar '22

30 Mar '22

Hey let's start another VFP thread here. I just noticed that Doug Henning released an update a few days ago for ProjectExplorer (and if you don't know what PEx is and you actively develop in VFP you should) which adds the ability to use different converters for VFP binaries. I've been using FoxBin2PRG in a Bitbucket environment with no significant issues for a while but am curious about the collective experience. Talk amongst ourselves... -- rk

3 5

CURSORTOXML and NULLs
by Richard Kaye 30 Mar '22

30 Mar '22

While I'm poking away at this, I thought I'd check with the collective wisdom. I've found a situation where I want to take advantage of CURSORTOXML and XMLTOCURSOR. The issue I'm running into is if the cursor being converted to XML has fields with NULL values in the first record, this appears to affect the resulting XMLTOCURSOR conversion. Any NULL columns will be missing from the result cursor even if later rows in the XML contain values. The hacky workaround seems to be I have to make sure that the first record has non-null values for all columns I want in the cursor. Anyone have any other magic tricks? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Virtual Fox Fest: Speakers, Topics,
by Rick Schummer 23 Mar '22

23 Mar '22

Virtual Fox Fest 2022 (May) is a one-day event on Thursday, May 5, 2022. We have some great speakers (https://virtualfoxfest.com/speakers.aspx) delivering great sessions (https://virtualfoxfest.com/sessions.aspx) live chatting during presentations, and getting to hang out virtually with new and old friends. This event will feature a mix of new and classic sessions from previous conferences, updated for 2022. Registration details (https://virtualfoxfest.com/register.aspx) deadlines, and cost are available on our Web site. Register for the conference here: http://geekgatherings.com/Registration. Don't procrastinate, get this done today! We're still discussing whether to hold Southwest Fox in Arizona this fall. We expect to announce our plans for a fall conference some time in April. More details here: https://virtualfoxfest.com Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Rude Words
by Paul Hill 13 Mar '22

13 Mar '22

Hi All, Something odd happened today at work. Not really Fox related. Our app (C#, WinForms) has a feature where on some screens you can embed a web browser in a tab to display a user definable webpage. The trouble is, the control is based on IE6 (?). We're in the process of updating this to Microsoft Edge WebView2. My tester contacted me today saying there's a funny folder with rude words in it. Swear words. What!?? I took a look. WebView2 will create a browser cache in the application folder unless otherwise specified. We can fix that. But what about the swear words? It turns out that she was using www.googlemaps.co.uk as a test. If you open this in a browser (*DO NOT DO THIS*) you get redirected to maps.google.com and all looks fine. In the cache folder a file called passwords.txt contains 30,000 passwords which are clearly the most common passwords (123456, password, etc). It also contains words like 'motherfucker'. There are other files with common male/female names and TV shows. So apparently googlemaps.co.uk redirects you to google maps and attempts a dictionary attack on your Google account. Nice! Enable 2 factor authentication folks! -- Paul

2 2

[NF] Facets Database???
by Kurt ＠ Gmail 07 Mar '22

07 Mar '22

Hey folks - anyone every heard of this kinda DB before? Myself - Never! So, I was surprised when this headhunter reached out to me about a job doing this stuff. And, I confirmed - she insists the person must obviously have hands-on experience with it. This is the info about the Gig and her info (she connected with me on LinkedIn - so you can connect with her there): Facets Database Developer *Hi there! We’re searching for a database developer with strong Facets experience. This role will potentially be a role that will be contract to hire, but in the meantime it’ll be 100% remote and a contract. The role will be gathering all information regarding the intended functions of the Facets database and configuring, and designing and creating appropriate frameworks. Do you know someone who is a fit? We’re interviewing asap. Lauren Daher Senior Manager, Consultant Engagement at Catalyst Solutions* I'd say TGIF - but, in my case - nothing to be thankful for in regards to sliding into the weekend... -Kurt --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 15

Using gmail to send emails from your VFP apps -- deadline approaching for shutoff
by MB Software Solutions, LLC 04 Mar '22

04 Mar '22

Z290IHRoaXMgbm90aWNlIGZyb20gZ29vZ2xlIHRvZGF5OgoKCiAgTGVzcyBzZWN1cmUgYXBwcyAmIHlvdXIgR29vZ2xlIEFjY291bnQKClRvIGhlbHAga2VlcCB5b3VyIGFjY291bnQgc2VjdXJlLCBzdGFydGluZypNYXkgMzAsIDIwMjIqLCDigIvigItHb29nbGUgd2lsbCAKbm8gbG9uZ2VyIHN1cHBvcnQgdGhlIHVzZSBvZiB0aGlyZC1wYXJ0eSBhcHBzIG9yIGRldmljZXMgd2hpY2ggYXNrIHlvdSAKdG8gc2lnbiBpbiB0byB5b3VyIEdvb2dsZSBBY2NvdW50IHVzaW5nIG9ubHkgeW91ciB1c2VybmFtZSBhbmQgcGFzc3dvcmQuCgpQbGVhc2Ugbm90ZSB0aGlzIGRlYWRsaW5lIGRvZXMgbm90IGFwcGx5IHRvIEdvb2dsZSBXb3Jrc3BhY2Ugb3IgR29vZ2xlIApDbG91ZCBJZGVudGl0eSBjdXN0b21lcnMuIFRoZSBlbmZvcmNlbWVudCBkYXRlIGZvciB0aGVzZSBjdXN0b21lcnMgd2lsbCAKYmUgYW5ub3VuY2VkIG9uIHRoZSBXb3Jrc3BhY2UgYmxvZyBhdCBhIGxhdGVyIGRhdGUuCgpGb3IgbW9yZSBpbmZvcm1hdGlvbiwgcGxlYXNlIGNvbnRpbnVlIHJlYWRpbmcuCgoqU3BlY2lhbCBOb3RlIG9uIEFwcGxlIERldmljZSBTaWduLUlucy4qVXNlcnMgd2hvIGhhdmUgbm90IHJlY2VudGx5IApzaWduZWQgaW50byB0aGVpciBHb29nbGUgQWNjb3VudCB1c2luZyBvbmx5IHVzZXJuYW1lIGFuZCBwYXNzd29yZCB3aWxsIApiZSBhYmxlIHRvIG9ubHkgbWFrZSBuZXcgc2lnbiBpbiBhdHRlbXB0cyB1c2luZyB0aGUgR29vZ2xlIGFjY291bnQgdHlwZSAKc3RhcnRpbmcgZnJvbSpGZWJydWFyeSAyOCwgMjAyMiouIEV4aXN0aW5nIHVzZXJzIG1heSBjb250aW51ZSB0byBzaWduIAppbnRvIHRoZWlyIEdvb2dsZSBBY2NvdW50IHVzaW5nIHRoZWlyIHVzZXJuYW1lIGFuZCBwYXNzd29yZCB1bnRpbCpNYXkgCjMwLCAyMDIyKi4KCklmIGFuIGFwcCBvciBzaXRlIGRvZXNu4oCZdCBtZWV0IG91cnNlY3VyaXR5IHN0YW5kYXJkcyAKPGh0dHA6Ly90cmFjay5zbXRwc2VuZGVtYWlsLmNvbS85MDc0OTY3L2M/cD1tbGw1RTgxdWFtb3UtSUszVjFuNDlNNjhDMDdmTjJvVFZWMFRiSVNXLW0zb3dQc3Ftd09hM0FyeDlvOTZUanpSUnZxNjNESUxvWThqWjRCUEppYl83dmM2SDl6WkVOQ0l4NzNKc0cyTUZWZ3JGQXVzWFdEWmpYM3dWcGxTTkZybWUzVmlFZ3hzNXRodXJ1UWxIYnJCUlRnQ3ZqemlQLWg3QTNvNDlXVUlCUncyS0dNUUVyZHBaak44OElNQTgyZUlvazJhZUh4SHBQeXZmZTlqNTFoMm5DUmpESlpielpuWWNnTzVRSTB4dVg0Z0NJWG5qTVRXZmR5WXhSUkpSeDZfPiwgCkdvb2dsZSBtaWdodCBibG9jayBhbnlvbmUgd2hv4oCZcyB0cnlpbmcgdG8gc2lnbiBpbiB0byB5b3VyIGFjY291bnQgZnJvbSAKaXQuIExlc3Mgc2VjdXJlIGFwcHMgY2FuIG1ha2UgaXQgZWFzaWVyIGZvciBoYWNrZXJzIHRvIGdldCBpbiB0byB5b3VyIAphY2NvdW50LCBzbyBibG9ja2luZyBzaWduLWlucyBmcm9tIHRoZXNlIGFwcHMgaGVscHMga2VlcCB5b3VyIGFjY291bnQgc2FmZS4KCgouLi5zbyBJJ20gZ3Vlc3NpbmcgbXkgbGVnYWN5IGFwcHMgb3V0IHRoZXJlIGF0IGNsaWVudHMgd2lsbCBubyBsb25nZXIgYmUgCmFibGUgdG8gdXNlIHRoZSBpbnRlcm5hbCBlcnJvciByZXBvcnRpbmcgKHRoYXQgc2VuZHMgYW4gZW1haWwgdG8gbWUgZnJvbSAKbXkgZ21haWwgYWNjb3VudCkuCgpGWUkgZm9yIHRob3NlIG9mIHlvdSB3aG8gdXNlIGdtYWlsIGluIG91ciBhcHBzIGZvciB0aGlzIGtpbmQgb2YgZW1haWxpbmcgCnB1cnBvc2UuCgoKLS0gCk1pY2hhZWwgSi4gQmFiY29jaywgTUNQCkZveC9WRlAgZGV2IHNpbmNlIDE5OTcKRGV2ZWxvcGVyIG9mIEZhYk5ldCBlc3RpbWF0aW5nIHNvZnR3YXJlIC0gbWJzb2Z0d2FyZXNvbHV0aW9ucy5jb20K--- StripMime Report -- processed MIME parts ---multipart/alternative text/plain (text body -- kept) text/html---

5 7

Using gmail to send emails from your VFP apps -- deadline approaching for shutoff
by MB Software Solutions, LLC 04 Mar '22

04 Mar '22

Attempt #2...this time as text-only....allegedly.... got this notice from google today: Less secure apps & your Google Account To help keep your account secure, starting*May 30, 2022*, Google will no longer support the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password. Please note this deadline does not apply to Google Workspace or Google Cloud Identity customers. The enforcement date for these customers will be announced on the Workspace blog at a later date. For more information, please continue reading. *Special Note on Apple Device Sign-Ins.*Users who have not recently signed into their Google Account using only username and password will be able to only make new sign in attempts using the Google account type starting from*February 28, 2022*. Existing users may continue to sign into their Google Account using their username and password until*May 30, 2022*. If an app or site doesn’t meet oursecurity standards <http://track.smtpsendemail.com/9074967/c?p=uWQtfgxA4Aaf-lDhHff3zusNJX4bc0Fe…>, Google might block anyone who’s trying to sign in to your account from it. Less secure apps can make it easier for hackers to get in to your account, so blocking sign-ins from these apps helps keep your account safe. ...so I'm guessing my legacy apps out there at clients will no longer be able to use the internal error reporting (that sends an email to me from my gmail account). FYI for those of you who use gmail in our apps for this kind of emailing purpose. -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

1 0

Converting RTF to HTML
by paul.newton.hudl＠gmail.com 03 Mar '22

03 Mar '22

Hi all I spent some time looking for a utility to convert RTF to HTML and asked for help. Darren very kindly offered to help and came up with a solution based on RtfPipe, a .NET library available on nuget We are making it temporarily available here https://drive.google.com/drive/folders/1-K64g4NuEJmk0patx_U80DZte6j9uMHJ?usp =sharing If anybody thinks it deserves to be made available on Ed's download section, I will submit it for approval. Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

Forms layout manager
by paul.newton.hudl＠gmail.com 03 Mar '22

03 Mar '22

Hi all I wonder whether this might be useful and/or of interest - it can be downloaded here: https://drive.google.com/drive/folders/1v_JUnY-o0jJY-WvpW6N0rO2O7GolFKRd?usp =sharing Paul Newton Forms layout manager (FLM) Description This is a small utility that enables saving and restoring of form layouts. Many of you will have come across situations where the controls on a form are shuffled around at runtime. In order to achive this, the developer will have to work with one form design and then adjust TOP and LEFT for a number of controls by implementing code to make the runtime adjustments. But all the time, in design mode they only see one layout. What if you could have one form (SCX) but have two different views of it at design time and implement either or both designs at run time (i.e. expose one design or the other for the user, or even let the user switch between the two different layouts). What if all of this could be achieved more or less effortlessly and with no need to remember and or calculate object positions? Welcome to the Forms layout manager. How it works Start with a form design, say "Expanded". Run the Forms layout manager and have it store the positions of all the objects at the form level. These will be stored in a table (well I never) and the same table will be used for all forms and all form designs. At the same time that the form design is being saved, FLM can also generate code to reposition the controls at runtime. Now modify the form design, reposition the controls, make the form larger or smaller and so on. Let's call this design "Compact". Let FLM save the new layout and generate the code to reproduce the layout at runtime. Now whenever you want to work in the form designer, and see in the designer what the user will see, simply use FLM to restore the required layout ("Expanded" or "Compact"). In other words, when working in the form designer you will see just one design, uncluttered by the controls in the other layout. At the moment, FLM only processes LEFT and TOP but it is designed in such a way that other properties (e.g. WIDTH, HEIGHT, FILLCOLOR etc) could be handled in the same way with minimal changes required in FLM. I have not yet investigated whether the concept could be extended to classes in a VCX. One thing at a time ... --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox March 2022