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")