Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6 How to detect a table in use by views
Message
 
À
03/10/2004 18:24:30
Michael Ouellette
Australian Technical Services (VIC) Pty
Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00948339
Message ID:
00948357
Vues:
19
Hi Michael

Thanks for the code. I will try it out and trouble you again if I have any quries.

>When my users run the menu option to reindex/pack tables I shut down all open forms. Each form prompts to save.
>
>If Messagebox("This procedure WILL shut down all unnecessary windows. Do you wish to continue?",20,"Warning") = 6
>* let's attempt to close all windows
> x = 0
> Do While !Inlist(Wontop(),"SPLASH")
> x = x+1
> _Screen.ActiveForm.Release()
> x = x-1
> Enddo
>If !Inlist_Screen.ActiveForm.Name, ;
> "MainData", "FrmMailings", "ProcessOrdersForm")
> Close Data
> Do Form Forms\reindexmover
>Else
> =Messagebox("I cannot close all windows. You must manually close all open forms/screens to reindex, try again...",20,"Warning")
> Endif
>
>Endif
>Cheerio
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform