BorlandTalk.com

Anders LEE · Guest

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.

Bill Todd (TeamB) · Guest

Local SQL (the dialect used by Paradox and dBase tables) is a subset
of SQL 92. For details of what is supported see the Local SQL help
file in your BDE directory.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)