ProFox

profox@leafe.com

2704 discussions

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

Re: Modless form out of top-level form
by Fernando D. Bozzo 03 Mar '17

03 Mar '17

If you define the inner form as to show "in a top level form", if you configure it with desktop=.T. I think that you can do it El 3/3/2017 11:44, "Man-wai Chang" <changmw(a)gmail.com> escribió: Given a g_form as top-level form in READ EVENTS, could a new modeless form be popped out of the top-level form, possibly without _SCREEN.visible? Do I need to play with MDI forms? g_form=Createobject("myform") DO case CASE Type("g_form")="O" Set Sysmenu To _Msm_edit g_form.Show() Read Events .... ENDCASE -- .~. 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! [excessive quoting removed by server]

1 0

Modless form out of top-level form
by Man-wai Chang 03 Mar '17

03 Mar '17

Given a g_form as top-level form in READ EVENTS, could a new modeless form be popped out of the top-level form, possibly without _SCREEN.visible? Do I need to play with MDI forms? g_form=Createobject("myform") DO case CASE Type("g_form")="O" Set Sysmenu To _Msm_edit g_form.Show() Read Events .... ENDCASE -- .~. 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!

1 0

Hard-Coded Scalar Value Substituted at Run Time
by Ken Dibble 02 Mar '17

02 Mar '17

I swear, my code is haunted. I have some code in a subclass of my custom-built list control class. I provide enough code here to indicate the context, but I don't think I need to explain its purpose to illustrate what has just happened: FOR m.x = 1 TO ALEN(THISFORM.oMail.aSortList,1) ** 2/28/17: ** ** On this date, a user had an "Array dimensions are invalid" ** error at this point in the code. However, the trace gave the ** offending line of code as follows: ** ** thekey = THISFORM.oMail.aSortList(m.x,10) ** ** The parent code doesn't contain any lines like that, at all. ** The array has 5 hard-coded columns, not 10. It has always ** had 5 columns since I wrote this code many years ago. ** There is NO WAY that the hard-coded scalar value of 5 ** in this code could be changed to 10. That is really, really, ** REALLY weird. ** This is the actual code: * Find the corresponding row in the temporary storage array. thekey = THISFORM.oMail.aSortList(m.x,5) ** See? Not 10. It's 5. findrow = ASCAN(THISFORM.aTmpSort,thekey,-1,-1,5,15) IF findrow > 0 * We found it. Copy the temporary storage array row back to the * listcontrol's RowSource. FOR m.y = 1 TO ALEN(THISFORM.aTmpSort,2) THIS.aItemList(therow,m.y) = ; THISFORM.aTmpSort(findrow,m.y) ENDFOR * We use this to control which aItemList row to populate because * I'm not sure the two arrays will have an equal number of rows * in all cases. (They SHOULD because the RemoveAddress() method * truncates both the RowSource and last-name-sorted arrays, but * just in case...) therow = therow + 1 ELSE * The row absolutely should be there. RETURN .F. ENDIF ENDFOR Now, this particular user uses this feature and executes this code quite frequently. But today, somehow, at run time, a hard-coded scalar value of 5 was replaced with 10. This crashed the program, which emailed me as a result, so I have the trace. I can't reproduce it. So it does not appear that the last compile messed something up. Instead, something magically changed that number this ONE TIME while the code was executing. Is this really the proverbial cosmic ray flipping a bit? Has anyone ever seen anything like this? If not, why do these things only happen to me? Thanks for any thoughts. Ken Dibble www.stic-cil.org

6 9

Re: Hard-Coded Scalar Value Substituted at Run Time
by Ken Dibble 02 Mar '17

02 Mar '17

> > FOR m.x = 1 TO ALEN(THISFORM.oMail.aSortList,1) > > thekey = THISFORM.oMail.aSortList(m.x,10) && "array dimensions > > invalid" > > > >Is this m.x declared local to the procedure, or is it possibly shared >with other m.x's in different scopes? It's declared local in this procedure, and all of the other m.x loop counters in the affected objects are also local. Thanks, Ken

1 0

Re: Hard-Coded Scalar Value Substituted at Run Time
by Ken Dibble 02 Mar '17

02 Mar '17

>Never seen something like this, but if you are distributing an exe, then >you should md5 it so you can detect any change comparing with a saved md5. > >This way I've found viruses that changed parts of the code and antiviruses >have cleaned them up, but leaving the exes in a different state than the >original, sometimes even unrunnable. That's a really good idea. As it turns out, I'm embarrassed to say, the line of code reported in the trace does exist, in a virtually identical list control subclass on the same form (one overlays the other exactly). I wasn't paying attention to the name of the control in which the error occurred. There are actually 10 columns in the array in this method. So what actually happened is that somehow, between: FOR m.x = 1 TO ALEN(THISFORM.oMail.aSortList,1) and thekey = THISFORM.oMail.aSortList(m.x,10) somehow the length of the array got truncated. Now, there is NO other code between those two lines, so ALEN(THISFORM.oMail.aSortList,1) would have had to return an impossible result for the next line to fail. I have seen this on a few occasions when iterating arrays, but I remain mystified as to how it could happen. Ken

2 2

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox