locked
Why the stored procedure [xxx_insert] has been executed but nothing didn't be done in database? RRS feed

  • Question

  • In my Sync app, After run sync,Log shows that everything is ok, But nothing happened in database. For example, the stored procedure [xxx_insert] has been executed and get 1 inserted, but I don't found the row inserted in database?  Here is the log block as blow.

    INFO   , DMI.Host.WPFUI.vshost, 9, 06/19/2012 16:41:14:955,    ----- Inserts for Table "[ApplicationUser]" -----
    INFO   , DMI.Host.WPFUI.vshost, 9, 06/19/2012 16:41:14:983,       1 Inserts Applied
    INFO   , DMI.Host.WPFUI.vshost, 9, 06/19/2012 16:41:14:983,    --- End Inserts for Table "[ApplicationUser]" ---

    Any ideas?

    Tuesday, June 19, 2012 7:06 PM

Answers

  • I have found the reason. It's because there is an error when handling another table. If I remove the table that will cause the error, ApplicaitonUser will be updated.
    • Marked as answer by mark kang Tuesday, June 19, 2012 8:15 PM
    Tuesday, June 19, 2012 8:14 PM