Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to 'know' current working area has/or not open table
Message
De
16/10/1998 20:18:07
 
 
À
16/10/1998 02:02:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00147372
Message ID:
00147732
Vues:
30
>many command such as skip, afields(), need current working area.
>but how can I know the area is exist table/view/cursor or nothing at all.


I'm not sure exactly what you're asking, but as your english is so much better than my chinese, I will answer what I think you are asking.

1) If you're asking "how can I know there is a table/view/cursor (something) in the current work area" you would issue:
if !empty(alias())
Skip...
else

2) If you are asking "how can I know if the current work area is a table, or a view, or a cursor", use
nFileTytpe=CURSORGETPROP(SourceType)

nFileTytpe=1 Specifies that the data source is a local SQL view.
nFileTytpe=2 Specifies that the data source is a remote SQL view.
nFileTytpe=3 Specifies that the data source is a table.

3) If you're asking "What should I do if I don't know if the table is in the current workarea or if another table is active", try issuing :
Skip in MyWorkArea

I hope this helps. and always remember...
"I know you think you heard what you thought I said, but what you don't understand is that what you thought you heard is not what I think I meant"

jt
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform