Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo in grid doesn't show value
Message
 
 
To
01/08/2011 14:47:56
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:
01519835
Views:
21
>>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.

I think I need to try resetting record source to '' and then setting it again instead.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform