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
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching