I am currently using sql server, when I use RetrieveCriteria to retrieve object and set the RowLimit property to 3 and Offset property to 1, AtomsFramework generate such sql statement and throw an exception :
"SELECT TOP 1, 3 Article.OIDValue, Article.CreatedDate, Article.ModifiedDate, Article.PublishedDate, Article.Title, Article.Click, Article.AtomsCategoryOIDValue FROM Article"
Did I do anything wrong?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Richard
I am currently using sql server, when I use RetrieveCriteria to retrieve object and set the RowLimit property to 3 and Offset property to 1, AtomsFramework generate such sql statement and throw an exception :
"SELECT TOP 1, 3 Article.OIDValue, Article.CreatedDate, Article.ModifiedDate, Article.PublishedDate, Article.Title, Article.Click, Article.AtomsCategoryOIDValue FROM Article"
Did I do anything wrong?
Probably not...
It's more than likely my code that generates the SQL when using offsets. I'll check it and get back to you.
- Richard.
Ok : )
Ok : )
Thanks!
Grr, SQL Server doesn't support selection offsets (ie you can't skip the first n rows of a result).
I'm trying to work around it at the moment. I'll see what I can do.
- Richard
I see.
Looking forward to your new version : )