Hello all.
I created a local view as such ( please see code blow)

*************************************************
close all
open data data\clnrware
drop view lv_Price

create sql view lv_price as ;
select price.*, Service.descr, Garment.descr ;
from clnrware!Price ;
INNER join clnrware!Service;
on Price.Service = Service.recid;
INNER join clnrware!Garment ;
on Price.Garment = Garment.recid ;
where Price.Service = ?pv_service ;
order by Service.descr,garment.descr
* and Price.Garment = ?pv_garment

=dbsetprop("lv_price","View","SendUpdates",.t.)

=dbsetprop("lv_price.recid","Field","KeyField",.t.)

=dbsetprop("lv_price.recid","Field","Updatable",.t.)
=dbsetprop("lv_price.retail","Field","Updatable",.t.)
=dbsetprop("lv_price.tier1","Field","Updatable",.t.)
=dbsetprop("lv_price.tier2","Field","Updatable",.t.)
=dbsetprop("lv_price.tier3","Field","Updatable",.t.)
=dbsetprop("lv_price.tier4","Field","Updatable",.t.)
=dbsetprop("lv_price.tier5","Field","Updatable",.t.)
=dbsetprop("lv_price.tier6","Field","Updatable",.t.)
=dbsetprop("lv_price.tier7","Field","Updatable",.t.)
=dbsetprop("lv_price.tier8","Field","Updatable",.t.)
=dbsetprop("lv_price.tier9","Field","Updatable",.t.)

close all

return
****************************************************

It will not update my PRICE table.
Any help will be appreciated.

Thanks