>I have the following little test program that returns a .T. for the Tableupdate() but then fails in the CURSORSETPROP command. It returns "contains uncommitted changes". SQL Server has been updated correctly.
>
>We are using SQL 7 Desktop with SP1 along with VP6,SP3.
>We have not had this problem using SQL 6.5.
>We have not yet loaded SQL 7 on our server so we do not know about that one.
>
>Any ideas?
>
>clear
>gccompno='01'
>
>SELECT 0
>USE "ds!v_postaropeninvoices" alias v_postaropeninvoices
>=CURSORSETPROP("Buffering",5,"v_postaropeninvoices")
>
>DO WHILE NOT EOF()
> REPLACE rio_aracct WITH 'TEST'
> SKIP
>ENDDO
>
>SELECT v_postaropeninvoices
>llgo=TABLEUPDATE(1,.T.)
>if llgo
> =messagebox('ok')
>else
> =messagebox('bad')
>endif
>
>SELECT v_postaropeninvoices
>=CURSORSETPROP("Buffering",3,"v_postaropeninvoices")

I've seen similar results. As a work around, issue a table revert right after the successful update.

Dan