Re: [sqlalchemy] SA 0.8.0: Invalid argument(s) 'label_length'

2013-05-22 Thread Anthony Kong
don't think you need the label_length argument, the dialect should have that under control. if you do need it, you can set it after the fact: engine.dialect.label_length = 30 On May 21, 2013, at 11:04 PM, Anthony Kong anthony...@gmail.comjavascript: wrote: Hi, all, I have recently

[sqlalchemy] how to use bind_expression to build an express like 'convert(bit, @value)?

2013-05-22 Thread Anthony Kong
Hi, all, We are upgrading our application to use SA0.8.0. For reason outside our control, some XP workstations are using old sybase ODBC driver and we cannot upgrade them as of yet. The sybase driver will cause this problem in the following situation: 1) we have a table that have a field of

[sqlalchemy] SA 0.8.0: Invalid argument(s) 'label_length'

2013-05-21 Thread Anthony Kong
Hi, all, I have recently upgraded to use SA 0.8.0. Now when I run this statement, db = create_engine(sybase://, creator=self.buildConnection, echo=echo, label_length=30) it throws a TypeError exception: TypeError: Invalid argument(s) 'label_length' sent to create_engine(), using

Re: [sqlalchemy] How to insert a new row into a Sybase database table which has an IDENTITY primary key column?

2012-05-09 Thread Anthony Kong
Hi, Micheal, Thanks for the reply. I have added autoincrement to the Column definition of 'id', like so: id = Column(Integer, name='id_trade', primary_key=True, autoincrement=True) In the log I can see the id column is not included in the INSERT statement. I have taken that SQL statement

Re: [sqlalchemy] How to insert a new row into a Sybase database table which has an IDENTITY primary key column?

2012-05-09 Thread Anthony Kong
, May 10, 2012 5:09:59 AM UTC+10, Michael Bayer wrote: On May 9, 2012, at 4:46 PM, Anthony Kong wrote: Hi, Micheal, Thanks for the reply. I have added autoincrement to the Column definition of 'id', like so: id = Column(Integer, name='id_trade', primary_key=True, autoincrement=True

Re: [sqlalchemy] How to insert a new row into a Sybase database table which has an IDENTITY primary key column?

2012-05-09 Thread Anthony Kong
it to the 'id' field in flush() event Do they sound plausible? Are there any pointers/resource on how to achieve the above? Cheers On Thursday, May 10, 2012 7:43:43 AM UTC+10, Anthony Kong wrote: 1) Yes, I am working with existing table 2) The id column is not included in the SQL, which