Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
After query, can't reselect original table
Message
From
23/06/2006 10:59:11
 
 
To
23/06/2006 10:57:27
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01131126
Message ID:
01131175
Views:
25
Me too. I'm absolutely stumped by this one. Thanks for trying, though! :)

Anyone else? This one's blowing my mind.

>"It seems as though the rest of the code in the click event is simply being skipped after closing that browse window." This was also what I suspected in the first place, and that's why I asked you to try ctrl-W in stead of Escape, because Escape is interpreted as Cancel. Sorry, I'm out of ideas.
>
>>Not the case. I put "used("fingoods")" in the debugger's watch window, and it's always used.
>>
>>I also put "sele()" in the watch window. Fingoods is still "used" in work area 1, and the cursor is created in work area 8. When I close that window, work area 8 is still selected, even if I put "select fingoods" in the code:
>>
>>
>>seeker=fingoods.part_no
>>
>>sele ord_line.order_no, ord_head.cust_no, customer.cust_name, ord_head.cust_po, ord_line.quantity, ord_line.ship_date;
>> from ord_line, ord_head, customer;
>> where ord_line.order_no=ord_head.order_no;
>>   and ord_head.cust_no=customer.cust_no;
>>   and ord_line.usmc_part=seeker;
>> order by ord_line.order_no;
>> into curs temp nofilter
>>
>>sele temp
>>brow title "Open Orders for this Part Number"
>>use
>>
>>if used("fingoods")
>> sele fingoods
>>else
>> use fingoods in 0
>>endi
>>
>>
>>When I get the error, I can type "select fingoods" in the Command window, type "resume", and the program continues perfectly.
>>
>>It seems as though the rest of the code in the click event is simply being skipped after closing that browse window.
>>
>>>Then it's obvious that FINGOODS simply is closed. You must change that line to USE FINGOODS.
>>>
>>>>Nope. Didn't work. Same problem.
>>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform