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
|
Lighspeed version: nightly build of 06/08 4.0.1512.21094. T1 and T2 are entities with Soft Delete = true
It generates: SELECT t0.Id AS [t0.Id] FROM T1 t0 CROSS JOIN T2 t1 AND t1.DeletedOn IS NULL ... but with a CROSS JOIN the AND is not supported, giving the exception: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'AND'. Any idea how to resolve? PS: I'm very new to LS |
|
|
Thanks for reporting this Peter, this is a bug and a fix will be available for you in the next nightly build to correct this.
|
|
|
Many thanks! |
|