Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Close and reopen tables
Message
 
 
À
16/05/2001 21:16:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00508164
Message ID:
00508187
Vues:
21
>Hi, all
>
>I have in DE 1 DBC and 4 tables, in my form i need to have a buttom to import some data from outlook, i need to close 2 tables (categories and contacts) to zap, and then import the data, the problem is that, what is the way to reopen the tables?
>
>my code,
>
with thisform
>	close tables all
>	set exclusive on
>	use  categories
>
>	zap
>	.getcategories()
>	
>	use terceiros
>	zap
>	c_cat='ALL'
>	.findcontacts(allt(c_Cat))
>	close tables all
>
>	set exclusive off
>	
>	use categorias shared	---> Cannot access table
>	use terceiros shared
>	select categorias
>
>
>Thank's in advance
>
Hi João,

In addition to Barbara's advice: you got your categories table misspelled.
I would do
use in select('categories')
use categories shared in 0
use in select('terceiros')
use terceiros shared
Actually, I don't use "USE" command directly in my code, I use my wrapper UDF instead called OpenTble. Just search by OpenTble here and you find a thread, where I list this function code.

HTH
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform