Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SetAll(
Message
De
28/07/2004 10:16:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SetAll(
Divers
Thread ID:
00928699
Message ID:
00928699
Vues:
80
Can anyone tell me what's wrong with the following "SetAll( "Dynamic.."..." call?

While setting the values - no problem. It's only on .refresh() of the grid, or when I click somewhere in the form that I get the error:
"Expression is invalid.  Use a valid expression for Dynamic..."
and I get it at least twice for each.
Select CENZNFLD		
If SEEK( lnCompID)
    Scan While AP_ID 	= lnAPID ;
         And   AP_FLD_ID 	= lnAPFldID
      lcFieldName	= ALLTRIM( FIELD_NAME)
      lnAPFactor	= AP_FACTOR
      Select csrZVARXACT
      Locate For ALLTRIM( FIELDNAME) = lcFieldName
      If FOUND()
	replace FIELDVAL With lnAPFactor In csrZVARXACT
      Endif 
    Endscan
    With Thisform.grdCenZoneFields
      .SetAll( "DynamicBackColor", "IIF( AP_FACTOR > 0, RGB( 0, 0, 255), RGB( 255, 255, 255))", "Column")  
      .SetAll( "DynamicForeColor", "IIF( AP_FACTOR > 0, RGB( 255, 255, 255), RGB( 0, 0, 255))", "Column")  
    Endwith 
Endif 
As far as I can ascertain the syntax is exactly as in Help, i.e.
frmMyForm.grdGrid1.SetAll("DynamicBackColor", "IIF(MOD(RECNO( ), 2)=0, ;
RGB(255,255,255), RGB(0,255,0))", "Column")  
Thanks

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform