32 lines
1.0 KiB
Plaintext
32 lines
1.0 KiB
Plaintext
# open database file
|
|
dbopen "players.sqlite3"
|
|
|
|
# delete old players table - trap error if new database
|
|
onerror errortrap
|
|
# delete old database if it exists
|
|
dbexecute "DROP TABLE IF EXISTS players;"
|
|
|
|
# create database table with sample data
|
|
# include the IF NOT EXISTS clause to avoid an error if the table already exists.
|
|
dbexecute "CREATE TABLE IF NOT EXISTS players (name TEXT NOT NULL, score INTEGER, active BIT, jerseyNum INTEGER);"
|
|
dbexecute "INSERT INTO players VALUES ('Jones, Bob',0,'N',99)"
|
|
dbexecute "INSERT INTO players VALUES ('Jesten, Jim',0,'N',100)"
|
|
dbexecute "INSERT INTO players VALUES ('Jello, Frank',0,'N',101)"
|
|
|
|
dbexecute "UPDATE players SET name = 'Smith, Steve', score = 42, active = 'TRUE' WHERE jerseyNum = 99;"
|
|
|
|
dbopenset "SELECT * FROM players;"
|
|
while dbrow()
|
|
print "['" + dbstring(0) + ", '" + dbstring(1) + ", '" + dbstring(2) + "', " + dbstring(3) + "]"
|
|
end while
|
|
dbcloseset
|
|
|
|
offerror
|
|
# wrap everything up
|
|
dbclose
|
|
end
|
|
|
|
errortrap:
|
|
# accept error - display nothing - return to next statement
|
|
return
|