There should be a way to SET IDENTITY_INSERT "all" OFF ?? I inserted a row directly into table "B" using Microsoft SQL. MSQL of course SET IDENTITY_INSERT ON for table "B" for the INSERT. I forgot to turn it off. So the next time I used Witango I got an error message.
544 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'rp350' when IDENTITY_INSERT is set to OFF. I have code in Witango to manage the SET IDENTITY_INSERT(s) but it failed becauase I neglected to include table "B". Does anybody have code that would: SET IDENTITY_INSERT "all" OFF Then Witango SQL would be ready for the SET IDENTITY_INSERT ON ************************************** here is a code sample I use [Direct DBMS Action] [36] GetNewProfileID_rp350 : ADEDEVDS1_TEST [Query] [36] SET IDENTITY_INSERT physio.rp250 OFF SET IDENTITY_INSERT physio.rp350 OFF SET IDENTITY_INSERT physio.rp250RxPlan OFF SET IDENTITY_INSERT physio.rp250_icd9 OFF SET IDENTITY_INSERT physio.rp350 ON SELECT max( ID_RP350PROFILEID ) + 1 from physio.RP350 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
