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

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

Tim

>CREATE TABLE MyTable AS SELECT MyField FROM MyDB.MyTable

Shouldn't there be a WITH DATA in there?

Roy Lambert [Team Elevate]

Roy,

<< Shouldn't there be a WITH DATA in there? >>

Sorry, yes.

--
Tim Young
Elevate Software
www.elevatesoft.com