Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate
Message
 
À
26/07/1999 20:32:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00246393
Message ID:
00246410
Vues:
22
>I'm using a local view with Buffer mode override = 5 (Table buffering). After some insertions, some validations involving seeks and some Set Order's, I issue TableUpdate(1) which returns .T.
>
>However the function GetFldState(-1) returns a string of 3's (33333333) and the next time I try to insert a new record I receive the error: 'Table is in use by another user'.
>
>Any hints are greatly appreciated
>
>Oscar

Oscar,

First your tableUpdate is assuming that the correct work area is selected. It is advisable to use all the arguments for TableUpdate and TableRevert to prevent bugs of something changing a work area on you.

TableUpdate(1,.F.,"MyCursor")

Second your getfldstate is telling you that you are on a new blank record in the cursor. I believe you want to Requery("MyCursor") for teh local view to clear it of the curretn status and update it from the original tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform