I must be blind today, why would this query work in access/sql7, but not
from a TADOQuery (erros with syntax error):
UPDATE
ctabdat
SET
Source = 'dailyptf',
Object = 'SP1',
Attribute = 'HeatFlow',
Type = 1,
Unit = 'kcal/s',
Calculation = 'None'
WHERE
CrossID = 10 AND
Object = 'SP1' AND
Attribute = 'HeatFlow'
And I missing something obvious?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz