Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field type is D and value is .null.
Message
From
02/02/2006 07:42:23
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01092558
Message ID:
01092767
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform