Devart Forums

{UniDac 6.1.5}

Hi,

I've got a query like this to run on a SQL Server: If the QueryRecCount property is not activated, the query is run successfully.

But, when the property is activated, TUniQuery complains about a bad syntax near '(' when asking for the record count.
Indeed, the generated query is: It seems _SetOrderBy procedure in CRParser unit doesn't support "calculated" order by.
A way to get my query run is to enclose each order by "calculated" field with parenthesis.

It would be convenient that this workaround is not mandatory.

Hello,

Specially for "complex" queries we have added possibility to set user SQL query for defining the number of records. For this, in design time you can set a "correct" query on the Update SQLs tab in the UniQuery editor, in runtime - in the UniQuery1.SQLRecCount property.

Thank's for the answer

I didn't know the property (because I create all my queries dynamically, I don't use design time editors)

Regards

If you have any other questions, feel free to contact us.