On 9-9-2019 12:35, liviuslivius wrote:
Hi
there are
SET DECFLOAT BIND double precision;
SET TIME ZONE BIND
Is there a way to read current settings?
Is there a way to restore it then?
eg.
var_previous = GET DECFLOAT BIND;
SET DECFLOAT BIND double precision;
/* calculate something */
/* and now restore previous settings */
SET DECFLOAT BIND :var_previous;
And what is the scope of those settings? Are they assigned to whole
connection or current transaction?
They apply for the connection until you issue an `alter session reset`
or change the value. An `alter session reset` will either reset to the
default (native), or to the bind configuration specified in the database
parameter buffer.
Note that `alter session reset` will reset other things as well, so it
might be better to explicitly revert using `set decfloat bind native`.
I'm not aware of an option to query the current configuration.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
