Hi Francis,
Yes, I think that needs to be changed. I don't remember why we built it this way and I agree that it is too intrusive. Sorry, but I have been too busy this weekend (New furniture for the children). But I am confident that I will be able to address this next weekend. Regards Rainer Francis De Brabandere wrote: Rainer? On Sun, Jan 10, 2010 at 7:43 PM, Exxos <[email protected]> wrote: Hi, db.album.title.as("title") will generates the following SQL column name >>> "TITLE" in upper case in the SQL command... Is there any reason? cmdUnion.select(db.album.id,db.album.title,db.album.index,db.album.serieId,db.album.title.as("title")); SELECT t1.alb_id, t1.alb_title, t1.alb_index, t1.alb_ser_id, t1.alb_title AS TITLE This is not consistent in case of using lower case for defining columns name and this is too intrusive... I think this is the responsability of the developper and not empire-db to decide. Please advise. /Cheers -- http://www.somatik.be Microsoft gives you windows, Linux gives you the whole house.
