Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo in grid doesn't show value
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01519540
Message ID:
01519612
Views:
16
>>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform