Select scope_identity returns null

This is the place for advice and discussions 0 2. Sign in to vote. Please help. Monday, March 16, PM. Final working version below once again , thank you all.

Does the table have an identity column? I have RecNo field, the properties below.. It looks like Recno is your identity column. Could you please pass the values to SP with parameter names instea do positional values like shown in my code and try and let me know..?? Please carry the following steps and let me know. Insert record into table using SP. Can you post the complete defintitions SQL, C that are involved? HelpKeywordAttribute "vs. TableAdapter" ] [System. DataObjectMethodAttribute Sy stem.

CommandCollection[2]; if TransmissionDate. DateTime TransmissionDate. State; if command. Are there any constraints active on your table? Does it work? This is odd. When there is no instead of trigger active, then you must have an error somewhere in your TableAdapter. But i can't see it right now, sorry.

Thanks for all your help and suggestions. This discussion thread is closed Start new discussion. Muenchbourg last post: by. Problems with insert statement using SSL Verisign. Hilary Cotter. Post by Brandi Lea I am about to scream and was wondering if anyone could help me with my issue. I recently wrote some triggers to act as a changelog system on our production database.

The problem I am running into is that we have some legacy code that passes dynamic sql into a stored procedure and returns that value and not the value of the table that I am wanting. Any suggestions? Here's my stored procedure.. I hope some one can help.