Hi, I'm a nerb with SQLAlchemy, so this is probably a silly question, but here goes. I have a table in SQL Server V.8 where I am trying to insert a row. Here's most of my code:
<code> from sqlalchemy import * db = dbConnect() # function to connect to my db db.echo = True metadata = MetaData(db) entries = Table('tbl_TimeEntries', metadata, Column('dateworked', String(10), primary_key=True), Column('empid', Integer, primary_key=True), Column('reg', Float), Column('ot', Float), Column('ce', Float), Column('hol', Float), Column('sklv', Float), Column('vac', Float), Column('ct', Float), Column('conv', Float), Column('misc', Float), Column('comments', Unicode(256)) ) i = entries.insert(values={'dateworked':'02/13/2008', 'empid':258, 'reg':8.00}) </code> Unfortunately, this results in the following traceback: Traceback (most recent call last): File "//someServer/Scripts/PythonPackages/Development/Timesheet/ sqlalchemy-test2.py", line 48, in -toplevel- main(tblName, key, val) File "//someServer/Scripts/PythonPackages/Development/Timesheet/ sqlalchemy-test2.py", line 28, in main i.execute() File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\sql\expression.py", line 992, in execute File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\engine\base.py", line 1211, in execute_clauseelement File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\engine\base.py", line 895, in execute_clauseelement File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\engine\base.py", line 906, in _execute_compiled File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\engine\default.py", line 278, in pre_execution File "c:\python24\lib\site-packages\SQLAlchemy-0.4.2b-py2.4.egg \sqlalchemy\databases\mssql.py", line 322, in pre_exec File "C:\Python24\lib\site-packages\pymssql.py", line 126, in execute self.executemany(operation, (params,)) File "C:\Python24\lib\site-packages\pymssql.py", line 152, in executemany raise DatabaseError, "internal error: %s" % self.__source.errmsg() DatabaseError: internal error: SQL Server message 8106, severity 16, state 1, line 1: Table 'tbl_TimeEntries' does not have the identity property. Cannot perform SET operation. DB-Lib error message 10007, severity 5: General SQL Server error: Check messages from the SQL Server. Upon digging in Google and Microsoft's pages, it seems that SQLAlchemy is trying to use the SET IDENTITY_INSERT setting for a column that doesn't have this setting. Why is it doing that in the first place and how to I stop that behavior? Also, as you may notice, I have two columns set as the primary key. Is that the correct way to create a composite primary key? Any tips are appreciated. I apologize for the lengthy post. I am programming with Python 2.4 and SQLAlchemy-0.4.2b on Windows XP. Thanks, Mike --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---