Seth
Have figured out that I can do this in two bits anyway, by updating an
already existing and related table first, to capture the current
forcode/comp combinations from "dockets" and then using this table to
control the delete from "dockets".
I might try running it overnight just for interest.
Appreciate your help.
Mark
----- Original Message -----
From: "Seth Wagoner" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Saturday, May 26, 2001 7:40 PM
Subject: Re: [DUG]: Another SQL poser
> 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"
---------------------------------------------------------------------------
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"