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"

Reply via email to