17 lines
509 B
Text
17 lines
509 B
Text
include pSQLite.e
|
|
constant sqlcode = """
|
|
CREATE TABLE address (
|
|
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
addrStreet TEXT NOT NULL,
|
|
addrCity TEXT NOT NULL,
|
|
addrState TEXT NOT NULL,
|
|
addrZIP TEXT NOT NULL)"""
|
|
|
|
sqlite3 db = sqlite3_open("address.sqlite")
|
|
integer res = sqlite3_exec(db,sqlcode)
|
|
if res=SQLITE_OK then
|
|
sqlite3_close(db)
|
|
else
|
|
-- can show eg "sqlite3_exec error: 1 [table address already exists]"
|
|
printf(1,"sqlite3_exec error: %d [%s]\n",{res,sqlite_last_exec_err})
|
|
end if
|