Tmyquery - SetOrderBy

[kenny]

Hi,

The SetOrderBy in TMyQuery will overwrite the statement after ORDER BY Clause? eg:

SELECT name FROM cust ORDER BY name &MyLIMIT

&MyLimit is the macro for the query...

Thanks

[Ikar]

You are right, SetOrderBy method doesn't process macroses. To solve the problem you should extract LIMIT keyword from macros to SQL.

SELECT name FROM cust ORDER BY name LIMIT &MyLIMITValue