Hi Lou, In .NET it's (relatively) easy use a sub thread.
There are many ways to do this, but I suggest you look into the BackGroundWorker class: http://msdn.microsoft.com/en-us/library/system.componentmodel.backgroundworker.aspx Paul On Wed, Dec 28, 2011 at 2:14 PM, Lou Syracuse <[email protected]> wrote: > I have the same issue with a .NET program, so it is not limited to VFP. It > calls a StoredProc in SQLServer that takes an hour to run. > > I was thinking about creating a 'job' table.. get the ID and pass it along > with the parameters to the Stored Proc from a second EXE (called from the > first with its visible property set to false). The 2nd exe calls the SP then > updates a completed field in the job table... meanwhile the original program > is sitting in a form with a timer that checks that flag every 60 seconds or > so and when it is set does a query to pick up and delete the data from a > 'results' table based on that job id. > > Clear as mud? It seems like overkill for a process that we only run once a > day though. Parameters need to be entered so it can't be automated. Would > have been better (and much easier to debug) doing the work in .NET, but the > IT Manager (non-programmer) said to do it in an SP so it can utilize his > new/expensive/fast server. Someday when I have time I'm going to code it in > .NET to see if there is really that big of a speed difference. I think I have > some time opening up in November 2014... > > Lou > > > > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Kent Belan > Sent: Tuesday, December 27, 2011 4:31 PM > To: [email protected] > Subject: Not Responding > > Hello, > > Hope everyone had a great Christmas !! > > I have several reports that take a while to run. > > I have notices that Windows 7 will report that the program is "Not > Responding" on these long reports. > > If the user clicks on the application, Windows will then show a message > about program not responding and ask the use the exit or cancel. > > Is there anyway to tell Windows that the program is still running before the > "Not Responding" mode kicks in ? > > Thanks and Happy New Year, > Kent > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CADwx0++TaBqErcJ5mLLdwcmwUhCia9gBacG=bonk45pbpxh...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
