Hi all.

The table in SQL Server has a unique index on a field. When I attempt to add a record with a duplicate value in this field, the SP correctly does not save the record. However, in my form, it looks like the save succeeded and no failed save message occurs. When does the SP need to return so that I can give the user the proper feedback?

TIA

It should be going off of the count (as you have recently discovered ) to determine whether the expected number of rows were affected. Is that count coming back as one even though you are not saving the record? i.e. when you run the SPROC manually in sql management studio with the same settings, does it come back as "1 row(s) affected"?

If your server isn't throwing an exception on the failed save, however, than strataframe may be interpreting it as a concurrency exception.

Let's put a handler on the ConcurrencyException and ErrorSaving events to see which one is being fired on the duplicate save, then let me know.

Thanks!