ProFox April 2017

profox@leafe.com

44 participants
50 discussions

Easy way to get UNC from drive mapping?
by mbsoftwaresolutions＠mbsoftwaresolutions.com 11 Apr '17

11 Apr '17

I use GETFILE() to select a file from the network. I want the resulting filename (saved elsewhere) to have the UNC drive mapping instead of the mapped drive letter. Just wanted to check to see if anyone has this before I stick-build it using registry classes. (See https://pattersonsupport.custhelp.com/app/answers/detail/a_id/8981/~/viewin…) Thanks! --Mike

4 6

[NF] [FW] Microsoft Word has a terrifying new VIRUS - and there's only one way to avoid it
by Man-wai Chang 11 Apr '17

11 Apr '17

Full story: http://www.express.co.uk/life-style/science-technology/790224/Microsoft-Off… MICROSOFT WORD and Microsoft Office users have been warned about a new zero-day security flaw that enables hackers to remotely install malware on your PC, security McAfee has warned. Microsoft Office is vulnerable to a dangerous new malware attack, renown anti-virus company McAfee has cautioned. The security flaw enables cyber-criminals to covertly install malware on your PC. The terrifying attack is possible thanks to a flaw in Microsoft's Object, Linking and Embedding (OLE) technology, McAfee warned in a blog post. The security company wrote: "The exploit works on all Microsoft Office versions, including the latest Office 2016 running on Windows 10. "The earliest attack we have seen dates to late January." Hackers are using Microsoft Word documents (or more specifically, RTF files listed with a “.doc” extension) to trick people into opening the files. .... more ... Well, anti-virus firm McAfee has a few suggestions to keep safe. "Do not open any Office files obtained from untrusted locations," the company warns. "According to our tests, this active attack cannot bypass the Office Protected View, so we suggest everyone ensure that Office Protected View is enabled." To enable Office Protected View in your application, launch Microsoft Word. Then navigate to File > Options > Trust Centre, then click on Trust Centre Options. Click on Protected View, then check all of the three tick boxes listed beneath this option. Hit OK to finalise the changes – and you should be protected against the latest malware attack. .... more ... -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

2 1

[NF] free tool for mySQL
by Stephen Russell 11 Apr '17

11 Apr '17

https://www.idera.com/productssolutions/freetools/monitor-mysql-queries I don't know of many tools fo mySQL but I read this page and it gives functionality that I have in SSMS for analysis on a query. Learning how to read plans is what this will get you started with when you use it. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Southwest Fox 2017: No Xbase++ conference in 2017
by Rick Schummer 11 Apr '17

11 Apr '17

Dear Xbase++ and Fox Communities, Geek Gatherings LLC, the organizers of Southwest Fox and Southwest Xbase++, have partnered with Alaska Software and the best speakers from the Xbase++ community to run Southwest Xbase++ for the past five years. Last November, Alaska Software informed us their core staff members would not be presenting at conferences in 2017, in order to focus on their other commitments including the LEAP program, which tests Visual FoxPro source code projects in Xbase++. After hearing the news, we initially thought we would put the Xbase++ conference on hiatus for a single year as Alaska expects to have speakers available again in 2018. But after talking with others in the Xbase++ Community (including Alaska), we decided to try to run the conference without speakers from Alaska. We issued the Call for Speakers for both conferences. Unfortunately, we did not receive enough session proposals to put together an Xbase++ conference this year. We are naturally disappointed, but Alaska will continue to sponsor Southwest Fox and we are sure Southwest Fox will be a terrific conference on its own as it was for eight years before we incorporated the Xbase++ conference. In 2018, we hope to return to our usual dual conference format. We look forward to announcing the session topics and speakers and to getting registration rolling for 2017 very soon. Thank you for your continued support of Southwest Fox. Only 199 days until we gather in Gilbert. Regards, Tamar Granor, Rick Schummer, and Doug Hennig Southwest Fox and Southwest Xbase++ Organizers Geek Gatherings, LLC

1 0

Retrospective properties - the magic of inheritance
by Paul Newton 10 Apr '17

10 Apr '17

Hi all Let's say I have five classes (Class1, Class2 etc.) and that each class is a subclass of the one before it (class2 is a subclass of class1, class3 is a subclass of class2 etc.) Now let's suppose that I have added a custom property (e.g. "MyProperty") to class3 and set its value to "Property3". At this point class4 and class5 will inherit the property MyProperty with the value "Property3". Now I add the custom property MyProperty to class1 and set its value to "Property1" and everything is just fine. Now class2 will inherit the property MyProperty with the value "Property1" and classes class3, class4, class5 will inherit the property MyProperty with the value "Property3". I think that's great and potentially very useful because it means I can create a property at the top of the hierarchy without having to worry about whether a property of the same name has already been defined lower down the hierarchy. Paul Newton

6 6

strange behavior of reports
by Dr. Jörg Arand 10 Apr '17

10 Apr '17

Hallo all, I found a strange behavior of der report writer. It seems to enlarge the report.(?) The right and the bottom part of the page disappears. This behavior is independent of the standard printer (no driver issue!) Some ideas?? Example (the red numbers are for demonstration) In the report designer www.neodat.de/Reportdesigner.jpg <http://www.neodat.de/Reportdesigner.jpg> in the report www.neodat.de/Report.jpg <http://www.neodat.de/Report.jpg> ?????????????????????????????????? Dr. Jörg Arand Mail: Neodat(at)web.de --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

What's your SET ANSI setting? (VFP9SP2)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 08 Apr '17

08 Apr '17

Just ran across an instance where I had SET EXACT ON but didn't specify SET ANSI (for which the default is OFF). After seeing a query for CHICAGO contain results including others like CHICAGO HEIGHTS, I investigated and thought my SET EXACT was OFF. Nope, it was ON but my SET ANSI was OFF. Setting it to ON gave me the results I wanted. I'm just surprised this never bit me in all my years doing VFP; I guess because I've usually been using a RDBMS (like MySQL/MariaDB).

3 3

Re: Codeplex is shutting down, VFPX.org is spinning up
by Gene Wirchenko 05 Apr '17

05 Apr '17

At 01:07 2017-04-03, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: >On Fri, 31 Mar 2017, at 09:07 PM, Ted Roche wrote: > > You can always count on Microsoft... > > > > ... to let you down. > >Less than 350 projects had a commit in the last 30 days - sounds to me >like it's the user base letting itself down, or already moving elsewhere >for whatever reason. OTOH, if a project is complete, how many commits is it likely to get? Sincerely, Gene Wirchenko

2 1

Win10 Creator's Update?
by Ted Roche 04 Apr '17

04 Apr '17

Anyone here on the "Fast Track" or Beta testers on the Win10 Creator's Update (i.e. Windows 10 Rev 3: Original was 10.0, November patch was 10.5, Anniversary update was 10 Rev 2, so...)? http://www.zdnet.com/article/microsoft-confirms-windows-10-creators-update-… I've seen some some criticism posted in another form. I wondered if anyone had tested FoxPro on it, and what soft of (if any) gotchas we might need to look out for. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

3 4

ProFox List Statistics for March 2017
by List Administrator Account 01 Apr '17

01 Apr '17

================================================== ProFox List Statistics March 2017 ================================================== Subscriber Count at End of Month: ProFox: 288 ProFoxTech: 187 ================================================== Total Posts: 153 (Down 44.57% from February 2017) Total [OT] Posts: 1 (Down 50.0% from February 2017) Total [NF] Posts: 14 (Down 69.57% from February 2017) Daily Message Counts for March 2017 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 4 T 2 - 9 F 3 - 3 M 6 - 2 T 7 - 2 T 9 - 3 F 10 - 1 T 14 - 21 W 15 - 7 T 16 - 7 F 17 - 6 M 20 - 7 T 21 - 4 W 22 - 9 T 23 - 8 F 24 - 16 S 25 - 2 M 27 - 13 T 28 - 9 W 29 - 6 T 30 - 8 F 31 - 6 Message Counts By Day of Week for March 2017 ------------------------------------------------ DOW Count --- ----- Mon - 22 Tue - 36 Wed - 26 Thu - 35 Fri - 32 Sat - 2 Distinct Posters to the List (changes relative to February 2017) ------------------------------------------------ Non-OT messages: 36 (Down 10.0%) OT messages: 1 (Down 50.0%) NF messages: 7 (Down 58.82%) Total number: 36 (Down 12.2%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 16 Ted Roche 2. 15 Kurt Wendt 3. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 10 Paul Newton 5. 9 Dave Crozier 6. 8 Ken Dibble 7. 8 Man-wai Chang 8. 6 Alan Bourke 9. 6 Richard Kaye 10. 6 Tracy Pearson 11. 5 Fernando D. Bozzo 12. 5 Vince Teachout 13. 5 Jean Laeremans 14. 4 Gene Wirchenko 15. 4 Peter Cushing 16. 3 José Enrique Llopis 17. 3 Fred Taylor 18. 2 Kurt at VR-FX 19. 2 Kurt @ VR-FX 20. 2 Ajit Abraham Top 1 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 1 20% Gene Wirchenko Top 7 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Man-wai Chang 2. 3 Jean Laeremans 3. 1 Peter Cushing 4. 1 Ted Roche 5. 1 Ken Dibble 6. 1 Vince Teachout 7. 1 mbsoftwaresolutions(a)mbsoftwaresolutions.com Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 16 Ted Roche 2. 15 Kurt Wendt 3. 15 mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 10 Paul Newton 5. 9 Dave Crozier 6. 8 Ken Dibble 7. 8 Man-wai Chang 8. 6 Alan Bourke 9. 6 Richard Kaye 10. 6 Tracy Pearson 11. 5 Gene Wirchenko 12. 5 Fernando D. Bozzo 13. 5 Vince Teachout 14. 5 Jean Laeremans 15. 4 Peter Cushing 16. 3 José Enrique Llopis 17. 3 Fred Taylor 18. 2 Kurt at VR-FX 19. 2 Kurt @ VR-FX 20. 2 Ajit Abraham Top 11 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Paul Newton 2. 4 mbsoftwaresolutions(a)mbsoftwaresolutions.com 3. 3 Man-wai Chang 4. 3 Ted Roche 5. 3 Kurt Wendt 6. 1 List Administrator Account 7. 1 Thierry Nivelet 8. 1 Jean Laeremans 9. 1 Rick Schummer 10. 1 Wes Wilson 11. 1 Gene Wirchenko Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 21 Monday Survey Question 2. 17 R.I.P. Marcia Akins 3. 13 Screen Running & Order of Objects Firing... 4. 12 VFP9SP2 report error with _pagetotal variable 5. 12 New Excel BREAKS Prior Working Automation! 6. 11 Hard-Coded Scalar Value Substituted at Run Time 7. 6 [NF] About my Ubuntu adventure.... 8. 6 Excel class not registered 9. 6 Default application for shellexecute 10. 5 Finding geographical areas around a city name or zip code 11. 4 [NF] Scheduled Tasks, VFP, Batch, 7-Zip and PuTTY glitch 12. 4 Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.) 13. 4 Debug Window is HIDING From ME! 14. 4 FRX getting trashed 15. 3 Codeplex is shutting down, VFPX.org is spinning up 16. 3 Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.) 17. 3 VFP and fingerprint scanner 18. 3 [NF][FW] NASA Releases Tons Of Free, Open Source Software, Here’s How To Get Them 19. 3 FoxInCloud V 2.24 released, integrating Bootstrap 20. 2 Problem with VFPEX.FLL when using Remote Desktop Connection Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 1 [OT] Humour: I Work From Home Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 21 Monday Survey Question 2. 17 R.I.P. Marcia Akins 3. 13 Screen Running & Order of Objects Firing... 4. 12 VFP9SP2 report error with _pagetotal variable 5. 12 New Excel BREAKS Prior Working Automation! 6. 11 Hard-Coded Scalar Value Substituted at Run Time 7. 6 [NF] About my Ubuntu adventure.... 8. 6 Excel class not registered 9. 6 Default application for shellexecute 10. 5 Finding geographical areas around a city name or zip code 11. 4 [NF] Scheduled Tasks, VFP, Batch, 7-Zip and PuTTY glitch 12. 4 Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.) 13. 4 Debug Window is HIDING From ME! 14. 4 FRX getting trashed 15. 3 Codeplex is shutting down, VFPX.org is spinning up 16. 3 Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.) 17. 3 VFP and fingerprint scanner 18. 3 [NF][FW] NASA Releases Tons Of Free, Open Source Software, Here’s How To Get Them 19. 3 FoxInCloud V 2.24 released, integrating Bootstrap 20. 2 Problem with VFPEX.FLL when using Remote Desktop Connection

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2017