Well thanks to all of you urging me to stay away from re-processing the array
but going back to the dbase.
I Looked back at my code and realized that I *had* set it up to be re-usable, I
just forgot how well I had done that
I have this function in the behavior_Listen which is attached to the stack
local sPlayListQueryA
command playlist_FetchData
# this handler gets everything we need from the dbase and assumes the column
values for the query
# are set in the sPlayListQueryA
-----
duh! I had written everything I needed already!
I only needws to add this
on playList_FetchData pQueryArray
if pQueryArray is not empty then # we are passing a query from the search
behavior
put pQueryArray into sPlaylistQueryA
end if
and away we go, exact code to instantiate the entire play list of all audio
items for that class is now reused to just fetch what the user wants.
Awesome… this all I needed in my search behavior was to set up the query
(values for column look ups)
put tGenre into tFilterListQueryA["genre"]
put tTheme into tFilterListQueryA["theme"]
put tStringToFind into tFilterListQueryA["title"]
put tStringToFind into tFilterListQueryA["subtitle"]
put tStringToFind into tFilterListQueryA["description"]
put tStringToFind into tFilterListQueryA["artists"]
revealMoreActions "false" # hide the form and fetch a new list from the
dbase
playList_fetchData tFilterListQueryA
all the discussion on speed seems mute in this context as the data sets are
small an it happens in "the flash of an eye"
Thanks gentlemen, you saved me from going off the deep end re-parsing the local
array!
BR
On 8/23/17, 2:47 PM, "use-livecode on behalf of Mike Bonner via use-livecode"
<[email protected] on behalf of
[email protected]> wrote:
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
memory db?
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...
http://sqlite.org/lang_createtable.html
_______________________________________________
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
