[sqlalchemy] Re: cant update mssql table

2008-05-01 Thread adi
Hi paul thanks for the reply. i kind of solved it by removing the identity field before merging the session , this make the field take a default value from the db and thus solves my purpose regards, adi On Apr 28, 3:08 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, a table in a mssql db

[sqlalchemy] cant update mssql table

2008-04-26 Thread adi
hi all, just started out with SA,here is my problem a table in a mssql db with a uniqueidentifier field as primary key and an integer field as identity,i am able to insert a row into the table but not update it ,on updation it gives cannot update identity column. how do i solve this ,is there a

[sqlalchemy] cannot update mssql table

2008-04-26 Thread adi
value from the db. any pointers to what i am doing wrong. TIA adi --~--~-~--~~~---~--~~ 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

[sqlalchemy] cant update table in mssqldb

2008-04-26 Thread adi
hi all, i am a newbie at SA ,te problem i am facing is as follows i have one table with among other fields one uniqueidentifier field as primary key and an auto increment identity field although i can insert new records when i try to update i get cant update identity field error .How do i avoid