On Sep 28, 2010, at 2:01 PM, Trevor DeVore wrote:

on preopenCard
   put specialfolderpath("temporary") into theFolder
   put theFolder & "/" & the milliseconds & ".db" into theFile
   put revOpenDatabase("sqlite",theFile,,,,) into theConn
   put revDataFromQuery(tab, cr, theConn, "SELECT sqlite_version()")
into theData
   revCloseDatabase theConn
   put "Installed SQLite version:" && theData into fld 1
   delete file theFile
end preopenCard

Actually, you don't even need the temporary file. Just use an in- memory db.

on preopenCard
  put revOpenDatabase("sqlite",,,,,) into theConn
put revDataFromQuery(tab, cr, theConn, "SELECT sqlite_version()") into theData
  revCloseDatabase theConn
  put "Installed SQLite version:" && theData into fld 1
end preopenCard

--
Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: 
http://revolution.bluemangolearning.com

Email has been scanned for viruses by Altman Technologies' email management 
service - www.altman.co.uk/emailsystems
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to