You need to check for error.
if not TABLEUPDATE(.T.)
local laError[1]
aerror(laerror)
?laerror[2]
endif
You need to look at aerror() to see what other information it returns.
>I have a program in which I open MS Access database tables from. The tables open find,
>but having trouble doing a Tableupdate(.t.) when I process all the records at the end.
>
>Im trying to set a filter on the query, then update the query via tableupdate(.t.)
>once Im done processing, and do a requery(). However, I get an error "table buffer contains uncommitted changes". Here's the code Im using to set it up:
>
>
OPEN DATABASE c:\home\application\accessdb.dbc
>USE accessdb!vw_table1 SHARED
>=cursorsetprop("Buffering",5,"vw_table1")
>SET FILTER TO vw_table1.processed = 'I '
>
>do loop here to check all records with 'I '....
>and process....
>Done- Exit loop...
>
>SELECT vw_table1
>LOCATE
>REPLACE all processed WITH 'P '
>=TABLEUPDATE(.T.)
>REQUERY() Errors here...
>
>
>Also closing the file and reopening it the records are not updated.
>Any help on this is Greatly appreciated..
>
>Thanks,
>
>Craig