Tim,
>From the few tests I have done the SQL_IDENTIFIER_QUOTE_CHAR from the GetInfo
function is not dynamic. I haven't done enough tests to determine if it is
always set to the database's default quote character or dependent on the value
at connectionr time but my test using Syabase ASA and MS-SQL Server indicate
that if quoted identifiers are on as a server option then the
SQL_IDENTIFIER_QUOTE_CHAR is set at connection time and stays the same no
matter what the actual state of client connection option (ON or OFF).
With Synase ASA you can use "SELECT CONNECTION_PROPERTY ('QUOTED_IDENTIFIER')"
to determine the current state. I've tried but failed to determine the
current state with MS-SQL server using sp_dboption and sp_configure 'user
options' - perhaps Michael Peppler knows how to do this?
--
Simon Oliver
