Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Order problem on Combox
Message
From
10/05/1998 23:36:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Set Order problem on Combox
Miscellaneous
Thread ID:
00098417
Message ID:
00098417
Views:
58
In my form, there is two combox.
One is Cust_id and the other is Cust_Name.

The Table Customer has those two index.
So, when click CobCust_id, Set the order to Cust_id and search
whereas Click CobCust_Name, Set the order to Cust_Name and search

Problem: after one search and refresh, click other combox will give a Wrong Reference number.
Cust_id:   [L606]
Cust_Name: [Mary Ltd.] 
When click [Mary Ltd.], will see:
Cust_id:   [L606]
Cust_Name: [Mary Ltd.] 
           +Caroline Pacific+
           +Cas...          +
           ......
Which is not starting at [Mary Ltd.]

Similiar, when fix the Cust_name, the click on CUst_id change quite far from expected!
Why?? I have code:
SELECT CUSTOMER
curCust_Name = Cust_Name
SET ORDER TO Cust_Name
LOCATE FOR Cust_Name = curCust_Name  && to ensure fit to the selected one!!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Reply
Map
View

Click here to load this message in the networking platform