Date:         Tue, 22 Oct 2002 17:55:58 +0100
Reply-To:     John Whittington <John.W@MEDISCIENCE.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Whittington <John.W@MEDISCIENCE.CO.UK>
Subject:      Re: Using VB to call SAS
Comments: To: David Rubanowice <rubanowice.d@GHC.ORG>
In-Reply-To:  <E1841JM-0001ma-00@coumxnn02.netbenefit.co.uk>
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 08:50 22/10/02 -0700, David Rubanowice wrote:

>If you want the spawned SAS process to finish before returning control to
>VB then Shell won't work (it's asynchronous in nature).

So I discovered, early on in my relationship with VB <g>

>You can use  Integrated Technologies if you want/have license/have
>patience, or you can use some Win32 calls like this.  Yes, I know it looks
>pretty complex, but it works great. ....

Many thanks for that - as you say, it seems an incredibly complex solution
to what, on the face of it, seems to me a very simple and modest (and, I
suspect, common) 'wish'!

My usual 'workaround' is to have the spawned program/process create a 'flag
file' as the very last thing it does, and have VB repeatedly look for that
until it finds it (and then deletes it).

Kind Regards


John

----------------------------------------------------------------
Dr John Whittington,       Voice:    +44 (0) 1296 730225
Mediscience Services       Fax:      +44 (0) 1296 738893
Twyford Manor, Twyford,    E-mail:   John.W@mediscience.co.uk
Buckingham  MK18 4EL, UK             mediscience@compuserve.com
----------------------------------------------------------------