Tim

Its going to be a while before I get back to ElevateDB since I'm busy TMSing an app but this one interests me. Will it, in C/S mode be possible to create a temporary table on the client machine? In memory?

Roy Lambert

Roy,

<< Its going to be a while before I get back to ElevateDB since I'm busy
TMSing an app but this one interests me. Will it, in C/S mode be possible to
create a temporary table on the client machine? In memory? >>

No, all temporary tables are created as non-in-memory temporary tables, and
they are created on the server machine for all C/S sessions.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:E56CA7DC-E48D-4DCB-94BB-59499A63F61C@news.elevatesoft.com:

> No, all temporary tables are created as non-in-memory temporary
> tables, and they are created on the server machine for all C/S
> sessions.

(Just to refresh my memory - I'm not active yet with EDB either as I'm
refactoring my new DBISAM application after some user input)

Can a workaround be found by opening a second, local session on an in-
memory database and doing SQL across the two databases, or something like
that?
--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3)

Chris,

<< Can a workaround be found by opening a second, local session on an
in-memory database and doing SQL across the two databases, or something like
that? >>

Unfortunately, no.  You can't perform SQL across session boundaries, so
you'd have to move the data from the table on the ElevateDB Server down to
the local table first, and then you could execute SQL statements against it.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:DB56A980-D252-4689-9CFE-6AF4DCF4E881@news.elevatesoft.com:

> You can't perform SQL across session boundaries,
> so you'd have to move the data from the table on the ElevateDB Server
> down to the local table first, and then you could execute SQL
> statements against it.

Thanks.

Looks like a good one for using stored procedures to extract a minimum
dataset for this kind of thing...

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3)

Chris,

<< Looks like a good one for using stored procedures to extract a minimum
dataset for this kind of thing... >>

Yes, stored procedures are ideal for distilling some complex batch work down
to a single result set.

--
Tim Young
Elevate Software
www.elevatesoft.com