HI,

I've got a field rule on Items.iQtyOnHand:

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).

The error is #1887 and the help suggests checking my rule and trigger code.

Can anybody see what's wrong?