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

146
Example: Creating a Database
db = CreateObject("roSqliteDatabase")
print db
openResult = db.Create("SD:/test.db")
if openResult
print "Created OK"
else
print "Creation FAILED"
end
endif
Example: Creating a Table in a Database
createStmt = db.CreateStatement("CREATE TABLE playback (md5 text PRIMARY KEY, path PATH,
playback_count INT);")
print createStmt
if type(createStmt) <> "roSqliteStatement" then
print "We didn't get a statement returned!!"
end
endif
sqlResult = createStmt.Run()