Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement