Insert into table with trigger results in error "Key column information is insufficient or incorrect

[LarryFarrell]

The complete error reads "[0x80004005][Microsoft Cursor Engine] Key
column information is insufficient or incorrect. Too many rows were
affected by update."

In this case, I have a table with a trigger that creates rows in other
tables based on information inserted here. I can run this insert from
SQL Server without a problem. All tables ge updated as expected.
However, if I insert a new record into InfoPath and submit it, I get
the error above. I remove the trigger and everything is right with the
world. (Except my data!)

Has anybody witnessed InfoPath not playing well with triggers?

Please help! It would be very appreciated! It is the 11th hour as it
is.

--Larry--

 

[Steve van Dongen [MSFT]]

The complete error reads "[0x80004005][Microsoft Cursor Engine] Key
column information is insufficient or incorrect. Too many rows were
affected by update."

In this case, I have a table with a trigger that creates rows in other
tables based on information inserted here. I can run this insert from
SQL Server without a problem. All tables ge updated as expected.
However, if I insert a new record into InfoPath and submit it, I get
the error above. I remove the trigger and everything is right with the
world. (Except my data!)

Has anybody witnessed InfoPath not playing well with triggers?

Please help! It would be very appreciated! It is the 11th hour as it
is.

See my response in this thread:

<URL:
http://groups-beta.google.com/group..._frm/thread/d5ba48faf0c178b1/e3ec0af9d459f6d5
/>

Regards,
Steve

 

[LarryFarrell]

That is SOOO COOL!

I have been panicking all night!

I didn't think that that thread applied. Probably since I didn't
understand it! But I used that 'set nocount on' and 'set nocount off'
and it worked fabulously!!!!

Thank you!