Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
If a table name is a varible ,How to judge it be used()
Message
From
12/06/2002 11:27:42
 
 
To
12/06/2002 11:10:08
Michale Chen
Shijiazhuang ZhiYuan Crop.
Shijiazhuang, China
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00666937
Message ID:
00667425
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
If I understand you correctly, here is an example of how I do it:
SELE 0
USE \profiler\data\control ALIAS ctrl
LOCAL lfile
lfile=ALIAS()
SELE 129 && just an example of moving to a different workarea
if !USED(lfile)
    SELE 0
    USE \profiler\data\control ALIAS ctrl
    wait WINDOW "had to open the table again"
else
    wait WINDOW "table is already in use"
    SELECT (lfile)
endif
Tracy


>Hello Doug:
>Thanks for you help.
>I know you mean,But if the table have been used,And the table name is a varible ,How to judge the table be used state.
>Usually we can do like this:
>if not used('tablealias')
>use table alias 'tablealias' in xx
>else
>sele 'tablealias'
>use
>use table alias 'tablealias' in xx
>endif
>
>sele xx
>But in that case ,What should I do?
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform