Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo in grid doesn't show value
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01519540
Message ID:
01519835
Vues:
22
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform