Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
SELECT INTO MEMORY |
Mon, Sep 14 2009 8:15 PM | Permanent Link |
Charalampos Michael | Hello,
I have the following databases: 1) MyDB 2) MyMemoryDB Now, is there an easy way with EDB to sent the result from MyDB to MyMemoryDB ? eg, SELECT MyField FROM MyDB INTO MEMORY MyMemoryDB In dbisam was much easier. Thank you -- Charalampos Michael - [Creation Power] - http://www.creationpower.gr |
Mon, Sep 14 2009 11:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Now, is there an easy way with EDB to sent the result from MyDB to MyMemoryDB ? eg, SELECT MyField FROM MyDB INTO MEMORY MyMemoryDB >> Yes, using MyMemoryDB as the current database for the TEDBQuery, execute this SQL: CREATE TABLE MyTable AS SELECT MyField FROM MyDB.MyTable -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 15 2009 3:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>CREATE TABLE MyTable AS SELECT MyField FROM MyDB.MyTable Shouldn't there be a WITH DATA in there? Roy Lambert [Team Elevate] |
Tue, Sep 15 2009 12:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Shouldn't there be a WITH DATA in there? >> Sorry, yes. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |