Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
Visibility of temporary tables |
Tue, Apr 19 2011 11:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I'm looking at using temporary tables in place of in-memory tables for some parts of my app. I'm blocked because I use the presence of the table as a flag to say no one else should be doing this (eg moving records around for relationships in a treeview). With in-memory tables I can test for the existence of the table, but with temporary tables I can't.
Can we have an option that essentially does select * from information.temporarytables SHOWALL Roy Lambert |
Tue, Apr 19 2011 5:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I'm looking at using temporary tables in place of in-memory tables for some parts of my app. I'm blocked because I use the presence of the table as a flag to say no one else should be doing this (eg moving records around for relationships in a treeview). With in-memory tables I can test for the existence of the table, but with temporary tables I can't. >> Are you looking for global (not per-session) temporary tables ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 20 2011 2:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< I'm looking at using temporary tables in place of in-memory tables for >some parts of my app. I'm blocked because I use the presence of the table as >a flag to say no one else should be doing this (eg moving records around for >relationships in a treeview). With in-memory tables I can test for the >existence of the table, but with temporary tables I can't. >> > >Are you looking for global (not per-session) temporary tables ? That would certainly be one way of doing it, but I was more just thinking of being able to query for all the temporary tables in use. Since I don't know how its working under the hood I have no idea if its even achievable. My assumption is that the config file is updated but you might be doing something totally different. If its easily achievable great - I want it - if not I'll figure out an alternative. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |