Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo in grid doesn't show value
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01519540
Message ID:
01519614
Vues:
13
>>>Change WHERE clause in ComboBox rowsource:
>>>
>>>WHERE TheField = ?thisform.nLevelId INTO ...
>>>
>>>and make nLevelId to be a property of the form.
>>
>>Ok, everything seems to work Ok with few problems:
>>
>>1) When I select an item from the combo, it does not display until I navigate out of that column
>
>AFAIK this happens when you have RowSourceType = 6 && Alias
>
>>
>>2) When I add a blank record to the grid, I don't see I added it - may be I should automatically select the first level in the list? Or how can I make another visual clue?
>
>Make RowSource to be:
>
>SELECT DisplayedField, ValueField FROM SomeCursor WHERE LevelId = nLevelId;
>UNION;
>SELECT "Please choose a value", 0 FROM SomeCursor;
>INTO CURSOR cboCrs
>
Good idea. I added setting the first item automatically when I add blank row for now - I think it's OK and they will be smart enough to change if needed.

So, this page almost works, I need to fix another form that I invoke by Edit Block Details button.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform