Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select - SQL
Message
 
À
04/10/2000 16:43:34
Emerson Reed
Folhamatic Tecnologia Em Sistemas
Americana - São Paulo, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00425014
Message ID:
00425117
Vues:
11
Emerson,
First, are you using VFP tables or a client/server database like SQL-Server? The reasons for your problem will be different depending on which type of tables.

If you are using VFP tables: Are you running the SELECT after you have saved your data? If not, then you will not see the buffered data as the SELECT runs on your base tables. If you need to use the buffered data (for example if you run a report showing changes before the user saves the changes) you will have to work directly with the buffered data, perhaps using SCAN/ENDSCAN.

Have you looked at the base table after the Delete/Update to be sure the records have been changed? If the records have been changed, then it is possible that you have the tables open in your application under other aliases and they have not been updated by the changes saved.

If you're using SQL-Server you must still save the buffered data before doing a SELECT on the base tables.

HTH
Barbara


>Somebody would know to say me because the commands Delete and Update SQL bring up to date records that are buffered in a table and the Select of this same table does not return the buffered records?
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform