Re: memory databases fail in Windows

Enjoy! If you make it better post updates. Eventually we can put it into the library we all share. I use it for querying for the min top and left, and the max bottom and right of all visible objects on a card. But it can be used In a lot of ways. You could store data in an array in a stack

Re: memory databases fail in Windows

Yes please! ###I hear ya'. I find myself tempted way more than I have time for to write an xquery-like library for working with arrays. We could sure use one.### On Tue, Apr 3, 2018 at 2:12 PM, Richard Gaskin via use-livecode < use-livecode@lists.runrev.com> wrote: > Bob Sneidar wrote: > >

Re: memory databases fail in Windows

Bob Sneidar wrote: >> On Apr 3, 2018, at 11:38 , Richard Gaskin wrote: >> >> What is the goal? >> >> Arrays and memory-based SQLite are both in-memory stores with hashed >> access. I'm guessing there's something more to this use-case than my >> limited thinking currently grasps. > > You would

Re: memory databases fail in Windows

You would be correct. :-) I posted a little while ago that I wrote some code to gather certain properties of all the objects on a card into an array. Converting that array into a memory database allows me to find all the objects that are for example, visible and groups and then get the top,

Re: memory databases fail in Windows

Bob Sneidar wrote: Hi all. I have a function that works in Mac but not in Windows. Here is the relevant code: function arrayToMemoryDB aArrayData put the keys of aArrayData into tArrayKeys sort tArrayKeys numeric ascending put ":MEMORY:" into tDBFile try put

Re: memory databases fail in Windows

Ah! Curoius it works with Mac. I'll give that a try. Bob S > On Apr 3, 2018, at 11:12 , Mike Bonner via use-livecode > wrote: > > try changing :MEMORY: to :memory: > > On Tue, Apr 3, 2018 at 11:38 AM, Bob Sneidar via use-livecode < >

Re: memory databases fail in Windows

try changing :MEMORY: to :memory: On Tue, Apr 3, 2018 at 11:38 AM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi all. I have a function that works in Mac but not in Windows. Here is > the relevant code: > > function arrayToMemoryDB aArrayData >put the keys of

memory databases fail in Windows

Hi all. I have a function that works in Mac but not in Windows. Here is the relevant code: function arrayToMemoryDB aArrayData put the keys of aArrayData into tArrayKeys sort tArrayKeys numeric ascending put ":MEMORY:" into tDBFile try put revOpenDatabase("sqlite", tDBFile)