Expression confused about alias

rbuser

Using Delphi 7, RB 11.04 Enterprise and SQL Server 2005. In our end user
application if a calculated field is created with an expression like this:

CAST(FLOOR(CAST(EVENT_DATE AS FLOAT)) AS DATETIME)

the SQL generated appears to be treating the AS DATETIME as an attempt to
put an alias into the expression field and so it removes it, which of course
leaves invalid SQL. Is there anyway around this?

nardmoseley

There is now a patch available for RB 11.04 to fix this issue. I emailed you
the patch. Registered users of RB 11.04 can email
support@digital-metaphors.com to request the patch.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks for that Nard, the patch has fixed the problem nicely.

Paul