Steve Naidamast wrote:
> However, could you clarify what you mean between a session or a transaction?
Session == connection
I guess you know what a transaction is.
You can define a GTT with a life that lasts as long as the transaction
in which it is instantiated, i.e.,
CREATE GLOBAL TEMPORARY
Hi Helen...
Thank you for clearing this up for me.
However, could you clarify what you mean between a session or a transaction?
Steve Naidamast
Sr. Software Engineer
Steve Naidamast wrote:
> By using a global table in Firebird, could not multiple users cause
> a conflict if two such users were to issue the same query against the global
> table?
No. A GTT definition is persistent, of course, but persistent data
are not stored in it. A GTT instance is
By using a global table in Firebird, could not multiple users cause a conflict
if two such users were to issue the same query against the global table?
Coming from a SQL Server background, I am used to using local temporary
tables, which are isolated on a query by query basis...
Steve
Hi.
There are 2 common ways
1. Create global temporary table
Do INSERT INTO T(DSTART, DEND) SELECT …
and then do simple join with this table
2. Use derived table e.g.
SELECT
DATENLOGGING.* …
FROM
(SELECT D.DSTART, D.DEND FROM TABLED) X
LEFT JOIN DATENLOGGING ON DATENLOGGING.DATUMZEIT>=X. DSTART