Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
After query, can't reselect original table
Message
De
23/06/2006 10:59:11
 
 
À
23/06/2006 10:57:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01131126
Message ID:
01131175
Vues:
26
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.
>>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform