If has worked well for many years but since changing from RealSQLdatabase to SQLiteDatabase this fails but only when an old database was created as a RealSQLdatabase.
The field simply doesn’t get created.
Has anyone else had this occur.
[quote=448807:@Craig Grech]Occasionally I need to add a new field to an existing users database. I’ve been using this after checking the field doesn’t exist:
If has worked well for many years but since changing from RealSQLdatabase to SQLiteDatabase this fails but only when an old database was created as a RealSQLdatabase.
The field simply doesn’t get created.
Has anyone else had this occur.[/quote]
You shuldnt mix an old database format with the newer SQLite and expect good results. If you are going to upgrade the database engine, you should create a new database and transfer the data.
I use to use RealSQLDatabase and then later move to SQLiteDatabase and i don\t need to create new database and transfer from the old db to the new one.
Craig, do u try running the SQL statement directly on the database using a SQLite db browser like SQLiteManager???