> Hi Mark,
>
> I guess a rights problem would be on the suspect list.
> Can you ask the administrator to lock down the server during the day for a
test
> and run your query in something like SQL Explorer? This may at least give
you an
> error message.
>
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/