Error - Data Updated by another user if SP updates value

BLOMASKY

I have a rule on an attribute that calls a stored procedure and updates an attribute in the current record. It looks like:

If Quotes.LFMaxQty WAS CHANGED Then
FIND ALL VirtualFields

EXEC_SP 'CreateQuoteTally' WITH '@QuoteID'=Quotes.ID,'@Item'=Quotes.ob_Items.ID,'@LFRequired'=Quotes.LFMaxQty,'@LFtoUM'=Quotes.LFtoUM,'@Bundle'=Quotes.sc_PcsBundle, '@TallyUM' = Quotes.tallyUM OUT

Notice the last part where the TallyUM updates the QuoteTallyUM

The problem is, I have a form when I hange the LFMaxQty, the rule runs FINE, I can see the updated data, but when I click the SAVE button, I get the error that the data was changed by another user.

Any suggestions?

Thanks
Bruce

tford

Have you listed the BO Quotes in the Auto Refresh triggers on the form?

BLOMASKY

Tom, I am editing the Quotes BO. If I had it refresh, then my unsaved data would prolly go poof.

tford

I thought from your previous post that you were triggering the stored procedure with a rule marked as dynamic.

BLOMASKY

Yes, it is dynamic, but perhaps I didn't explain the issue.

I have a form, with a few input fields, and one calculated (display only) field. When I change one of the input fields, the dynamic rule will call a SP, which has as part of it: '@TallyUM' = Querys.tallyUM OUT

This updates the field, displays it on the form. However, when I click the save, i get the error of record changed by another process. Since I am editing the Querys BO, there is no reason to have any refresh, since the form has been refreshed by the rule.

Did i explain that better?

Thanks
Bruce

btw, as a work around, instead of having the SP return a value, I have my rule do a calculation like:

Quotes.tallyUM=Quotes.LFtoUM * SUM QuoteTally.qtyLF WHERE (QuoteTally IN Quotes.om_QuoteTally)

This works fine. it is updating the same field that the SP is updating. It seems like some flag is (not) being set when the SP is updating an attribute