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:
01519549
Views:
26
>>>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.) ...
>>
>
>No, this cursor is not buffered. BTW, I removed the where part and the problem was solved (well, I guess I will need to apply filter in got focus to only show sections for the current level).
>
>Anyway, the last column's problem still remains.

I don't see where nLevelID is initialized!
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform