Is that possible to use a combination of Ultralite functions to have a column in the data set with the current row number, like the SQLServer ROW_NUMBER() function does?
FWIW, SQL Anywhere itself also supports the ROW_NUMBER() OLAP function (and offers way more features w.r.t. to OLAP windows/partitions compared to MS SQL AFAIK. However, I do not know whether OLAP support is available with UltraLite, too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.