Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 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: 224907 # Views: 41 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, April 16, 2009 12:37:50 PM         
   


> 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

Use two different views or query results as RowSource.
Then you can fix the column order and the ORDER BY clauses to fit the ListBox.

If you want to run some code to run when ActivePage changes, put that code in the Activate event of the new page, or in the UIEnable event of a control on the activated page.
-Anders



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