On Thu, 25 May 2000, Matthew Comb wrote:
> had similar problem to this when using an ADO interface through an ASP page.
> In the end I had to insert the date value as a string
As an additional check I just tried running this:
ADOConnection1.Execute(
'INSERT INTO dailytwr ( Object, Pressure ) VALUES ( ''Cooling Tower'', 47 )');
And that also failed with syntax error. I also just tried using
TADOCommand but that also failed with the same error.
.....
AHA - I just changed my Datasource to use JET 3.51 instead of JET 4.0
which I was, and the INSERT worked! Finally something I can check and
look into more :-)
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
