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 <mike...@zzzcomputing.com> 写道: > 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 sqlalchemy@googlegroups.com. >> To unsubscribe from this group, send email to >> sqlalchemy+unsubscr...@googlegroups.com. >> 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 sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > 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 sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.