BrightSign Object Reference Manual (FW 5.1) - Manual (Page 159)

151
sqlResult = insertStmt.Run()
print sqlResult
if sqlResult = SQLITE_COMPLETE
print "Table Insertion OK"
else
print "Table Insertion FAILED"
endif
insertStmt.Finalise()
Example: Inserting into a Table Using BindByOffset()
insertStmt = db.CreateStatement("INSERT INTO playback (md5,path,playback_count)
VALUES(?,?,?);")
print insertStmt
if type(insertStmt) <> "roSqliteStatement" then
print "We didn't get a statement returned!!"
end
endif
params = CreateObject("roArray", 3, false)
params[ 0 ] = "ABDEF12345"