Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 6 of 6 total |
Temporary Tables |
Fri, Jun 9 2006 5:14 PM | Permanent Link |
"B Miller" | How do I create a temporary table on the server without it being in the
regular database directory? Due to possible size issues, I don't want to create memory tables. I know the select * into \memory\temptablename from tableA but is there a select * into \temp\temptablename from tableA I want to be able to share the data in the application like a memory table. Bill |
Fri, Jun 9 2006 6:17 PM | Permanent Link |
"Ralf Mimoun" | B Miller wrote:
> How do I create a temporary table on the server without it being in > the regular database directory? You can't. A server db is more or less a directory. .... > I want to be able to share the data in the application like a memory > table. You can use a GUID without the {} or something similar as table name. Should do the trick, mayxbe 5 lines of code. Ralf |
Sat, Jun 10 2006 3:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I thought you could as long as you knew the full path. It might make it a bit difficult to allow others to share it since you'll need to share the unc path with all the clients. Also you'll have to make sure the temporary directory is already created.
What's wrong with it being in the database directory? Roy Lambert |
Mon, Jun 12 2006 10:53 AM | Permanent Link |
"B Miller" | > What's wrong with it being in the database directory?
Probably nothing "wrong" with it being in the database directory. I just was looking to keep my db directory cleaner with temps being in a separate directory that could be easily emptied. Thanks, Bill |
Mon, Jun 12 2006 11:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Bill
I think that I've seen references to db\subdir\file but I'm not sure. If my memory's not playing me false you could create a directory off the main database and use that. Roy Lambert |
Mon, Jun 12 2006 11:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bill,
<< How do I create a temporary table on the server without it being in the regular database directory? Due to possible size issues, I don't want to create memory tables. I know the select * into \memory\temptablename from tableA but is there a select * into \temp\temptablename from tableA I want to be able to share the data in the application like a memory table. >> The best option would be to create a database directory called "Temp" for this purpose. BTW, ElevateDB always has a "Temp" database available that corresponds to the temporary database directory for the database server. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, April 19, 2024 at 07:09 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |