ProFox March 2017

profox@leafe.com

36 participants
36 discussions

Re: Monday Survey Question
by Ken Dibble 20 Mar '17

20 Mar '17

>1. How many VFP books do you own? Somewhere around a dozen. >2. How many are dead-tree paper and how many ebooks? All dead trees though I did get the ebooks with the Hentzenwerk ones. >3. What is your most well-worn VFP books? Or most referenced ebook? What's New in 9 >4. What book do you regret not owning? Tamar's book on SQL. >5. Would you buy VFP books if you could find them? Possibly. >6. Preferred format? Paper, PDF, CHM, ePub, HTML, other (which?) Paper. Ken Dibble www.stic-cil.org

1 0

Not too late for Southwest Fox 2017 session proposals
by Rick Schummer 20 Mar '17

20 Mar '17

We're still looking for a few more speaker submissions for Southwest Fox 2017. If you have something to share with our developer community, read the Call for Speakers (http://www.swfox.net/CallForSpeakers.pdf) and then use the Submission site (https://geekgatherings.com/Submission/Speaker) to send us your ideas. Please let us hear from you by next Monday, March 27. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Printing native VFP reports to other types (like XLSX, PDF, DOCX, etc.)
by mbsoftwaresolutions＠mbsoftwaresolutions.com 17 Mar '17

17 Mar '17

Wanted to see what folks are using for this? Years ago I had XFRX for various outputs. tia, --Mike

6 8

R.I.P. Marcia Akins
by Jean Laeremans 17 Mar '17

17 Mar '17

Some of you who participate on the Universal Thread might already be aware of this. This morning Andy Kramek emailed me and told me of the very untimely passing of Marcia Akins. He asked me to post the following message on his behalf: *I am sorry to tell you that Marcia died peacefully and without stress or discomfort at just after 11:00 am this morning (Sunday 12 March) in the hospital at the University of Arkansas For Medical Sciences (UAMS). She collapsed last Saturday at the airport on the way to visit her sister and was taken to hospital. She was diagnosed with Hyponatremia (low Sodium) which it appears either caused, or was caused by, severe acute hepatitis. Unfortunately she did not respond to treatment and declined suddenly and rapidly. She didn’t suffer at all and her end was so peaceful that her friend Joanie and I, who were both with her, didn’t even realize that she had stopped breathing for several minutes. She will, in accordance with her wishes be cremated, and we will be holding some sort of memorial for her and a wake (you know how much Marcia loved a good party) sometime in the not-too-distant future here in Hot Springs Village. No flowers please, and if anyone wishes to make a donation in her name, her favorite charity was Disabled American Veterans. * My apologies if I've posted this in the wrong category area. Very sad news. Kevin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

14 16

Re: New Excel BREAKS Prior Working Automation!
by Gene Wirchenko 16 Mar '17

16 Mar '17

At 18:44 2017-03-14, Kurt at VR-FX <vrfx(a)optonline.net> wrote: >OK - since you DID ask. FYI - I actually Step thru the code - and >when I do - everything works fine! That's why its an even stranger conundrum!!! > >Also - as previously mentioned - I actually Was testing on a machine >that has the problem. And, even on there - when stepping thru the >code - the problem then does NOT occur... > >:-( This has the smell of a race condition. You might not be able to get at the actual cause. You may have to -- shudder -- kludge. If someone comes up with a non-kludge, use that in preference to this. On a misbehaving system, try adding a sleep(10000) between each statement. Does the problem still occur? If so, come up with something else to stick in a delay that gets rid of the problem. If it is response-related, try a keyboard-messagebox() sequence. If not or after finding an alternative delay method, start removing the delays until you find where the problem triggers. Keep that one. You might shave the time down some, too. (I selected 10 seconds as overkill*.) After getting it to the minimal number of delays, try removing them all. This might work. Why? Who knows? * Gene's Law of Overkill: First, you have to kill. Only then can you overdo it. [snip] Sincerely, Gene Wirchenko

2 1

New Excel BREAKS Prior Working Automation!
by Kurt Wendt 15 Mar '17

15 Mar '17

Good afternoon fellow ProFoxers! I hope you are faring well - for those of you like me in the NE USA hit by the storm. They sent out emergency communications yesterday from my job - saying office would be closed today - yet, instead of FEET of Snow - I woke up and all the Rain/sleet seems to have melted it down to like 3 or 4 inches tall at best! Well - alas - I digress. So - here's the deal. Recently I had a User get a problem with a particular option in an application - something that had always worked. Stranger still - as the old saying goes "It works on MY Machine" is also occurring - since the problem would NOT occur on my machine. Even went a step farther, as he had the gal sitting next to him try the same option - and it failed for her. I then went farther. I logged into another machine, and it worked. Went to a QA gal - she tried it - and it work. In the end - a buddy of mine in Systems who deals with networking and user support - he had like 7 different users try it - and it failed for all of them. In the end - his deduction was problem being tied to Excel - as I am running 2010 - and the systems experiencing the problem are 2013. Short explanation of the actual problem. This app - reads in an Excel file using Automation. Grabs the data in the header area of spreadsheet and fills in var's. Then it takes the main data - a bunch of rows/columns - and pushes the data into a CSV file that it creates via Automation. The 2nd phase shows a screen w/Header info - and displays name of the CSV file. Then asks if you want to Proceed with processing the data. Here in lies the problem. In my case - when I run the option - the CSV file is fine. But, for the users that are having the problem - the CSV file is EMPTY! Now - before reporting this problem to you all here - I've been doing a bunch of research - as well as Testing various options. I even looked at a prior thread here in this forum - as it was VERY Similar to my own conundrum: "Copy Excel worksheet to another workbook". And, one of the tricks I noticed that was mentioned is that after Copying the range of Cells from the FROM Excel file - and before Pasting into the TO Workbook (that will become the CSV file) - that it was suggested to CLOSE the From Workbook. So - I did that - but, then I get the following error message being thrown: "The object invoked has disconnected from its clients." I even tried a similar operation by hand (as I have remote access to another PC in my office that has Excel 2013 - so I can test for the problem) - by doing the Copy of the Cells, Closed the workbook - then went to the Other workbook and did Paste - and it worked - NO Error and data was pasted! As such - I'm rather stumped! It's really SUCH a Drag when changes to Office now crash out Code that previously worked. A fellow developer has suggested another Kludge - as Gene so adeptly states the term - which is to do a more manual pasting of cell data one by one - literally assigning the values to the Cells instead of by doing the Paste command. I did do a test by simply assigning "Hello World" to a single cell - and that DID work. But, I'd rather a more Elegant solution AND something that knows what the Actual problem is and can fix it with less code. Especially since I worry that this problem may run DEEPER than the users think - and that a BUNCH of other similar options in this application may ALSO Start to fail for all these users! TIA! Regards. Kurt Wendt Senior Systems Analyst One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.com GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email.

5 5

[NF] Scheduled Tasks, VFP, Batch, 7-Zip and PuTTY glitch
by Ted Roche 10 Mar '17

10 Mar '17

Hi, folks: What I think is a [NF] Non-Fox question. PROBLEM: I've taken over a legacy app's backup batch routine. It automatically worked on their old machine (Windows 2000!) but I'm having trouble duplicating it in "Schedule Tasks" on their replacement machine, a Win 7 Pro workstaton. BACKGROUND: Once a day, the scheduled task launches a VFP executable that: CD's to a local directory Opens a local DBF or recreates it if missing, with a single record containing a date Reads that DBF to get the date Does an ADIR to read a network file's last update date If the local file date # the remote date, It UPDATEs the table with the remote date It does a RUN /N to launch a .BAT which: XCOPY's the network files to the c: drive 7-ZIPs the files into an archive invokes PuTTY's pscp to perform a secure copy to a "cloud" server. (PuTTY's pagent is running in the desktop tray, with the necessary private key loaded) The scheduled task is configured to run this in the same context as the primary user of the machine. EXPECTED: When I am logged in as that user via RDP and run the EXE, the app works as expected. ACTUAL: When it runs from Scheduled Tasks, either automatically or manually invoked, there's no screen interaction, of course, but no file sent, either. The EXE shows up in the Task Manager, initially using 3,456K of memory, then it slowly decreases down to 318K WHAT I'VE TRIED: Running while logged in (remotely via RDP) works fine. Changing the network locations (F:) to UNC (\\fileserver\sharename\path) didn't make a difference. Ticking the checkboxes in Scheduled Tasks for "Log in as" or "Run only when logged in" or "Use maximum permissions" made no difference. Ideas? Is this a WinPro7 v. 2000 security "feature" I'm running into? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

3 2

Re: [NF] Scheduled Tasks, VFP, Batch, 7-Zip and PuTTY glitch
by Ken Dibble 09 Mar '17

09 Mar '17

>Ticking the checkboxes in Scheduled Tasks for "Log in as" or "Run only >when logged in" or "Use maximum permissions" made no difference. > >Ideas? Is this a WinPro7 v. 2000 security "feature" I'm running into? I have run into this. I THINK that I was able to overcome it by promoting the user for whom the task must run to local administrator, then creating the scheduled task with maximum permissions on every related damn thing I could find, and then demoting the user. Not scientific, I know. And this is a vague memory of a problem I dealt with something like three years ago, so take it for what it's worth. But I did solve the problem, because the task, to pop-up a message in the middle of the day, persisted in annoying this user for quite some time until we finally disabled it. Ken Dibble www.stic-cil.org

1 0

FoxInCloud V 2.24 released, integrating Bootstrap
by Thierry Nivelet 07 Mar '17

07 Mar '17

Hi, Just let you know (if you don't already) that FoxInCloud 2.24 can now build a Responsive Web Application out of any 'legacy' VFP desktop application. More details on blog post: http://bit.ly/2lY4CsV Thanks -- Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/

2 2

[NF][FW] NASA Releases Tons Of Free, Open Source Software, Here’s How To Get Them
by Man-wai Chang 07 Mar '17

07 Mar '17

Download Page: https://software.nasa.gov/ List of tools: https://software.nasa.gov/NASA_Software_Catalog_2017-18.pdf Full story: https://www.techworm.net/2017/03/nasa-released-massive-catalog-free-open-so… The software is being made available through the NASA Technology Transfer Program keeping in line with its motto fo â€œBringing NASA Technology Down to Earthâ€ . The available codes are listed in the NASA Software Catalog, now in its third edition, published this week. While much of the software is entirely in the public domain, some programs may only be released for use on a government project or are subject to export controls allowing use only by U.S. persons. NASA says that the freely released tools will be useful for top professionals, entrepreneurs, small businesses, industry, and academia and have a potential to create jobs, save lives, and earn revenue. The NASA catalog contains some award winning software likeTraffic Aware Planner, is an in-cockpit tool to assist pilots in requesting the most efficient route of flight taking into consideration the position and track of nearby aircraft. The second, Pegasus 5, is a computational fluid dynamics solver, which allows users to calculate the pressure and temperature of fluid flows to model system performance, such as lift and drag from an airframe in flight. Although likely not as popular as astronaut ice cream, the most requested piece of NASA software in 2016 was Schedule Test and Assessment Tool, a plug-in to Microsoft Project to automate reporting of project performance data. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!

2 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox March 2017