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:09:47
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
23/06/2006 09:50:37
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:
01131133
Views:
14
>Hi all,
>
>In a Finished Goods form, I have a command button set up to allow the user to browse all open orders that we have on file for the part number they're currently viewing. The command button's click event contains the following code:
>
>-----
>returnto=sele()
>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
>
>sele temp
>brow title "Open Orders for this Part Number"
>use
>
>sele(returnto)

The last line is where you got it wrong. Instead of

select (returnto)

it's doing

select(returnto)

which is actually a function returning the workarea of the alias contained in the returnto variable. Just insert a space to make it a command.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform