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, in one project we have to deal with a legacy database, which has column names that include spaces and other special chars. The tables have been imported from the db into lightspeed, but the resulting sql is not correct because the column names that include white spaces and special chars are not escaped. Can you correct this behavior? Regards, Dennis |
|
|
|
|
Set LightSpeedContext.QuoteIdentifiers = true (in code or config). Note that in some databases (e.g. PostgreSQL, and I think Oracle) this also makes table names case-sensitive, so you may need to fiddle around with the Table Name option to force LightSpeed to use specific casing. |
|
|
|
