Sorry, I could not find this using the search feature:

How do I use SelfServicing to do the following:

SELECT TOP 1 * FROM table ORDER BY id DESC

Thanks

PS - is there any way to see the SQL string that was run by a query?

benles wrote:

Sorry, I could not find this using the search feature:

How do I use SelfServicing to do the following:

SELECT TOP 1 * FROM table ORDER BY id DESC

Thanks

PS - is there any way to see the SQL string that was run by a query?

Use OrderCollection.GetMulti(null, 1, sorter)

You can see the queries generated if you use 1.0.2004.2, and switch on tracing on teh DQEs. See Troubleshooting and debugging in the 1.0.2004.2 documentation