dbexecute insert (Documentation Bugs and Problems)
I totally missed one other statement that you need to execute BEFORE you can use SQL statements and that is the DBOPEN statement. You need to tell SQLite where the data will actually be stored.
dbexecute "create table dicktest1 (id integer, nummer text, value decimal);"
for n = 1 to 3
stmt$ = "insert into dicktest1 (id, nummer, value) values (" + n + ", '" + n + "', " + n + ");"
dbopenset "select * from dicktest1 order by nummer;"
print dbint(0) + dbstring(1) + dbfloat(2)
When you run the code you will see a file (where you saved the program) called "testdatabase.db" that actually contains the database tables and rows.