sqlite has column name is starting number and editor fails to update table
sqlite has column name is starting number and editor fails to update table
devaraj.patil@commscope.com
Posts: 3Questions: 2Answers: 0
in Editor
Link to test case: Table has column name starting with number. ex: 3GMS
Debugger code (debug.datatables.net): using { data: "3GMSCCLLI" },
Error messages shown: SQLSTATE[HY000]: General error: 1 unrecognized token: ":"
Description of problem: column name has numbers. how should i handle this for updates?
This discussion has been closed.
Answers
This SO thread might help, it's saying double-quotes are needed. It might be worth renaming that column if possible, as it does seem to cause issues.
Colin