I just looked at the Axe.sqlite module, and am finding that it is very thin on documentation.
I was able to succesfully create a table and insert two rows by using this:
rr=SQL_Exec(db,"CREATE TABLE user (username char(50),password char(50))")
'err=SQL_Exec(db,"INSERT INTO 'user' (username,password) VALUES ('bob', 'password')")
'err=SQL_Exec(db,"INSERT INTO 'user' (username,password) values ('joe', 'secret')")
However, when I try to query the database with the following:
or even:
all I get is "Attempt to call uninitialized function pointer" in the output window.
I'm sure this is something very basic, but I have no idea what I'm missing here. Any insight?
I was able to succesfully create a table and insert two rows by using this:
rr=SQL_Exec(db,"CREATE TABLE user (username char(50),password char(50))")
'err=SQL_Exec(db,"INSERT INTO 'user' (username,password) VALUES ('bob', 'password')")
'err=SQL_Exec(db,"INSERT INTO 'user' (username,password) values ('joe', 'secret')")
However, when I try to query the database with the following:
err=SQL_Exec(db,"select * from user ")
or even:
err=SQL_Exec(db,"select password from 'user' where username='bob'")
all I get is "Attempt to call uninitialized function pointer" in the output window.
I'm sure this is something very basic, but I have no idea what I'm missing here. Any insight?