Comments by cindy_m (Top 2 by date)

cindy_m 23-Jun-15 9:04am View

The stored procedure is generated in code based on the schema. There's a call to schema.update with the schema name, serialized schema and serialized dataset passed to it. When the record is saved, the code checks to see if the table row changed. If it did then the old row is expired and the new data row is added. If there's no change, nothing is done. Right now, it doesn't recognize any changes to the new fields, but will save if one of the original fields is changed. I tried to find more information on deploying the server project to see if it's just missing the new schema. I did find where the assemblies are in SSMS so at least I know where to look to see if any changes happen on deployment.

Thanks for your help with this.

cindy_m 22-Jun-15 23:18pm View

Yes, it's a CLR_SP in the server project. I added the new fields to the insert statement that is called by the stored procedure.