I am in the process of moving over to SQLCommandMBS from SQLDatabaseMBS in which I am trying to find examples where SQLDatabaseMBS uses SQLPreparedStatementMBS.
does SQLCommandMBS integerate with SQLPreparedStatementMBS? If so, does anyone have sample code I can look at?
[code]Dim cmd As New SQLCommandMBS(con, “Insert into test_tbl(fid, fvarchar20) values(:a, :b)”)
// use first method of binding - param assignment
cmd.Param(“a”).setAsLong(2)
cmd.Param(“b”).setAsString(“Some string (2)”)
// Insert first row
cmd.Execute[/code]
thank you for taking the time to provide sample code. With regards to your example projects, you have so many and might have missed the example project that contained guidance.