Hello.
I have a form which list an ORDERS table.
When the user delete an order, the record is not actually deleted from table, instead it has a FLAG put to 1 and a REASON text field set to whatever the reason is specified in the editable form.
I substitute the DELETE procedure, with a stored procedure that put a deleted flag to Y for the selected records.
When deleting multiple orders, the REASON is the same string for every selected record.
Is is possible to pass such an external string , once for all the selected records ?
If I set the REASON statically on the BeforeDelete event, of course it works, but I need to let the user specify the reason .
Thank you very much