Brightsign Object Reference Manual (FW 5.1) User Manual download pdf (Page 158)

100

101

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

1 2 ... 153 154 155 156 157 158 159 160 161 162 163 ... 340 341

Comments to this Manuals

No comments

Brightsign Object Reference Manual (FW 5.1) User Manual Page 158

Comments to this Manuals

Related products and manuals for Software Brightsign Object Reference Manual (FW 5.1)