Search Values of Array in "One Go"

[Sannyasin Brahmanathaswami]

Yep… I just found that too.

and related 4-yr old discussion

http://use-livecode.runrev.narkive.com/ntBLeXGM/relative-performance-of-two-dimensional-array-and-in-memory-sqlite-database


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 />/ >> />/ >> /