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:57:27
 
 
To
23/06/2006 10:47:17
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:
01131172
Views:
20
"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