You created a database but you didn't create any tables in it. You'll need to issue a CREATE TABLE command after opening the db.
On Sat, Oct 17, 2015, 7:22 AM Glen Bojsza <[email protected]> wrote: > 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 > _______________________________________________ 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
