Hi,

I apologize upfront for this probably stupid question, but since I am not
sure and unable to test it in my current situation, I just have to ask. Even
when using DBISAM I never used the in memory option, so this is a first.

CREATE DATABASE "Test"
PATH 'T:\Test'

CREATE DATABASE "Test"
IN MEMORY

In a C/S setup the first statement would point to the server. No problem
here. Still in a C/S setup, if I use the second statement, where will the
database be created? On the server (in memory ofcourse) or on the client?

Since I need it to be on the client, what will I need to do if the above
statement creates it on the server?

Thanks in advance.

Best regards,
Fons

Fons


Your assumption about it being created on the server is correct.

What you need to do is create a separate session have it set to local and create your in-memory database using that. You won't be able to SELECT directly from the c/s stuff into the local stuff. If you need to do that you'll have to create the table on the server first and then stream it across.

Roy Lambert [Team Elevate]

Thanks Roy.

> Your assumption about it being created on the server is correct.

I figured as much, but needed to be sure.

> What you need to do is create a separate session have it set to local and
> create your in-memory database using that. You won't be able to SELECT
> directly from the c/s stuff into the local stuff. If you need to do that
> you'll have to create the table on the server first and then stream it
> across.

That won't be a problem. Well, there might be a small issue - if needed, I
will get back on that one.

Best regards,
Fons