Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
CREATE [TEMPORARY] TABLE |
Mon, Jun 25 2007 12:01 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Jun 25 2007 3:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jul 4 2007 4:05 PM | Permanent Link |
Chris Erdal | "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) |
Wed, Jul 4 2007 4:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Jul 5 2007 4:59 AM | Permanent Link |
Chris Erdal | "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) |
Thu, Jul 5 2007 10:15 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |