Hi Ezio, I am not sure if I can switch firebird's version... My client has a system build with Delphi 7 & BDE .. and we would have to re-test all this system with Firebird 2... :(
I took a quick look at SA source code. If I am not wrong, all I have to do is override "visit_alias" method in FBCompiler... and omit " as " text, of course... :) I still need to prepare a firebird database at home to tweak SA's code.. []s Roger On 10/6/06, Ezio Vernacotola <[EMAIL PROTECTED]> wrote: > > A possible workaround is switch to firebird 2.0 now, is very close to final > release, largely backward compatible and accepts "AS" in table aliasing > > Ezio > > > Roger Demetrescu wrote: > Yes... I don't have SA here now, but probably the example from [1] > won't work either. > I'll try it tomorrow morning and let you know.... > > Cheers, > > Roger > > > [1] - > http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_alias > > > > > On 10/5/06, Lele Gaifax <[EMAIL PROTECTED]> wrote: > > > Ezio Vernacotola wrote: > > > I don't understand what you are trying do to with column and table > aliasing. > Can you give some code example to better explain your problem? > > > I think it is not relevant: effectively Firebird does not like the table > alias introduced by "AS", so most probably the FB backend should omit > that keyword when a table alias is used. > > ciao, lele. > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
