Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() and requery()
Message
From
26/03/2006 21:46:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate() and requery()
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01107837
Message ID:
01107837
Views:
65
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 && bring to top 
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
Next
Reply
Map
View

Click here to load this message in the networking platform