Well, either the mail poll at @delphi.org.nz is really slow today or the
list is $&*(&$*(#*#.
Anyway, got my access date problem sorted, only, now that the query runs, I
almost wish it didn't :)
The following query executes quick fast under SQL7 and BDE/Paradox, but in
againt Access (either in Access or via TADOQuery) my app locks, at least in
Access I could cancel the operation, from my logfile I see the generated SQL
is:
# 24/05/2000 15:56:38 dmmisc.pas:150: SQLExec:
# 24/05/2000 15:56:38 UPDATE
# 24/05/2000 15:56:38 ImportData
# 24/05/2000 15:56:38 SET
# 24/05/2000 15:56:38 FilterResult = 4
# 24/05/2000 15:56:38 WHERE
# 24/05/2000 15:56:38 DateTimeAdded >= #18:00:00 07/03/1999# AND
# 24/05/2000 15:56:38 DateTimeAdded < #15:56:38 05/24/2000# AND
# 24/05/2000 15:56:38 Point IN (
# 24/05/2000 15:56:38 SELECT DISTINCT
# 24/05/2000 15:56:38 Point
# 24/05/2000 15:56:38 FROM
# 24/05/2000 15:56:38 ImportData
# 24/05/2000 15:56:38 WHERE
# 24/05/2000 15:56:38 Point NOT IN (
# 24/05/2000 15:56:38 SELECT DISTINCT
# 24/05/2000 15:56:38 Point
# 24/05/2000 15:56:38 FROM
# 24/05/2000 15:56:38 PointAttributes P, Configuration C
# 24/05/2000 15:56:38 WHERE
# 24/05/2000 15:56:38 P.ConfigurationID = C.ConfigurationID AND
# 24/05/2000 15:56:38 C.ConfigurationID = 19990703
# 24/05/2000 15:56:38 ) AND
# 24/05/2000 15:56:38 DateTimeAdded >= #18:00:00 07/03/1999# AND
# 24/05/2000 15:56:38 DateTimeAdded < #15:56:38 05/24/2000#
# 24/05/2000 15:56:38 )
Does Access not like complex things like this?
--
Mark Derricutt "People in prayer for me, everyone there for me,
ICQ: 1934853 sometimes I feel I should face this alone, my
Wrk: 377-9941 soul exposed... it calm's me to know that I
Fax: 377-9947 won't!" = Dream Theater - Scarred
DDI: 375-3754
Now Playing: <no audio cd present>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
