Uwe Grauer wrote: > Paul McNett wrote: >> Okay, we are in slightly better shape with the firebird unit tests, as >> they run but some of them fail. Here's what I'm seeing: >> >> [EMAIL PROTECTED]:~/projects/dabo/dabo/db/test$ python test_dCursorMixin.py >> EF.F...F.F...E...E.................................... >> ====================================================================== > > Sorry for answering late on this. > I didn't understand your attempt to handle this in dabo, > so i didn't do anything about it. > > I already tried to explain what the problem is: > > If you do create a table with "create table atable ( aField INT )" > aField is not case sensitive. > If you do it with "create table "aTable" ( "aField" INT )" aTable and > aField are case sensitive.
Uwe, are you saying that we created the tables with quoted names, and we shouldn't have, or are you saying that we created the tables without quoted names and should have, or something else entirely? I'm inclined to think that we *should not ever* use quoted table or field names unless it isn't an option (inherited database that uses reserved words or spaces). Is this a good thought? Anyway, I still need to get back to these errors in the unit tests, but I don't think the errors we are seeing relate directly with the double-quoted names issue. I think that Dabo is lower()ing the field names at some point, resulting in the name "cField" not being equal to "cfield". > I hope that you can look into it soon. I hope to as well. I've been super busy both professionally and personally. -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
