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:
01519546
Views:
28
>>>Hi everybody,
>>>
>>>I use combobox with RowSourceType = 1 - value. However, my value is not shown. Do you know what may be the reason?
>>>
>>>Thanks in advance.
>>
>>What is the Value of the Combo?
>>BoundTo?
>>BoundColimn?
>>How do you add items in this Combo?
>
>I know why I have the problem with the second combo.
>
>The RowSource for the second combo is
>with .colSections.cboSections
>
> .rowsourcetype = 3
> .rowsource = "select * from csrSections where LevelID = ?nLevelID into cursor csrSect"
> .parent.controlsource = 'rsTSBlocks.SectionID'
> endwith
>
>The Level should be the level from the first column selected value. Do you know the correct way to solve the problem? May be I should not try to restrict the sections at all?


Why? You can restrict the user to choose only from right values.

Is csrSections buffered?
Maybe you need:
... from csrSections WITH (BUFFERING=.t.) ...
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