Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SELECT returns old data...
This one has been dogging me for years in one form or another. I go into a form, run a SELECT and new records appended by another user are. Go out of the form, go back in, on and on and on. In some cases I need to quit the program to make the new records show up.
I can fix the problem by moving the record pointer in the table(s). A simple
SELECT MYTABLE
GO TOP
SELECT * FRO MMYTABLE
makes all of the data appear all of the time. GO RECNO() has the same effect as does anything that moves the record pointer. I realize that this has to do with local data and index caching and is part of the reason that VFP is so fast, but there must be a less klunky way of handling this.
SET REFRESH has no effect.
Did I miss some setting in VFP somewhere that would make this problem go away?
Mike
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement