Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to 'know' current working area has/or not open table
Message
From
16/10/1998 20:18:07
 
 
To
16/10/1998 02:02:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00147372
Message ID:
00147732
Views:
29
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform