This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, Given a Vendor entity with 1-many association with a PurchaseOrder entity the following code results in error "Invalid column name 'RowNumber'.Invalid column name 'RowNumber'", but works when paging is removed. Query query = new Query();
The code above generates below SQL with the ROW_NUMBER() statement missing:
exec sp_executesql N'SELECT
Cheers, |
|
|
Hi Werner, Yes, it would appear the paging is being dropped incorrectly in this case. Would you be able to send through a copy of your model (either by attaching to to the issue, or emailing it through to us at support at mindscape.co.nz) - that will allow us to reproduce the query locally.
Thanks! Jeremy |
|
|
Model attached.
Cheers, Werner |
|
|
Thanks Werner, This was a bug which impacted providers where the paging code is handled via wrapping the original query (SQL Server + Oracle) to achieve the result. I have added in a fix for this and it will be in the next nightly build.
Jeremy |
|