SYMPTOM:
When a FreeForm SQL report uses database reserved keywords in SQL, an error occurs in the SQL Engine. For instance, when 'Order' is used as a table name in an Access database, the following error occurs when executing a report:
Error: SQL Generation Complete QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Syntax error in FROM clause. Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial, Job 1038, Error Code= -2147212544.
ACTION:
Do not use database reserved key words in Strategy Free Form SQL reports as a table name.
Reserved words are database dependent, and a list of these words can be found in each database's documentation. Consult a database administrator for more information on these reserved words.
