memory databases fail in Windows

Mike Bonner bonnmike at gmail.com
Tue Apr 3 14:12:31 EDT 2018


try changing :MEMORY: to :memory:

On Tue, Apr 3, 2018 at 11:38 AM, Bob Sneidar via use-livecode <
use-livecode at 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 aArrayData into tArrayKeys
>    sort tArrayKeys numeric ascending
>    put ":MEMORY:" into tDBFile
>
>    try
>       put revOpenDatabase("sqlite", tDBFile) into tDBID
>
>       put "drop table arraydata" into tDropSQL
>       revExecuteSQL tDBID, tDropSQL
>       put  the result into tResult
>    catch tError
>       answer tError
>       if the environment is "development" then exit to top else quit
>    end try
> <snip>
>
> revOpenDatabase returns an error. Any idea why? It's a memory database!
> How can it NOT work??
>
> Bob S
>
>
> _______________________________________________
> 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
>



More information about the use-livecode mailing list