Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate() and requery()
Message
De
26/03/2006 21:46:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Tableupdate() and requery()
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01107837
Message ID:
01107837
Vues:
66
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform