SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: mikedoty on October 17, 2008, 03:52:02 AM

Title: Commands requiring slSel are SELECT, EXPLAIN, PRAGMA, others?
Post by: mikedoty on October 17, 2008, 03:52:02 AM
Suggestions welcome?  ???
Listview demo modified to accept:
EXPLAIN SELECT * FROM PARTS  (default uses the sample.db3 database)


s = UCASE$(LTRIM$(RTRIM$(s)))
IF LEFT$(s$,7) = "SELECT " OR LEFT$(s$, 8) = "EXPLAIN " OR LEFT$(s$,7) = "PRAGMA " THEN
   result = slSel(s,0,"E0")
   ShowError slGetError
   if result = 0 then DisplayRecordSet
ELSE
   result = slEXE(s,"E0")
   ShowError slGetError
END IF