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


 

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

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]

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

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]

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]

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