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