Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRANSACTIONS and Record Locks
Message
De
29/02/2000 16:32:32
 
 
À
28/02/2000 23:29:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00338662
Message ID:
00339406
Vues:
21
>>I am updating 1050 rcords in a table buffered view...
>>
>
>James, I don't think this situation calls for a buffered update. Consider this code:
>
>scan for iForeign_key <> 100
> replace iForeign_key with 100
>endscan
>
>Run this in the default data session (no buffering) with an error trap. If it doesn't finish properly, then just run it again. You don't need to ROLLBACK.
>
>Peter Robinson

We resolved the problem! The TRANSACTIONS were failing on our older server running Novell 3.11, but when we moved the data to a server running Novell 5.0, everything ran fine. I think this had something to do with file locks as someone previously suggested.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform