memory databases fail in Windows

Bob Sneidar bobsneidar at iotecdigital.com
Tue Apr 3 14:15:58 EDT 2018


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 <use-livecode at lists.runrev.com> wrote:
> 
> 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
>> 
> _______________________________________________
> 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