any bit of info would be helpful
int quantityUsed = CAST(form.quantity.Text, int)
int verifyQuantity
SELECT quantity INTO verifyQuantity FROM component
WHERE itemName = form.item.Text
IF NOT_FOUND THEN
ELSE
IF verifyQuantity < quantityUsed THEN
ELSE
UPDATE component SET quantity = quantity - quantityUsed
WHERE itemName = form.item.Text
ENDIF
ENDIF
nallyaPosted Sep 13, 2012, 12:15 AM