SQLite Forum

New Column not saving data
Login
> this table I'm adding a column to has 379 columns

This statement, all by itself, tells me that your database needs redesigning.  But I'll ignore that.

Please download the SQLite command-line tool and try your UPDATE statement in it.  This will remove the Omnis datatype confusion from your debugging efforts.  You can use SELECT commands in the same tool to see whether your UPDATE command worked.

If the command-line tool fails to work we can help you because it is written by the SQLite team.  If it works, your problem is with Omnis and you need help from Omnis people, not us.