BrightSign Object Reference Manual (FW 5.1) User Manual
Page 158
150
•
GetData() As Object: Returns an associative array of name/value pairs that are available after a SELECT (or
similar) operation.
•
Finalise(): Finalizes the statement. This method should be applied to statements before the parent database is
closed. The object should not be used after this method is called. Also note that objects are automatically finalized
when they are deleted.
Example: Inserting into a Table Using
BindByName()
insertStmt = db.CreateStatement("INSERT INTO playback (md5,path,playback_count)
VALUES(:md5_param,:path_param,:pc_param);")
print insertStmt
if type(insertStmt) <> "roSqliteStatement" then
print "We didn't get a statement returned!!"
end
endif
params = { md5_param: "ABDEF12346", path_param: "/foo/bar/bing/bong", pc_param: 11 }
bindResult = insertStmt.BindByName(params)
if bindResult
print "BindByName OK"
else
print "BindByName FAILED"
end
endif