Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field type is D and value is .null.
Message
De
02/02/2006 07:42:23
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01092558
Message ID:
01092767
Vues:
17
Hi,
Another thing; I found the way to change values in selected range but Excel does not recognize Empty ...
IF EMPTY(.value) OR ISNULL(.value)
   .value=DATE()
ENDIF
and ISNULL does not recognize cell value ".NULL." as .null.
WITH oExcel
     *
     .Range( "C4", .ActiveCell.SpecialCells(11) ).Select
     With  .selection.cells 
          IF ISNULL(.value) 
             .value = DATE()
          ENDIF   
     Endwith
     *    
ENDWITH
and if I try:
IF  .value = ".NULL."
then I am getting error of invalid operator ... Any help ?
Regards, Gojko
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform