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?

Ezio





Roger Demetrescu wrote:
> Hi,
>
> Firebird 1.5 allows the following sentences:
>
> select myfield from mytable;
> select myfield FOO from my table;
> select myfield AS FOO from mytable;
>
> (the last 2 sentences change the name of the final column, right ?)
>
>
> The same rules don't apply when we create tables aliases:
>
> select myfield from mytable BAR;     => this works
> select myfield from mytable AS BAR;     => this doesn't work
>
>
> Is there any way to make SA avoid to use this " as " sintaxe when
> aliasing table names ?
> I am trying to use 2 mapped objects, with relation(..., lazy=False),
> and I am getting FB's error:
>
> "Token unknown"
>
> just because " as "  is been used in the SQL generated by SA...    :(
>
>
> BTW, I have also tried do use quote=False in Table() declaration, but
> it seems to not have any  influence... am I missing something ?
>
>
> Please let me know if you need more details...
>
> Cheers,
>
> Roger
>
> -------------------------------------------------------------------------
> 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

Reply via email to