On 26 May 2001, at 14:14, Mark Howard wrote:
> 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!
Weirdness. What email program are you using?
> > 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?
I don't know a lot about Paradox, unfortunately. But perhaps it's
implemented such that the nested select is completely evaluated
rather than just taking a single row to decide the exists/not-exists.
That could slow it down quite a bit. I'd say if it's something you
only have to do once a year, let it run overnight and see what
happens. You could also try putting in a distinct and see if that
helped:
delete from dockets d1 where not exists (select distinct forcode from
dockets d2 where d1.forcode = d2.forcode and
d1.comp = d2.comp and d2.docketdate > '31/03/2001')
Cheers,
Seth.
=======================================================
Seth Wagoner, WebFoundry Ltd. Christchurch, New Zealand
mailto:[EMAIL PROTECTED] http://webfoundry.co.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"
