OK
Thanks everybody for your suggestions.
Bevan, not sure if the client site was using NAV scheduler - I certainly
was.
I have found that re-writing it as a console app and writing a logfile
rather than sending the log to a memo on the screen has fixed the problem
completely (on my system :-) )
I was pretty pleased with myself until I got Bevan's post - now we have to
see whether this also fixes it on the client site.
My (uninformed) gut feeling is that the process cannot proceed because it is
trying to write information to the screen - but can't because the screen is
locked. As soon as the screen is unlocked then the writing is confirmed and
the process can continue.
Thanks for the help
Mark
----- Original Message -----
From: "Bevan Edwards" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Friday, September 21, 2001 4:31 PM
Subject: Re: [DUG]: Failure of OverNight routine
> Just my 2 cents worth.
> Are you using NAV Scheduler? If so, perhaps it's a problem with that. On
> WinNT and Win2k I have a problem with automated scans that fail to run if
> the computer is locked, but the continue once it is unlocked. Symantec's
> answer to this was to get NAV Scheduler to run the program navwnt.exe with
> command-line parameters to specify which drives to scan.
>
> Have you tried other scheduling tools? Perhaps it is something to do with
> how the application is launched?
>
> Regards,
>
> Bevan
>
> ---
> Bevan Edwards mailto:[EMAIL PROTECTED]
> Achieve Software Limited http://www.achieve.co.nz
> Phone: (64-9) 444-4210 ICQ: 732011
> Fax: (64-9) 444-4201
> Mobile: (64-21) 979-603
>
>
> ----- Original Message -----
> From: "Nello Sestini" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Friday, September 21, 2001 3:35 PM
> Subject: Re: [DUG]: Failure of OverNight routine
>
>
> > Mark
> >
> > I just wrote a trivial D5 app that has a form
> > and writes 5000 lines to a memo control and then
> > closes the main form (terminating).
> >
> > Not sure if this is a good simulation of what your
> > app does - but if i start this and then "lock" my
> > workstation - this app continues to run (writing to
> > the display even though i can't see it) and then
> > exits. It doesn't "hang" until i unlock or anything
> > like that.
> >
> > So - if locking does impede apps that want to interact
> > with the display it seems it impedes their STARTING
> > some way, but doesn't stop them from executing.
> >
> > I don't have norton schedule (unless maybe its in the
> > NAV somewhere) so i can't try that test.
> >
> > -ns
> > ----- Original Message -----
> > From: "Mark Howard" <[EMAIL PROTECTED]>
> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> > Sent: Friday, September 21, 2001 9:36 AM
> > Subject: Re: [DUG]: Failure of OverNight routine
> >
> >
> > > Further to this (below) - I get the same problem if (rather than
Locking
> > the
> > > computer) I just log out.
> > > Mark
> > >
> > > > >
> > > > Don't think I have any tool that I could use to run a SQL script
from
> a
> > > > command line (D5 Pro).
> > > > I can duplicate the problem on my own system.
> > > >
> > > > Put the executable in Norton Scheduler and wait for the designated
> > time -
> > > it
> > > > runs perfectly.
> > > >
> > > > Do the same but "Lock" the computer (the screen is blank apart from
an
> > > > Unlock dialog box).
> > > > When the designated time arrives the screen does a "blip" the disk
> does
> > a
> > > > "blip" and .... nothing.
> > > > When you "Unlock" the computer the utility completes the run. It
> > appears
> > > to
> > > > continue from a point at the start of accessing the database, but
it's
> > > hard
> > > > to say because the only code before that is writing a couple of
lines
> to
> > > the
> > > > Memo - which would happen pretty quick anyway.
> > > >
> > > > I find it hard to believe that "Locking" the computer would prevent
an
> > app
> > > > getting access to the database (locking appears to be a prevention
of
> > > > access through standard input/output). I could believe that the
app
> is
> > > > stalling because it cannot display stuff on the (locked) screen.
> > > >
> > > > Unless I get any posts saying that this should not be a problem,
I'll
> > > start
> > > > rewriting it as a console app.
> > > >
> > > > Any comments?
> > > >
> > > > Mark
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > -
> > > > New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> > > > Website: http://www.delphi.org.nz
> > > > To UnSub, send email to: [EMAIL PROTECTED]
> > > > with body of "unsubscribe delphi"
> > > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > > New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
> > > Website: http://www.delphi.org.nz
> > > To UnSub, send email to: [EMAIL PROTECTED]
> > > with body of "unsubscribe delphi"
> > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
> > >
> >
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
> >
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
