Alter Table Question For Adding New Column To SQLite Database

Databases
1

Hi,

I have a Xojo database app that I am about to release as a Beta, but I want to be able to add columns to the SQLite Table without altering the existing data stored in the table. This will allow Beta users to use the app even while I add new columns with new updates to the Beta.

This is the code I was using, but it does not seem to do anything. It does not add the new column.
The SQLite database name is : Roster
The Table is called Settings.
The new column would be: SetVersion and it is a text field.

[code] Roster= new RealSQLDatabase
Roster.DatabaseFile = GetFolderItem(“Roster.sqlite”)

Roster.SQLExecute (“ALTER TABLE Settings ADD COLUMN SetVersion text”)[/code]

What am I doing wrong? Any help would be greatly appreciated.

Jim

2

did you commit the change?

3

Oops! I should have seen that. My mistake. Thanks Rich for your help. That worked great. I appreciate it.

4

https://forum.xojo.com/16566-check-and-if-required-add-column-to-existing-database