Delphi IDE (89)
Windows with Delphi (280)
About this site
Links to us
Decrementing a datetime field in Paradox
This article has not been rated yet. After reading, feel free to leave comments and rate it.
There is a bug in Local SQL on Paradox:
Executing an Update statement on a Paradox table where '1' is being
subtracted in a datetime field does not subtract '1', but rather adds '1'.
// this will ADD one!
UPDATE SAMPLE.DB SET DT = DT - 1
// the following workaround will give the correct result:
UPDATE SAMPLE.DB SET DT = DT + (-1)