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
|
It looks as if Lightspeed doesn't enclose names in its queries with SQL Server.
In my case with SQL 2005, I had an entity named User and table pluralization off. Queries would fail because it was doing "insert into User ..." instead of "insert into [User]". It looks like it also doesn't with column names either.
Am I missing a configuration option somewhere or is this a bug?
|
|
|
|
|
Set QuoteIdentifiers=true on the LightSpeedContext. |
|
|
|
