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, I am having the opposite error that the one in http://www.mindscapehq.com/forums/thread/638600 I have a Contains() statement in a lightspeed query which is translated as: ... LIKE '%mystuff%' ESCAPE '\' ... But Postgres 9.3 (nor does 9.1) does not accept this, it expects '\'. The issue is solved by using dataProvider="PostgreSql8", but that brings other issues, I need to use dataProvider="PostgreSql9" instead. How can I solve this issue? Thanks Oscar |
|
|
|
|
Hi Oscar, I have added in an option to allow you to revert the behavior of this to be the same as Postgres8 and this will be available in the next nightly build for you. You can change the behavior by setting the value of Mindscape.LightSpeed.Data.PostgreSql9DataProviderOptions.UseBackslashEscaping to true.
|
|
|
|
