oops
multiple lines worked never sick
try 3.8.11 (compiled with sqlite 3.8.11) http://projects.gstools.de/public/gstsqlite/releases

You need
Code:
GSTsqlite_ExecuteSQL(var hDB, STRING* sSQL);

Code:
hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("DELETE TABLE 'tipos';")); // execute a sql-statement
  hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("CREATE TABLE 'tipos' ( 'index' INTEGER PRIMARY KEY AUTOINCREMENT, 'nombre' VARCHAR(32) UNIQUE, 'cantidad' INTEGER );")); // execute a sql-statement
  hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("INSERT INTO 'tipos' ( 'nombre', 'cantidad' ) VALUES ( 'Tipo 001', 1 );")); // execute a sql-statement
  hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("INSERT INTO 'tipos' ( 'nombre', 'cantidad' ) VALUES ( 'Tipo 002', 2 );")); // execute a sql-statement
  hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("INSERT INTO 'tipos' ( 'nombre', 'cantidad' ) VALUES ( 'Tipo 003', 3 );")); // execute a sql-statement
  hndQuery = GSTsqlite_ExecuteSQL(GSTsqlite_hndDB, _str("INSERT INTO 'tipos' ( 'nombre', 'cantidad' ) VALUES ( 'Tipo 004', 4 );")); // execute a sql-statement


ExecuteQuery is suppoesed to query the database for results > single statement.

no other query should be open to execute properly.

Andreas
GSTools - Home of
GSTScript 0.9.8: lua scripting for A6/7/8
GSTNet 0.7.9.20: network plugin for A6/7/8
GSTsqlite 1.3.7: sql database plugin for A6/7/8
3DGS Codebase: 57 snippets || 3DGS Downloads: 248 files