Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Temporary index is not released
Message
De
20/12/2001 11:28:07
 
 
À
20/12/2001 11:22:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00596811
Message ID:
00596820
Vues:
22
John,

To prevent the overwrite question, set safety off:
local lcOldSafety
lcOldSafety = set("safety")
set safety off
index on ...
set safety &lcOldSafety
>Hi,
> I have a cursor in my search form (private datasession), and I index it using INDEX ON ... OF .CDX
>I faced problem that, VFP keep asking me "myindex exist, overwirte?" even though I have close my search form with CLOSE TABLE ALL in unload().
>I tried to ERAS the CDX file when INIT(). It work sometime, but sometime it will return "file access is denied".
>
>How do tell VFP to close/delete the temp CDX after I release my searc form?
>BTW, I am using Macro for my SQL.
>
>Thank you
Steve Gibson
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform