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

Reply via email to