Seth said
>
> I will only let you use this answer if you put your system clock
> back to today. :-)  Furthermore, I don't guarantee it's correct, but
> I think it accomplishes what you want to achieve:
My system clock IS correct: my files are being stamped with the correct time
and date.
The problem is with my email only.  If I send one to myself: the time and
date in Sent Items is correct but the time and date in the Inbox shows 19
hours earlier.  Also everyone elses' mail coming in is similarly stamped as
coming in 19 hours earlier.  Very strange.  If someone has a fix - I'll stop
stuffing up the order in your Inboxes!
>
> delete from dockets d1 where not exists
> (select forcode from dockets d2 where d1.forcode = d2.forcode and
> d1.comp = d2.comp and d2.docketdate > '31/03/2001')
>
Well, Seth, you must be a pretty good teacher - this is what I had.  But
after an hour it was still running so I canned it.  Maybe it just needed
more time.  It there any way of monitoring progress? - or do you just have
to have faith?
The dockets table has about 17,000 rows.

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"

Reply via email to