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, We are selecting an entity and eager loading child entities and using paging on the query object. At the same time we are sorting on a child entity field name. When this is done Lightspeed incorrectly uses the wrong table name in the SQL when selecting the child entites. SQL throws the error "Msg 4104, Level 16, State 1, Line 84 Attached is a sample solution and db, if paging is turned off then the issue no longer occurs. Thanks |
|
|
Hi bdog, Thanks for the concise repro sample for this. We have reproduced the issue here and will be working on a solution for this, unfortunately this is not a trivial issue so I will keep you posted on progress. In the meantime you could use a stored procedure to handle this as a workaround until we get this resolved.
Jeremy |
|
|
An update on this, This issue has been fixed in the latest nightly build (20100327). Let us know if you have any further problems with this.
Jeremy |
|