Subject | Re: [firebird-tools] Temporary tables and interfaces |
---|---|
Author | Milan Babuskov |
Post date | 2004-09-17T17:26:16Z |
Daniel Rail wrote:
transactions or something else?
I'm very curious, since without it it doesn't really define how it all
should work.
SQL-client modules. I also sound like a very broad term, and can easily
be misinterpreted.
Well, I'm not expecting you to know all the answers, since you just
quoted the text, but I really hope that you know some.
Regards,
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
> That is, the contents of a globalAnd how are the SQL-sessions defined? Connections (attachments),
> temporary table or a created local temporary table cannot be shared
> between SQL-sessions.
transactions or something else?
I'm very curious, since without it it doesn't really define how it all
should work.
> In addition, the contents of a created local temporary table cannot beAlso, it would be good if you could copy/paste how they defined
> shared between SQL-client modules of a single SQL-session.
SQL-client modules. I also sound like a very broad term, and can easily
be misinterpreted.
> All references to a declared local temporary table are prefixed byI guess in every SQL statement?
> �MODULE.�.
> 7) If ON COMMIT is not specified, then ON COMMIT DELETE ROWS isAnd if it is? What other could happen to the rows?
> implicit.
Well, I'm not expecting you to know all the answers, since you just
quoted the text, but I really hope that you know some.
Regards,
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org