Generic Parsing Error

Question

In a 4D application, I have the following lines of code:

Begin SQL
UPDATE Keys
   SET Desc = :$desc,
       KeyStamp = :$key_stamp
 WHERE KeyTitle = :$key_title
End SQL

When trying to run the code, the following error is displayed:

Generic parsing error. Parsing failed in or around the following substring interval - ( 16, 23 ) - ... SET Desc = ...

Does anyone see the problem with the code? Keys is not a keyword or anything, is it?

score 1 · Accepted Answer · answered Mar 07 '13 at 21:38

1

Seems like someone forgot that Desc is a keyword for "descending." The solution is to rename the column and update all references to that column. Otherwise, the column cannot be referenced in SQL.

answered Mar 07 '13 at 21:38

Noctis Skytower

21,433
16
79
117

Generic Parsing Error

1 Answers1