I asked a similar question to this about accessing columns using a
variable name, and the answer was you cannot. Sadly I cannot find the
email explaining why so I'll ask this similar question:
Can I add a column using a variable for the column name? Below is the
prepare statement, which is returning an error.
sqlite3_prepare(m_dbDataBase, "ALTER TABLE users ADD COLUMN ?
varchar;", -1, &stmt, NULL);
I'm pretty sure my syntax is correct which leads me to believe you
cannot do this. If that's the case is there some sort of work around?
Thanks in advance for any help.
Kevin Piciulo