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é ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
