>Hi ALL!
>
>Help me, please.
>This small example :
>....
>lcSelect = "select * from brt_sotr order by surname"
>*
>lnResult = sqlexec(lnConnHandle, lcSelect, 'vSotr')
>if lnResult <> -1
> = cursorsetprop("SendUpdates",.T.) && Enable Update
> = cursorsetprop("tables","BRT_SOTR") && Source for Update
> browse && Edit Data
> use && Want Update Remote Table ... Oops! Error message :(
>endif
>....
>What's wrong ? And may be update cursor without USE command ?
>
>Thank you.
>Yuri.
= cursorsetprop works for local and remote views,
if you want to use the in sqlexec make remote views,
test them for update , if it work ,generate database code with gendbc.prg
take part of code after remote view ant put in your code
Best wishes, Vladimir Zhuravlev
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.