>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only