![]() use first method of binding - param assignmentĬmd.Param( 2).setAsString( new SQLStringMBS( "Some string (2)"))Ĭmd.Param( 2). associate a command with connection // connection can also be specified in SACommand constructorĬmd.setCommandText( "Insert into test_tbl(fid, fvarchar20) values(:1, :2)") end ifĬon.Connect(path, "", "",SQLConnectionMBS.kSQLiteClient) 2) View the contents of the query variable and make a screenshot (Step 2.png) 3) View the contents in Binary form and make a screenshot (Step 3. ![]() Path = "test.db" // for Windows and Linux in the current folder the application is inside. Is it in SQLite local database using V4RB plugin Let's analyze the contents of your query string 1) Assign it to the separate variable, put a breakpoint the line and stop on it (Step 1.png). Path = "/tmp/test.db" // put the database in the temporary folder else use internal sqlite library call InternalSQLiteLibraryMBS.UseĬon = new SQLConnectionMBS // connection objectĬmd = new SQLCommandMBS // create command object // where is the library? 'con.Option(con.kOptionLibrarySQLite) = "/usr/lib/libsqlite3.0.dylib" // connect to database dim path as string if TargetMacOS then
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |