Escaping keyword column names
Posted: Thu 07 Jun 2012 15:57
Hi,
When evaluating dotConnect for Salesforce and working with a customer's real database I hit some problems with a column bearing suspicious name 'for'.
When explicitly querying against this column (select, inserts or updates) I am getting a syntax error. Escaping the columns name by adding using square brackets ([for]) is not helping as well - getting message that columns [for] does not exists.
Is there a work around this?
When evaluating dotConnect for Salesforce and working with a customer's real database I hit some problems with a column bearing suspicious name 'for'.
When explicitly querying against this column (select, inserts or updates) I am getting a syntax error. Escaping the columns name by adding using square brackets ([for]) is not helping as well - getting message that columns [for] does not exists.
Is there a work around this?