"The INSERT INTO statement contains the following unknown field name:"

After applying the "Insert Record" server behavior, attempts to insert a new record into a database fail and the following error appears:

"The INSERT INTO statement contains the following unknown field name:"

This error typically results from one or more of the following problems with the name of a field, object, or variable within a database:

1. Using a "reserved word" as a name. Most databases have a set of "reserved words" which have meaning to the database engine because they may be used to identify built-in functions or keywords. For example, "DATE" is a reserved word and cannot be used for column names in the database.
2. Special characters in the name. Examples of special characters include:. / * : ! # & - ?
3. A space in the column name.
4. A column name starts with a numeric character, such as 2products.
5. The error can also occur when an Input Mask is defined for an object in the database, and the data being inserted does not conform to the mask.SolutionAvoid using reserved words such as "date", "name", "select", "where" and"level" when specifying field names in your database. Also eliminate spaces and special characters.