Insert for SQLDatabaseMBS silently fails

Extras
1

After doing some minor refactoring for a class using SQLDatabaseMBS both insert table as well as insert into silently fail.

I’m using an fts4 table to search a Valentina database:

CREATE VIRTUAL TABLE bodyindex USING fts4(tokenize=unicode61,content=‘’, messagebody);

After refactoring this results in a file with 0 bytes. When I try to add data to the table with

INSERT INTO bodyindex(docid, messagebody) VALUES(” + str(theRecID) + “, ?)”)

the database still has 0 bytes. Only a delete gives an error message “table doesn’t exist”. The same code has worked for over 10 years and continues to work in my second app. I extracted the code for an example and there the code works fine:

sqlite.xojo_binary_project.zip (11.6 KB)

How do I find out why both insert table and insert into do nothing?

I forgot: Xojo 2024r1, MBS from 14.07.2025, Tahoe and Big Sur

2

Sounds strange.
Can you compare all the changes and see what you changed since it worked?

Also can you ask the plugin to raise exceptions for all errors:

SQLiteIndexDBMBS.RaiseExceptions = True

Just to avoid a function running the old style and only set Error = true.

3

I love strange bugs. I added that line and now everything works again.