Here is a example.
Check the printout..
Hope this helps..
NullColumn$ = ""
sqliteconnect #sql, ":memory:"
mem$ = "CREATE TABLE member ( memberNum INT(10), _
memberType CHAR(2), billShipSw CHAR(1), firstName VARCHAR(22), _
middleName VARCHAR(22), lastName VARCHAR(22), addr1 VARCHAR(22), _
addr2 VARCHAR(22), city VARCHAR(22), state CHAR(3), _
zip VARCHAR(10), country VARCHAR(4), phone VARCHAR(17), _
eMail VARCHAR(40), rqstNews CHAR , rqstPromo CHAR , _
rqstNew CHAR , lastVistiDate DATETIME, lastOrderDate DATETIME, _
totOrderAmt FLOAT, numOrders SMALLINT, ip VARCHAR(16), _
username VARCHAR(16), password VARCHAR(16), _
passwordHint VARCHAR(50) )"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('1', 'D', 'B', 'Bobby', 'Back', 'Breaker', 'I have no address', _
NULL, 'Anderson', 'CA', '96001', 'USA', '111-222-3333', _
NULL, 'N', 'N', 'N', '2008-12-02', '2008-12-13', '0.0', '0', _
NULL, 'admin', 'admin', 'What is Kashogi')"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('3', 'G', 'B', 'George', 'G', 'Gasher', 'Sea Shell', _
NULL, 'Portland', 'OR', '97105', 'USA', NULL, NULL, 'N', 'N', 'N', _
NULL, NULL, '0.0', '0', NULL, 'demo', 'demo', NULL)"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('1', 'D', 'S', 'Bobby', 'Back', 'Breaker', 'Ship Addr1', 'Ship Addr2', _
'Ship City', 'CA', '96001', 'USA', '111-222-3333', _
NULL, 'N', 'N', 'N', '2008-12-02', '2008-12-13', '0.0', '0', _
NULL, 'admin', 'admin', 'What is Kashogi')"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('3', 'G', 'S', 'George', 'G', 'Gasher', 'Ship Addr1', 'Ship Addr2', _
'Ship City', 'OR', '97105', 'USA', NULL, NULL, 'N', 'N', 'N', NULL, _
NULL, '0.0', '0', NULL, 'demo', 'demo', NULL)"
#sql execute(mem$)
sql$ = "SELECT * FROM member"
#sql execute(sql$)
WHILE #sql hasanswer()
#row = #sql #nextrow()
memberNum$ = #row memberNum$()
memberNum = #row memberNum()
memberType$ = #row memberType$()
billShipSw$ = #row billShipSw$()
firstName$ = #row firstName$()
middleName$ = #row middleName$()
lastName$ = #row lastName$()
addr1$ = #row addr1$()
addr2$ = #row addr2$()
city$ = #row city$()
state$ = #row state$()
zip$ = #row zip$()
country$ = #row country$()
phone$ = #row phone$()
eMail$ = #row eMail$()
rqstNews$ = #row rqstNews$()
rqstPromo$ = #row rqstPromo$()
rqstNew$ = #row rqstNew$()
lastVistiDate$ = #row lastVistiDate$()
lastOrderDate$ = #row lastOrderDate$()
totOrderAmt$ = #row totOrderAmt$()
totOrderAmt = #row totOrderAmt()
numOrders$ = #row numOrders$()
numOrders = #row numOrders()
ip$ = #row ip$()
username$ = #row username$()
password$ = #row password$()
passwordHint$ = #row passwordHint$()
html memberNum;" ";totOrderAmt;"<BR>"
wend
wait