Hi all, I have received a bug report about MS SQL Server 2000 and I'm searching for someone with an installation of this server (or any later version, if any) to run some tests.
This server - by default - prevents insert of primary keys' values (but it can be turned off using "SET IDENTITY_INSERT table OFF;") Only one table at a time can have identity_insert set to off. Looking at the code in SQLObject, it seems that it correctly calls "SET IDENTITY_INSERT table OFF;" if a given query requires to insert/modify a primary key. So it should work correctly, but it's not... :-/ If you have MS SQL Server installed, please try to run the imdbpy2sql.py script and see what happens. :-) -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
