SQLite command

I’m converting a C# program over to Xojo for cross-platform compatibility but I seem to have run into a road block. I’m using a SQLite backend and I can’t seem to find the equivilent of the SQLIteCommand piece. Here is what it looks like in c#:

SQLiteConnection con = new SQLiteConnection();

DataSet ds = new DataSet();
SQLiteCommand cmd = new SQLiteCommand();

string mysql1 = “”;

con.ConnectionString = Globals.db;

cmd.Connection = con;
mysql1 = “INSERT INTO myTable (field1,field2,field3) VALUES (@field1,@field2,@field3)”;

cmd.CommandText = mysql1;
cmd.Parameters.Add("@field1", System.Data.DbType.String).Value = textbox1.Text;
cmd.Parameters.Add("@field2", System.Data.DbType.String).Value = textbox2.Text;
cmd.Parameters.Add("@field3", System.Data.DbType.String).Value = textbox3.Text;



The reason I want to do it this way rather than just populate the “INSERT INTO” with the actual field values is so that I can populate the table with any type of data (text, blob, etc.) and I don’t have to escape things like ’ and \

Start here: