Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Marcia Hawkins
  
 Fort Myers
 
 Marcia Hawkins
 To: Adhémar Van Acker
  Where is Adhémar Van Acker?
 Aalter
 Belgium
 Adhémar Van Acker
 Tags
Subject: RE: somebody else
Thread ID: 15732 Message ID: 15743 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Saturday, September 28, 2002 5:46:04 PM         
   


> > > > > > > Hi,
> > > > > > > By clicking the header of a column in a grid I made the order of the records to change according to a given index order. This works perfectly but I want two records to stay on their place, one on top, the other on bottom of the column, whatever the index order is. Is this possible? And if so, how?
> > > > > > > Thanks in advance
> > > > > > > Adhémar Van Acker
> > > > > > One quick solution. You can update the first record with '0' values and last record with 'ZZZZZZ' values if those fields are character type.
> > > > > >
> > > > > > Regards,
> > > > > > Suvi Joseph
> > > > > Sorry, but it has no sense to change the values I want to show. They must show their true values.
> > > >
> > > > Then how can you set the order???? What kind of values you want to show on those records?
> > > > Suvi Joseph
> > >
> > >
> > > They are indexed and are numeric values. The field is called test1 (it iss about test results). So in the header's clickevent I say "Set order to t1". In the table with the different values there is also the maximum test result and the medium test result. I want those two to stay respectively on top and on bottom of the column.
> > > Regards Adhémar
> >
> > I dont know how you can index the table without considering those records. May be someone else can help you out.
> >
> > Suvi Joseph
>
>
> Thanks anyway Joseph.
> Does somebody else have an idea to solve my problem?
> Thanks
> Adhémar
Just add another numeric column and index to the data. Fill in the new column with what is in test1, except for the two records that you want to show diffferently. Fill one in with 0 and the other with 99999999. In the click event of the header of test1, set the order to the new index. I think that will do it.

ENTIRE THREAD

record order within a grid column Posted by Adhemar Van Acker @ 9/28/2002 10:50:11 AM
RE: record order within a grid column Posted by Suvi Joseph @ 9/28/2002 1:00:21 PM
RE: record order within a grid column Posted by Adhemar Van Acker @ 9/28/2002 1:08:22 PM
RE: record order within a grid column Posted by Suvi Joseph @ 9/28/2002 1:56:24 PM
RE: record order within a grid column Posted by Adhemar Van Acker @ 9/28/2002 2:07:29 PM
RE: record order within a grid column Posted by Suvi Joseph @ 9/28/2002 2:30:32 PM
RE: somebody else Posted by Adhemar Van Acker @ 9/28/2002 5:05:44 PM
RE: somebody else Posted by Marcia Hawkins @ 9/28/2002 5:46:04 PM
RE: somebody else Posted by Adhemar Van Acker @ 9/28/2002 6:21:06 PM