11
What's New / Re: ScriptBasic Core Windows 32 bit - SQLite
« Last post by Support on May 25, 2021, 03:29:58 PM »This is an example of using the SQLite extension module.
C:\sb_build\examples>sbc sqlite_demo.sb
123 - hello
234 - cruel
345 - world
C:\sb_build\examples>
Code: Script BASIC
- IMPORT sqlite.sbi
- db = sqlite::open("sqlite_demo.db")
- sqlite::execute(db,"create table demo (someval integer, sometxt text);")
- sqlite::execute(db,"insert into demo values (123,'hello');")
- sqlite::execute(db, "INSERT INTO demo VALUES (234, 'cruel');")
- sqlite::execute(db, "INSERT INTO demo VALUES (345, 'world');")
- stmt = sqlite::query(db,"SELECT * FROM demo")
- WHILE sqlite::row(stmt) = sqlite::SQLITE3_ROW
- IF sqlite::fetchhash(stmt, column) THEN
- PRINT column{"someval"},"\t-\t",column{"sometxt"},"\n"
- END IF
- WEND
- sqlite::close(db)
C:\sb_build\examples>sbc sqlite_demo.sb
123 - hello
234 - cruel
345 - world
C:\sb_build\examples>