Escaping keyword column names

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
arkajzerek
Posts: 4
Joined: Thu 07 Jun 2012 15:48

Escaping keyword column names

Post by arkajzerek » 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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Escaping keyword column names

Post by Shalex » Mon 11 Jun 2012 10:45

Please try "for" instead of [for].

Post Reply