iqtyonhand=>0
I've also got a trigger on SalesDetails:vmp_ri("INSERT").AND.adjustqtyonhand(iitemid,iqty*-1)My trigger procedure is:
PROCEDURE AdjustQtyOnHand LPARAMETERS tiItemId, tiQty UPDATE Items; SET iQtyOnHand = iQtyOnHand + m.tiQty ; WHERE iItemId = m.tiItemId ; AND cType # "Service"If I enter a sale of an item that results in a negative stock value, when running the exe in runtime, I get an error: "Illegal recursion in rule evaluation" (after I get my "Not enough stock available" MsgSvc message).