Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Runnig SQL while table is updated
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Runnig SQL while table is updated
Divers
Thread ID:
00609907
Message ID:
00609907
Vues:
41
Hi everybody,

Suppose, one station is running this SQL:
select count(siteid) from o:\redp\dbc\MA\sitemstr where ccode='01' and ttod(Modidate)=date()

while the database is changing. Which records would come into result? How VFP internally deals with this situation, where and how SQL is performed?

I'm talking about native VFP tables.

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform