I think we have a disconnect... I want to open an existing database but in memory.
You are saying that I opened a new database in memory but need to create tables in it. So I guess the question is better put: Can you open an existing base in memory if so how? If you can't open an existing database in memory then if you create a new one in memory can you copy the tables from an existing one into the database that is in memory? On Sat, Oct 17, 2015 at 10:36 AM, Peter Haworth <[email protected]> wrote: > 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 > _______________________________________________ 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
