Skip to Content
0
Former Member
Apr 12, 2016 at 07:05 AM

Stored procedure

150 Views

Dear expert can any one help me to write the procedure under which we want that once we print the sales order users can not be update or edit the sales order except the Remark(comment) column.

Below store procedure i can do but i want to left remark column .

if @object_type = '17' and @transaction_type = 'U'

BEGIN

if exists(Select T0.DocNum from [ORDR] T0

Where T0.printed='Y'

AND T0.DocEntry=@list_of_cols_val_tab_del)

begin

SELECT @error = -5001, @error_message =

'Sales order not updated once print'

end

please help me

thanks