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:
01519836
Views:
24
>>>BTW, your sample form does not work correctly either. Say, you have right now Level2 and Section 6 (for example). You change the level to something that doesn't include this section, but the section doesn't change.
>>
>>Just put:
>>thisform.Refresh() in InteractiveChange event of the Level combo.
>
>I think I have a bigger poblem in my case. I didn't want to re-build the grid, so I'm trying this code:
>
>
> =tablerevert(.t.,'rsTSBlocks') && Everything we wanted to save should be already saved
>      =cursorsetprop('Buffering', 3,'rsTSBlocks')
>      private nTemplateID, nBlockCount
>      nBlockCount = 0
>      nTemplateID = thisform.oCurrentNode.values("TemplateID").value
>      =mySQLExec("execute dbo.siriussp_rsGetBlocks @TemplateID = ?m.nTemplateID, @BlocksCount = ?@nBlockCount OUTPUT" , 'rsTSBlocksTemp',program())
>
>      zap in rsTSBlocks
>      =cursorsetprop('Buffering', 5,'rsTSBlocks')
>     
>       make_view_updatable('rsTSBlocks',5)	    
>      insert into rsTSBlocks ;
>         select * from rsTSBlocksTemp     
>     
>      use in select('rsTSBlocksTemp')
>      select rsTSBlocks
>      llReturn = thisform.SetBlocksPage(m.nBlockCount)
>
>Unfortunately, this whole idea is wrong and not going to work. The problem is that the records are going to be treated as newly inserted.
>


How about:
...
make_view_updatable('rsTSBlocks',5)	    
insert into rsTSBlocks ;
select * from rsTSBlocksTemp     
CURSORSETPROP("SendUpdates", .f., "rsTSBlocks")
TABLEUPDATE(1, .t., "rsTSBlocks")
CURSORSETPROP("SendUpdates", .t., "rsTSBlocks")
>I think I need to try resetting record source to '' and then setting it again instead.
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