Question, in Paradox I made use of the following query:
INSERT INTO CalculatedDates
SELECT DISTINCT
CAST(DateTimeAdded AS DATE) AS GoodDate
FROM
ImportData
WHERE
FilterResult NOT IN (2,4) AND DateTimeAdded IS NOT NULL AND Val IS NOT
NULL
Which simply filled the CalculatedDates table with a unique list of "days"
that existed in ImportData matching the specified criteria. Now, SQL7
doesn't actually -have- a DATE datatype, only DATETIME so this query fails.
I was just looking at the DATEPART() function but that only seems to return
indivudal elements likes day, month, year etc. etc. and not the actual date
portion.
Does anyone know of any tricky but simple ways to do this with query against
SQL7? In an attempt to keep every generic SQL I may end up parsing the
ImportData table in code and then inserting the records (although not as
nice, it would keep it non-db specific).
Thoughts?
Mark
--
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
