Hi there,
Looks like the firehose broke in 10.21.9. When I now execute a SQL statement with a TOP clause like this:
SELECT TOP 5 * from EcomOrders
where OrderComplete = 1
ORDER BY OrderAutoId desc
I get this:
A TOP can not be used in the same query or sub-query as a OFFSET.
It works fine without the TOP clause.
Imar
