Re: Start reports

[Lena Pihel <Lena.Pihel@METEORIT.SE>]

Thanks, it helped!!!

> -----Original Message-----
> From: Nathan Treadway [SMTP:nathant@ONTKO.COM]
> Sent:  den 11 februari 1998 16:29
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Start reports
>
> > Is there a way to start more than one report from the dos-prompt?
> > I have tried to make a .bat-file:
> > @echo off
> > sqrwt  report1.sqt  user/pass@dbname -keep  input1 input2 input3
> > sqrwt  report2.sqt  user/pass@dbname -keep  input1 input2 input3
> input4
> > sqrwt  report3.sqt  user/pass@dbname -keep  input1 input2 input3
> >
> > But only the first .spf and .lis-fil is created.
>
> What version of dos/windows are you using?
>
> 16-bit versions of SQR can only run one copy at a time.  When you run
> this
> ..bat file, DOS executes the second SQRWT immediately after the first
> one
> starts; it does not wait until the first command completes before
> running
> the next one.  (This is because Windows is "multitasking".) Since the
> first
> copy of sqrwt is still running, then second (and third) commands can't
> actually start SQRWT again, and therefore the SQR programs don't
> execute.
>
> If you are running Windows 95, you can use the "start /wait" command
> to cause the .bat file to wait for each SQRWT command to exit before
> running
> the next one.  (Just put "start /wait " in front of "sqrwt" on each
> line.)
>
> I am not certain, but I don't believe "start" is available in earlier
> versions of DOS.  I'm not sure of a good solution in this case; you
> may have
> to use "pause" commands to force the .bat file to wait until each
> report is
> finished running.  I don't think of any way to avoid having a person
> babysit the computer while the .bat file is running.
>
>                                                 Nathan
>
> ----------------------------------------------------------------------
> ------
> Nathan Treadway    | Ray Ontko & Co. | Software consulting services
> nathant@ontko.com  | Richmond, IN    | http://www.ontko.com/