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.comdevaraj.patil@commscope.com Posts: 3Questions: 2Answers: 0

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?

Answers

  • colincolin Posts: 15,118Questions: 1Answers: 2,583

    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

This discussion has been closed.