No ABS() with BDE SQL?


2004-05-10 03:36:11 PM
delphi97
I think the abs() function is defined in SQL-99 standard?
while BDE SQL is based on SQL-92??
So I am out of luck??
Can't think of an work around, doing it in 3 steps, first select all
the entries out & save to temp file (MakePermanent)
Then do an update AbsField with -AbsField where absField<0
Lastly select from that table to my report.
Fortunately, the table is small, so the speed is still acceptable.
Any suggestion for work around ??
P.S. I think of using SQRT( X * X ) , but unfortunately it is not
supported neither.