Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Bhushan Sahni
  Where is Bhushan Sahni?
 Jabalpur/Mumbai
 India
 Bhushan Sahni
 To: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 Tags
Subject: RE: INCREMENTAL SEARCH BY NAME
Thread ID: 224871 Message ID: 224874 # Views: 36 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, April 16, 2009 8:46:07 AM         
   


> Dear all;
>
> An incremental search button call a pageframe with 2 pages.
>
> Each page has a list.
>
> 1. The first page is ordered by id_no
>
> 2. The second page is ordered by name.
>
>
>
> PROBLEM
>
>
> 1. I have set the activepage on the pageframe to page 2, so that when a user clicks on the button
> focus should be set to the second page of the pageframe.
>
>
> However the list box in the second page which has to order by name is not ordered as expected.
>
>
> I have the following program in the calling button LOSTFOCUS PROCEDURE .
>
>
select vmaster
> index on name tag name
> set order to name
> go top
> 
> 
> THISFORM.PGF1.PAGE2.LIST1.VISIBLE=.T.
> 
> thisform.pgf1.activepage=2

>
>
> QUESTION
>
> What do I need to do in the list box in page2
>
>
> I am running vfp front end sql server backend.
>
> Thanks

Hi,

When are you filling the list. When filling the list you will have to specify the order. For the fiest page you will have to specify the order to ID_NO when filling the list and for second page when you are filling the order you will have to specify the order before filling the list.
Setting the order after filling the list will not serve your purpose.

I hope its clear.

How have you set the control source of the list or you have filled it programatically.

Regards
Bhushan Sahni
Millenium Softwares
bhushan_sahni@yahoo.com

Visual Foxpro a dream house for developers



COMPLETE THREAD
INCREMENTAL SEARCH BY NAME Posted by solomon sackey @ 4/16/2009 8:39:18 AM
RE: INCREMENTAL SEARCH BY NAME Posted by Bhushan Sahni @ 4/16/2009 8:46:07 AM
RE: INCREMENTAL SEARCH BY NAME Posted by Ammar Hadi @ 4/16/2009 9:22:17 AM
RE: INCREMENTAL SEARCH BY NAME Posted by Olaf Doschke @ 4/16/2009 9:34:28 AM
RE: INCREMENTAL SEARCH BY NAME Posted by Anders Altberg @ 4/16/2009 12:37:50 PM