SQLite Forum

ALTER TABLE ADD COLUMN problem
Login
Unfortunately, it seems that according to the docs for my language (Xojo), the error from the prepare is not reported unless one attempts the SELECT. And I just verified that this is the case. So I may as well just do the SELECT directly.

That might be good enough for the moment, but perhaps the PTB will consider adding IF NOT EXISTS.