Re: Calling procedures

[Tom Hippensteel <THippensteel@SPECTRUMHEALTH.COM>]

Yes there is.  You can use the START command instead of command.com to start
the DOS procedure.  Unlike command.com called using CALL SYSTEM USING, the
START command used with CALL SYSTEM USING actually waits until the DOS
program is complete before control is continued through the SQR program.  I
use it myself.  It's Great!
Example:

let $COMMAND = 'START /m /w xcopy32 /q /y '||$in_path||'\'||$filename1||'
'|| in_path||'\OLD'
CALL SYSTEM USING $COMMAND #status wait

Here I am using START instead of command.com to begin the xcopy32 of the
"$filename" input file in the "$in_path" directory the "OLD" directory under
the "$in_path" directory.  Hope this helps.

Tom Hippensteel
Applications Specialist
thippensteel@spectrumhealth.com
314-919-9807


> -----Original Message-----
> From: Ben Lawrence [SMTP:ben_lawrence69@HOTMAIL.COM]
> Sent: Wednesday, February 10, 1999 4:57 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Calling procedures
>
> Hi all, I left a major problem out of my first email.  One of the
> procedures is executing a .bat file through DOS.  The procedure after
> this, gets called and ran before the .bat file is done running.  Is
> there a way to prevent this from happening?
>
>
> >From owner-sqr-users@list.iex.net Wed Feb 10 13:51:12 1999
> >Received: from list.iex.net (list.iex.net [192.156.196.15]) by
> list.iex.net (8.8.5/8.8.5) with SMTP id OAA22788; Wed, 10 Feb 1999
> 14:50:30 -0700 (MST)
> >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release
> 1.8b) with
> >          spool id 229397 for SQR-USERS@LIST.IEX.NET; Wed, 10 Feb 1999
> 14:49:38
> >          -0700
> >Received: from mx02.netaddress.usa.net (mx02.netaddress.usa.net
> >          [204.68.24.139]) by list.iex.net (8.8.5/8.8.5) with SMTP id
> OAA22658
> >          for <sqr-users@list.iex.net>; Wed, 10 Feb 1999 14:49:30 -0700
> (MST)
> >Received: (qmail 15711 invoked by uid 0); 10 Feb 1999 21:49:28 -0000
> >Received: from bhmail.brishosp.chime.org [170.163.40.153] by mx02 via
> mtad
> >          (2.6) with ESMTP id 908DBJVxA0140M02; Wed, 10 Feb 1999
> 21:49:27 GMT
> >Received: by bhmail.brishosp.chime.org with Internet Mail Service
> (5.5.2448.0)
> >          id <DWP8DDN2>; Wed, 10 Feb 1999 16:48:40 -0500
> >MIME-Version: 1.0
> >X-Mailer: Internet Mail Service (5.5.2448.0)
> >Content-Type: text/plain; charset="iso-8859-1"
> >Message-ID:
> <D1BDF0F0B625D11196DD00805F857E3B1E6B6E@bhmail.brishosp.chime.org>
> >Date:         Wed, 10 Feb 1999 16:48:39 -0500
> >Reply-To: SQR-USERS@USA.NET
> >Sender: "Discussion of SQR,
> >              SQRIBE Technologies's database reporting language"
> >              <SQR-USERS@list.iex.net>
> >From: "Ranade, Sameer" <sranade@BRISHOSP.CHIME.ORG>
> >Subject:      Re: Calling procedures
> >X-To:         "SQR-USERS@USA.NET" <SQR-USERS@USA.NET>
> >To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> >
> >Hi Ben,
> >
> >        I think SQR waits till the called procedure is complete. As
> with any
> >other procedural programming language, order of procedures decides the
> flow
> >of the program. In fact we can't call multiple procedures at the same
> time.
> >(Since this type of functionality requires multi-threading, which I
> think
> >SQR doesn't support. Please correct me if I'm wrong.)
> >        Did u experience another procedure getting called while first
> one
> >was being executed ?
> >
> >HTH,
> >-Sameer
> >
> >-----Original Message-----
> >From: Ben Lawrence [mailto:ben_lawrence69@HOTMAIL.COM]
> >Sent: Wednesday, February 10, 1999 4:18 PM
> >To: Multiple recipients of list SQR-USERS
> >Subject: Calling procedures
> >
> >
> >I have a question regarding when procedures get ran.  My statement
> looks
> >like this:
> >begin-program
> >do Drop_Views
> >do Create_Views
> >do Export_Import
> >do Run-Report
> >end-program
> >
> >How can I make sure that each procedure is not called until the
> >procedure before it has finished.  Right now SQR does not seem to be
> >waiting to call the next procedure.  Any help would be great.  Thanks
> in
> >advance.
> >
> >Ben
> >
> >______________________________________________________
> >Get Your Private, Free Email at http://www.hotmail.com
> >
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com