I am running the following SQL on a remote database:

--

SELECT
 C.CustCode,
 SUM(I.TotalValue - I.TotalDisc) as SumValue,
 "LastYear" as Year

INTO "\MEMORY\Temp.dat"

FROM CustData C
LEFT JOIN InvData I ON I.CustCode = C.CustCode

WHERE I.DateMade > Current_Date - 750
AND I.DateMade < Current_Date - 385

GROUP BY CustCode

;

--

I get an error message "The database 'Memory' does not exist on the db Server at 10.0.0.20"

I have tried replacing "\MEMORY\Temp.dat" with various other strings:

"MEMORY\Temp"

"MEMORY\Temp.dat"

"C:\Temp.dat"

all of which generate more or less the same error message.

Any ideas?


Adam

Adam,

<< I get an error message "The database 'Memory' does not exist on the db
Server at 10.0.0.20" >>

It works here with the latest 4.24 release.  What version/build are you
using ?  Does it work with a different database name (not a file system
path, but a logical database name) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

I am still on 3.30 ... & am planning to upgrade around 5.05 ( ... to allow a bit of time
for things to settle!).

Adam

Adam,

<< I am still on 3.30 ... & am planning to upgrade around 5.05 ( ... to
allow a bit of time for things to settle!). >>

Ahh, in that case use this:

SELECT *
INTO MEMORY MyTable
FROM Customer

Note the MEMORY keyword instead of a "Memory" database name.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thank you Tim.