Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate() and requery()
Message
De
26/03/2006 22:58:31
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
26/03/2006 21:46:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01107837
Message ID:
01107842
Vues:
21
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 && 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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform