Dear Support!

I want to ask about this:

We reached the point in DBISAM/EDB porting where we need to convert Local Report Tables.

When we need sortable Grid with report data (calc, lookup, other fields, etc) - many times we need it - we used a background DBISAMSession/DataBase that points to User's Temp Directory.

We create the tables into this db, and copy all fields (not only fkdata) to locally.
After that we can sort it by SQL (for grid), etc.

EDB databases are stored in config file. Globally!
User's temp directory is different in each client. So I cannot use EDB like DBISAM with simple redirection of the database...

So we need to use Memory DB.

I want to ask that what happens when we moving to Server Mode?
Is Memory DB remaining in the client's memory, or from this point is it meaning server memory separated by clients?

Thanks:
  dd

<< EDB databases are stored in config file. Globally! User's temp directory
is different in each client. So I cannot use EDB like DBISAM with simple
redirection of the database... >>

Are you using the ElevateDB Server, or is this all just used in file-sharing
mode ?  If the latter (file-sharing), then you can set the
TEDBEngine.UseLocalSessionEngineSettings property to True:

http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=d&version=7&comp=TEDBEngine&prop=UseLocalSessionEngineSettings

and then all of the TEDBSession.Local* properties can be used to configure
each session to point to a different configuration file.  Therefore, you can
have a special session that is used to point to a local configuration file
that is used for your temporary database, and still have the main session
that is pointing to the global configuration file.

<< Is Memory DB remaining in the client's memory, or from this point is it
meaning server memory separated by clients? >>

In-Memory databases are stored in the EDB Server's memory.   If you want to
use a local in-memory database, then you need to create it using a local
session instead.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<Are you using the ElevateDB Server, or is this all just used in file-sharing
mode ?  If the latter (file-sharing), then you can set the
TEDBEngine.UseLocalSessionEngineSettings property to True:
http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=d&version=7&comp=TEDBEngine&prop=UseLocalSessionEngineSettings>>

Can I mix these options and connections?
Because we have many connection at once:
1.) The main connection that is pointing to the dbserver, or to shared files.
2.) The aux. server connection that is in our internet server, but not in server (1)
3.) The local temp files are placed in User's temp dir.

Thanks:
  dd

<< Can I mix these options and connections? >>

Sure, it's what the EDB Manager uses to allow for multiple local sessions
pointing at various configuration files, along with remote sessions pointing
to more than one ElevateDB Server.

--
Tim Young
Elevate Software
www.elevatesoft.com