Joel

I am not sure about what is causing the update conflict. This usually happens when someting changes on the Sql Server side. You can use the second parameter to force the update tableupdate(1,.t.).

This example would be much faster.

lnHndl = cursorgetprop("yourview","ConnectHandle")
lcSql = "update view_table set xxx=1"
lnResult = sqlexec(lnHndl,lcSql)
requery("yourview")

>I have a remote view to an SQL table of about 100,000 records.
>
>if I open the table, then say Go Bottom (to give it time to open) and then say:
>
>Replace all XXX with .f.
>Tableupdate()
>
>It will update a few records then give me UPDATE CONFLICT
>
>So I put a a Do While loop and Replace XXX with .f. then a Wait Window Timeout .1 and Tableupdate() and it goes down the file a lot farther, but that is slow and it too eventually stops.
>
>If I put Wait Window Timeout 5 it goes much farther, but eventually says my ODBC connection is BUSY.
>
>Obviously I have some seting wrong because on a 100,000 record file I can not wait several seconds for each Tableupdate().
>
>Should this work???
>
>Replace all XXX with .f.
>Tableupdate()
>
>
>Thanks
>Joel
>Houston, TX