Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 5 of 5 total |
Use of MEMORY table with Client Server Database |
Wed, May 17 2006 10:37 AM | Permanent Link |
adam | 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 |
Wed, May 17 2006 4:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 18 2006 7:24 AM | Permanent Link |
adam | I am still on 3.30 ... & am planning to upgrade around 5.05 ( ... to allow a bit of time
for things to settle!). Adam |
Thu, May 18 2006 4:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 18 2006 7:12 PM | Permanent Link |
adam | Thank you Tim.
|
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |