I just had a go at databases and used the examples in the documentation, e.g.
Creating a SQLite Database
The following code creates a SQLite database and uses SQLExecute to create a table.
[quote]Dim dbFile As New FolderItem(“MyDB.sqlite”)
Dim db As REALSQLDatabase
db = New REALSQLdatabase
db.DatabaseFile = dbFile
If db.CreateDatabaseFile Then
Dim sql As String
sql = “CREATE TABLE Team (ID INTEGER NOT NULL, Name TEXT, Coach TEXT, City TEXT, PRIMARY KEY(ID));”
MsgBox("Database error: " + db.ErrorMessage)
Except unless you add a db.commit only an empty database file is created that is flagged as corrupted in other SQL editors.
Am I wrong in thinking there should be a db.commit added to the example?
Same is true for the RecordSet documentation.