Subject | Re :Re: [IB-Conversions] Date Problem in Interbase 5.6 to Firebird 1.5.4 migration |
---|---|
Author | Helen Borrie |
Post date | 2007-09-07T08:05:28Z |
At 05:16 PM 7/09/2007, you wrote:
isql using the -i <scriptfilename> switch). And yes, once you switch
to another dialect, isql becomes a client for that other dialect.
For your applications, you still have to figure out how your
connectivity layer handles dialect and do whatever it takes to make
sure the clients that access the dialect 1 database do so as dialect 1 clients.
Some components provide you with a class attribute for SQL
dialect; others require you to include it in the database access parameters.
Helen
>Hi,Could you please confirm whether using the statement \'SET SQLSET SQL DIALECT n works only in isql (including scripts executed in
>DIALECT 1;\' sets the dialect value temporarily for that particular
>session or else maintains it throughout until other \'SET\' is used.
isql using the -i <scriptfilename> switch). And yes, once you switch
to another dialect, isql becomes a client for that other dialect.
For your applications, you still have to figure out how your
connectivity layer handles dialect and do whatever it takes to make
sure the clients that access the dialect 1 database do so as dialect 1 clients.
Some components provide you with a class attribute for SQL
dialect; others require you to include it in the database access parameters.
Helen