Even using a direct path to the
sqlite.bas fails to load.
' IMPORT sqlite.bas
INCLUDE "/home/pi/sbrpi/include/sqlite.bas"
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)
pi@raspberrypi:~/sbrpi/examples $ scriba -d sqlite_demo.sb
Including file '/home/pi/sbrpi/include/sqlite.bas'
(0): error &H10:The requested module can not be loaded.
pi@raspberrypi:~/sbrpi/examples $
This works.
pi@raspberrypi:~/sbrpi/examples $ scriba -f/etc/scriba/basic.conf.system sqlite_demo.sb
123 - hello
234 - cruel
345 - world
pi@raspberrypi:~/sbrpi/examples $