Error Messages/43104

Example error messages

42000: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

42000: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORM Asset'.

Causes

This error is issued by the database's SQL driver when DbQuery or DbWrite is evaluated. It indicates bad SQL syntax, e.g misspelling the SELECT command, as in

"SELEC * FROM Asset"

or misspelling the FROM keyword:

"SELECT * FORM Asset"

Remedy

Fix the SQL.

See Also

• Querying Access database from Analytica 64
• DbQuery/Step-by-Step querying Microsoft Access
• DbQuery
• DbWrite
• Database functions
• Database access