Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Modify a value in a grid with Allowactivecell = .F
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01563528
Message ID:
01564997
Vues:
43
If you want to count all records, use COUNT(*).
SELECT COUNT(*) AS lnCnt , 
There's no point to compare a logical value to .T. or .F.. It's logical already
.. SUM( ICASE( lselect  , +1 , 0 )) AS test ;
>
>i understand now...
>
>
>when you lock a grid , the nummer of the column are negatif.
>
>for each grid i must now determine the new properties ncola
>
>
> **** IF lnRelCol = 1		&& column #1
>    * this.ncola doit contenir la valeur booléenne. ( check1 )
>    IF INLIST( lnRelCol , THIS.ncola )
>
>
>
>for total ( for not move the record of the view )
>
>
> CASE lcAction = "S"
>   *!*	   lnCurRecNo = RECNO()
>   *!*	   CALCULATE CNT() TO .nChosenRows IN .RECORDSOURCE FOR EVALUATE(.Column1.Check1.CONTROLSOURCE)
>   *!*	   GO MIN(lnCurRecNo, RECCOUNT())
>
>
>   *!*	   .setAvailableCount()
>     m.nValue = 'lselect = .T. '
>
>   SELECT COUNT( RECNO() ) AS lnCnt , SUM( ICASE( EVALUATE( m.nValue )  , +1 , 0 )) AS test ;
>    FROM ( .RECORDSOURCE ) WITH ( BUFFERING = .T. ) ;
>    WHERE !DELETED() INTO CURSOR temp
>
>   .nChosenRows = temp.test
>
>   .nAvailableRows = temp.lnCnt
>
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform