Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Temporary Table |
Tue, Sep 21 2010 10:14 AM | Permanent Link |
gripsware gripsware datentechnik gmbh | Is it possible to create a temporary table, that is visible for all clients connected to the database?
I have 2 applications working with the same database, my idea is to exchange messages between these 2 applications through a temporary table. E.g. Refresh Query, Shut Down etc.... Regards Michael |
Tue, Sep 21 2010 1:18 PM | Permanent Link |
Uli Becker | Michael,
> Is it possible to create a temporary table, that is visible for all clients connected to the database? A temporary table is visible only within the session where it was created. Why don't you want to use a "regular" table? Regards Uli |
Wed, Sep 22 2010 2:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Michael
From the bit you've posted it looks like you want one application to tell the other to carry out specific tasks. My personal preference for that would be to use some sort of comms protocol and pass messages. Failing that I'd use a simple text file which both applications can access. Roy Lambert [Team Elevate] |
Wed, Sep 22 2010 3:08 AM | Permanent Link |
gripsware gripsware datentechnik gmbh | Uli,
it´s no problem to use a regular table for that issue - but these messages must not saved for a longer term, it would be a nice feature that the table would be dropped when the last connection to the database was closed. First application which connects to database creates the table .... I think this would be a nice feature. Regards Michael Uli Becker wrote: Michael, > Is it possible to create a temporary table, that is visible for all clients connected to the database? A temporary table is visible only within the session where it was created. Why don't you want to use a "regular" table? Regards Uli |
Wed, Sep 22 2010 3:11 AM | Permanent Link |
gripsware gripsware datentechnik gmbh | Roy,
I think also first to use broadcast messages or something else to send messages between the apps. But all apps work on the same database, so I think it´s easier to use the database for that stuff. Regards Michael Roy Lambert wrote: Michael From the bit you've posted it looks like you want one application to tell the other to carry out specific tasks. My personal preference for that would be to use some sort of comms protocol and pass messages. Failing that I'd use a simple text file which both applications can access. Roy Lambert [Team Elevate] |
Wed, Sep 22 2010 4:06 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Michael
OK. In that case have a look in the extensions for EDB User Count - a table using transitent locks from Terry Swiers. I use it for a number of things, mainly for monitoring users, but also to share locking status on some of the apps. Roy Lambert [Team Elevate] |
Wed, Sep 22 2010 8:49 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Is it possible to create a temporary table, that is visible for all clients connected to the database? >> Not currently, no. It is something that has been requested, but there are some "wrinkles" in the design of EDB that prevent it from being implemented yet. -- 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 |