Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
01559442
Message ID:
01559568
Vues:
44
>>>>>>>>Hi
>>>>>>>>
>>>>>>>>I am searhing a file with 100 records on it - all the records are displayed in a grid
>>>>>>>>
>>>>>>>>When my search finds the record i want how do I display it at the top of the grid - and how do I give a dark blue backcolor to the line of the found item
>>>>>>>>
>>>>>>>>Colin
>>>>>>>
>>>>>>>Just put this row first in the order and highlight using dynamic back color and some extra field, say, lFound.
>>>>>>
>>>>>>Thanks but (stupid question) how do I put it first in the order
>>>>>
>>>>>Essentially like this, in pseudocode (if I remember correctly)
>>>>>Yourform.Lockscreen=.T.
>>>>>lnGridHeight=yourgrid.height
>>>>>yourGrid.height=20 && You may have to change this value
>>>>>Locate for whatever
>>>>>yourGrid.height=lnGridHeight
>>>>>Yourform.Lockscreen=.F.
>>>>
>>>>thanks i will try
>>
>>When I try this with this x=code I get aliias grid1 not found - grid1 is my grid on this form
>>
>>thisform.Lockscreen=.T.
>>lnGridHeight=grid1.height
>>grid1.height=20 && You may have to change this value
>>Locate for TRIM(custref)=jjij
>>Grid1.height=lnGridHeight
>>thisform.Lockscreen=.F.
>>
>>Your other idea I didn't understand
>>
>>
>>>
>>>I actually meant something different, but I think this idea may also work. I meant
>>>
>>>select .. order by lFound DESC, other fields
>>>GO TOP
>
>When you refer to the grid you need to use thisform.grid1

Idiot I am Naomi thank you
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform