Dean,

Look at dbsetprops for 'wheretype' and 'updatetype'.

John

>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