Search Values of Array in "One Go"
bonnmike at gmail.com
Wed Aug 23 20:47:37 EDT 2017
I think you need to use ":memory:" as the name actually. It looks (from
the sqlite docs) that supplying no name creates a temporary db file.
And now i'm curious.. Is there a way to attach the file based db to a
IE Open the file database, then use the info here:
https://www.sqlite.org/lang_attach.html and attach a memory database.
Then (way over my head, but I seem to recall reading somewhere..) that one
can use the results of a select to create a temporary table.. If
interested, you might look here under create table as select...
On Wed, Aug 23, 2017 at 6:31 PM, Sannyasin Brahmanathaswami via
use-livecode <use-livecode at lists.runrev.com> wrote:
> Yep… I just found that too.
> and related 4-yr old discussion
> What I don't get is
> "don't give it a name" open/create in memory,
> but the data is on SQLite dbase on disk, so you *have* to read it one way
> or another.
> (scratch his head…)
> On 8/23/17, 2:13 PM, "use-livecode on behalf of Alex Tweedly via
> use-livecode" <use-livecode-bounces at lists.runrev.com on behalf of
> use-livecode at lists.runrev.com> wrote:
> On 24/08/2017 01:04, Sannyasin Brahmanathaswami via use-livecode wrote:
> >2) "create an in-memory SQLite Database."
> > this is news! Where do we find docs on this? right now the SQLite
> data base is in
> > specialFolderPath("documents")/jnanam.sqlite
> >how do you "create in memory?
> According to an old message (i.e. I've not tried it :-):
> On Fri, Jun 15, 2012 at 5:21 PM, Bob Sneidar <bobs at twft.com <
> http://lists.runrev.com/mailman/listinfo/use-livecode>> wrote:
> //>//>/On Jun 15, 2012, at 4:13 PM, Mike Bonner wrote: />//>/ > Don't
> specify a database name and it will open the db in memory. />/ > />/ > get
> revopendatabase("sqlite",,,,,,) --not sure how many commas off the />/top
> />/ > of my head. />/ > />/ > On Fri, Jun 15, 2012 at 5:08 PM, Bob Sneidar
> <bobs at twft.com
> <http://lists.runrev.com/mailman/listinfo/use-livecode>> wrote: />/ >
> />/ >> I am just certain that I read on this forum that you could create an
> />/ >> sqLite database in memory! But when looking through the dictionary
> and />/in />/ >> the LiveCode lessons there seems to be no mention of how!
> Can someone />/point />/ >> me to the right docs for this? />/ >> />/ >>
> Bob />/ >> />/ >> /
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode