Mark,
Could it be that you are missing a pair of double quotes? As in:
D."TimeStamp"
Dennis.
> Hi, for somereason I now get an error in one my TUpdateSQL components, the
> modify sql code I have is:
>
> UPDATE ImportData D
> SET
> D.Val = :Val
> WHERE
> D."Point" = :Point AND
> D.TimeStamp = :TimeStamp
>
> And I'm getting an "invalid use of keyword TimeStamp" error, anyone know
> what I should be doing? or looking for?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz