Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExec: as a user changes data, how can others see it?
Message
De
25/02/2004 14:27:18
 
 
À
25/02/2004 11:59:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00879984
Message ID:
00880816
Vues:
24
>Here's my connection:
>lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>"SourceDB=myDatabase.dbc;SourceType=DBC;UID=;PWD=;"

Why are you using SQL pass thru with foxpro data? You should be using native data access.

>User saves the changes by clicking a save button:
>xSuccess=TABLEUPDATE(0,.T.,'cMyTable')

That looks right... does xSuccess contain a number greater than 0?

>If I do a browse in command window, the changes will only show if I click/select the record that had just been changed.

You may have to use FLUSH.

I think we used to use:

GO RECNO()

This would update and FoxPro caching.

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform