• Welcome, Guest. Please login.
 
September 17, 2019, 10:43:44 am

News:

Welcome to the SQLitening support forums!


Commands requiring slSel are SELECT, EXPLAIN, PRAGMA, others?

Started by mikedoty, October 17, 2008, 03:52:02 am

Previous topic - Next topic

mikedoty

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