Hi Gang,
this is probably something WAD / inherited, but nonetheless it is
undesirable and I'd like to know if there is something one can do to
avoid it.
I was helping a company to move from dBase/DBF to C#/Firebird, but
their IT already made a migration of the huge DBFs to Firebird. They
were mostly using "default" settings, though, and so the databases are
with Characterset "NONE" and the identifiers are quoted.
Don't know how the Characterset is involved in the problem, but the
quoted identifiers definitely are.
It turned out that the dataadapter's fill() method is automatically
uppercasing the select command. So, to make a fill() work, the command
has - for example - to be changed like this:
standard:
"Select Field_1, Field_2, Field_3 from Table_1 where Key_1 = @Value_1"
after autoconversion by dataadapter fill():
"SELECT FIELD_1, FIELD_2, FIELD_3 FROM TABLE_1 WHERE KEY_1 = @VALUE_1"
which will fail, because the FB server rejects the uppercase'd
identifiers.
modification:
"Select \"Field_1\", \"Field_2\", \"Field_3\" from \"Table_1\" where
\"Key_1\" = @Value_1"
this works but it is a lot of hard work in coding and very ugly
reading.
Is there anything that can be done to ease this, any setting, any
automation?
I recommended - of course - to re-create database and do away with the
quoted identifiers nonsense, and they indeed prefer this over
constantly ESCAPEing the quotes in the query commands.
But if there is any other option...
thanks in advance!
André
|
