Rick,
This is strange indeed. There certainly shouldn't be any uncommitted changes if TABLEUPDATE(1) returns .T. This is a long shot, but you could try using AERROR() after the TABLEUPDATE() to see if any error is returned. You might also want to make sure you're using the latest SQL Server driver.
>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")