I can't figure out how to use an In Memory table. In DBISAM it was
easy just drop a TDBISAMTable on your DataModule set DatabaseName to
Memory and create the tabledefs and indexdefs in the DM OnCreate
event. After that you could use the memory table in SQL. How do you do
this in EDB? I put a TEDBTable on the DM set DatabaseName to Memory
and used the same session as everything else. Created the Memory
Database, table fields and indexes using SQL in DM OnCreate using
Session1.Execute. When I try to run it I get a 403 Database is
read-only error when trying to create the table. Sometimes I also get
an 400 error the database Memory already exists.

Michael,

<< I can't figure out how to use an In Memory table. In DBISAM it was easy
just drop a TDBISAMTable on your DataModule set DatabaseName to Memory and
create the tabledefs and indexdefs in the DM OnCreate event. After that you
could use the memory table in SQL. How do you do this in EDB? I put a
TEDBTable on the DM set DatabaseName to Memory and used the same session as
everything else. Created the Memory Database, table fields and indexes using
SQL in DM OnCreate using Session1.Execute. When I try to run it I get a 403
Database is read-only error when trying to create the table. Sometimes I
also get an 400 error the database Memory already exists. >>

If you post your code, I can help you straighten it out.  It sounds like:

1) You're not ensuring that the current database is correct (403 error is
usually from trying to create a table in the Configuration database).

2) You're not verifying that the Memory database exists or not prior to
executing the CREATE DATABASE (400 error).

--
Tim Young
Elevate Software
www.elevatesoft.com