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

Reply via email to