Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The INDEX ON command
Message
De
06/07/2000 15:54:11
 
 
À
06/07/2000 15:31:00
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00389018
Message ID:
00389093
Vues:
22
>>>>A view is always opened exclusively, regardless of the lock status of the underlying table(s).
>>>
>>>So a view shouldn't be used in a record search procedure if the environment is multi-user?
>>
>>Fundamentally, a view is just the result of a SELECT - SQL statement. Its contents are valid as at the instant it was opened.
>>
>>You can refresh a view's contents (basically cause its underlying SELECT - SQL to be run again) by using the REQUERY() function.
>>
>>If you REQUERY(), you don't need to regenerate your indices, they will still be in effect.
>
>Am I right in my thinking -- If person1 is using a form with the view in its D.E., a person at another workstation can't use the form person1 is using because it calls the same view (which is opened exclusive)

No, that's not correct. A view is a local cursor. Conceptually it's the same as a SELECT - SQL result cursor, except that it can be made updateable. In your example, each workstation would get a local cursor created on their machine. These cursors are completely independent.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform