I am trying to open an existing SQLite database in memory.
When I do this (or think I do this) I get a database connection ID but the
it errors out when I try just to show the current data?
On OS X Mavericks LC 8 DP4
*on* mouseUp
*put* "/Users/Dev/Documents/Ratings.db3:memory:" into tDatabasePath
*put* revOpenDatabase("sqlite", tDatabasePath, , , , ) into tDatabaseID
*put* "Connection = " & tDatabaseID -- if I get an integer then a
database connection has been made
*put "SELECT * from Movies" into tSQL*
*put* revDataFromQuery(tab,*return*,tDatabaseID,tSQL) into myresults
*put* myresults
revCloseDataBase tDatabaseID
*end* mouseUp
My output:
Connection = 1 (shows I have a database connection)
revdberr,Database Error: no such table: Movies
Any suggestions?
thanks,
Glen
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
