memory databases fail in Windows

[Bob Sneidar]

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