SQLite: how to open existing database in memory

[Peter Haworth]

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 <gbojsza at gmail.com> 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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>