FairCom DB SQL previously did not support an ORDER BY clause in a subquery. This support has been added. Note however, subqueries with a combination of TOP, GROUP BY and outer references remain unsupported.
FairCom DB SQL now also supports an ORDER BY clause in a FOR UPDATE query.
Note: This is a non-standard SQL feature as specified by SQL92. Additionally, full cursor update is not supported by FairCom DB SQL.