Update the Stored procedure problem ....

Hello,

   I use a Stored procedure for retrieve the sales order detail data from
SQL server into the grid, I can append & Update data through the
StoredProc1(CachedUpdates is True) and using the UpdateSQL component for
update data. It is fine UNLESS I cannot delete it. Why ?
example.

Delete from Sales_Order_Details
where
  SO_NO  = :Old_SO_NO and
  Band_no = :Old_Band_no

The above code is inside the UpdateSQL Component's DeleteSQL. Wht is the
problem ?
Thanks for your attention.

Regard,
 {*word*106} Wong