You can make SPT cursor updateable. See faq #8153.
>Hi
>
>I am reprograming some parts of VFP Aplication on SQL Server Back end. In some cases I use SPT
>instead remore view. With remote view I use DBSETPROP() for automatic conversion from Datetime to
>Date format.
>
>DBSETPROP('DBOrder.OrderDate','FIELD','DATATYPE',"D")
>
>DateTime from SQL Server is avtomaticly converted to VFP date type.
>
>Now I would like to do conversion also in resulting cursor after Select statement. Is it possibile?
>
>Thisform.grid1.Date.controlsource="TTOD(Result.OrderDate)" is not sending canges back to SQL Server
>
>
>Regards
--sb--