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;
con.Open();
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;
cmd.ExecuteNonQuery();
con.Close();
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 \