Thanks for your reply. I have found an option in creating table to force the quoting off. Just pass quote=false as additional argument when creating tables, it works.
Thank you all the same. Joel 发自我的 iPhone 在 2011-1-21，23:24，Michael Bayer <[email protected]> 写道： > use lower case names for your column names in Table metadata, so that they > are case insensitive. they will not be quoted. > > > On Jan 21, 2011, at 2:00 AM, Joel Zhou wrote: > >> Hi All >> >> I am using sqlalchemy 0.6.5 with sybase dialect. Python-Sybase driver >> is 0.39. >> >> The query SQL generated by sqlachemy has double quotes on each >> identifier, something like: >> >> SELECT "MYTABLE"."ID" AS "MYTABLE_ID" FROM "MYTABLE" >> >> among which "MYTABLE"."ID" is syntactically wrong in ASE 12.5. >> >> Is this a known issue or I have done something wrong? Can I turn off >> the quotes on the column identifiers? >> >> Thanks >> Joel >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/sqlalchemy?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
