Re: Checking program progress

[Steve Hall <srh@CONVOY.COM>]

Another way is to have the sqr write an 'end-time' into a database row.
You then poll and wait until the end-time row is not null.
But it is still a mess.
Another way is to use PERL to track the process ID of the sqr. This is best
of all because these executable can finish up while the cursors continue to
grind away.
The SQR will also 'race ahead' and write to file, tricking you into thinking
it is finished.
-S




-----Original Message-----
From: Discussion of SQR, SQRIBE Technologies's database reporting
language [mailto:SQR-USERS@list.iex.net]On Behalf Of Tim Green
Sent: Wednesday, November 25, 1998 10:13 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Checking program progress


> Thanks Wayne, the WAIT parameter can be used with the CALL SYSTEM USING
> command as I do, but it only waits until the called program begins
running.
> Anyone have any other ideas?

The WAIT parameter that I've seen others mention on the list before is the
/WAIT
option of the Win95/NT START command.  Execute your call system command
using
"start /wait <program>" and your SQR program should suspend execution until
the
called program completes.  I say should because I don't run SQR in Windows
and
so haven't tried it myself.

Good luck,
Tim Green                                           Tim_Green@mercer.com
Administrative Solutions Group
An ADP/Mercer Alliance