Posting to delphi@ seeing as database@ still seems to be dead, what would
cause a query that works in access, not to work from delphi.
This particular query in question is a simple INSERT query, which from
delphi gets an invalid syntax error, I'm running it via:
ADOConnection.Execute(sSQL);
And the query is:
INSERT INTO
dailytwr ( Object, MeasDate, Pressure )
VALUES
( 'Cooling Tower', #07/02/1999#, 473978.321759270330000 )
Earlier I had to solve a problem with dates in sql/access by turning off
the ParamCheck property, kept interpreting #00:00:00 03/01/1999# as being
made up of parameters, is there something similiar happening here?
This is just getting fustrating :P
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: The Flower Kings - Big Puzzle
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
