Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Why?
Divers
Thread ID:
00676027
Message ID:
00676548
Vues:
8
I've run into this with views used in a search form (indexes were created for searching purposes) and even though that form gets closed, that error message would pop up when a transaction was started for the user trying to update the record they just searched for. My only suggestion is to issue the CLEAR INDEXES command after using the views, which works for the app in question, but I do not know why it happens.

Steve

>In a form i use 3 views. In DE I set .NoDataOnLoad = .t. for all of them.
>In Init method I indexing & requering them:
>
>SELECT NuNch
>INDEX ON Egn + STR(Kod,3) TAG NuI OF NuNch
>CURSORSETPROP("Buffering", 5, "NuNch")
>SET ORDER TO NuI
>Requery("NuNch")
>
>SELECT StorView
>INDEX ON Egn+STR(God,4)+STR(Mes,2)+STR(Kod,3)+STR(Shem,2)+STR(Fund,2) TAG Storno OF StorView
>CURSORSETPROP("Buffering", 5, "StorView")
>SET ORDER TO Storno
>Requery("StorView")
>
>SELECT KadView
>INDEX ON LEFT(Key,4)+Unicum TAG KadView OF KadView
>INDEX ON Key TAG KadKey OF KadView
>CURSORSETPROP("Buffering", 5, "KadView")
>SET ORDER TO KadView
>Requery("KadView")
>
>
>I do some calculations & when I try to write them back to disk:
>
>BEGIN TRANSACTION
>   SELECT StorView
>   TableUpdate(.t.)
>
>   SELECT KadView
>   TableUpdate(.t.)
>
>   SELECT NuNch
>   TableUpdate(.t.)
>END TRANSACTION
>
>I got always the same error:
>Table KadView has one or more non-structural indexes open. Please close them and retry the Begin Transaction (Error 1548)
>
>Why?
>Why not for all of views? I am not indexing the KadView anymore but the Init method.
>
>
>TIA
>Boris
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform