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 10:52:52
 
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:
01092876
Vues:
23
Hi,

1. Oracle XE means Oracle express version like MSSQL Express ver.

2. ALTER TABLE how to use in code-programmatically ...

3. Here is some relevant code:
.....
SELECT 0000 AS RB, &lcFieldList FROM OBJEKT into cursor gg WHERE  &koje  NOFILTER
*
SELECT 0
USE DBF('gg') AGAIN ALIAS  ggsn
go top
SCAN
  _mB = _mB + 1
  replace Rb with _mB
  *
  FOR nCnt = 3 TO FCOUNT()
      IF ISNULL( EVALUATE(FIELD(nCnt)) )
         replace (FIELD(nCnt)) WITH   CTOD("  .  .  ")    &&  TTOD(SYS(4201)) && TTOD(CTOT("/:"))
      ENDIF   
  ENDFOR
  *
  _da=.F.
ENDSCAN
go top
*REPLACE ALL Rb WITH RECNO()
*
_VFP.DATATOCLIP('gg',,3)
*
USE IN ( SELECT("gg") )
USE IN ( SELECT("ggsn") )
*
....
....
....
....
WITH oExcel
     *
     .Range( "C4", .ActiveCell.SpecialCells(11) ).Select
     With  .selection.cells && .Activesheet.UsedRange.Cells
          IF ISNULL(.value) 
             .value = DATE()
          ENDIF   
     Endwith    
ENDWITH
*     
Again:
a) ISNULL does not recognize .NULL. value,
b) EMPTY gives me error with EMPTY(.value),
c) IF .value = ".NULL." gives also error
d) IF I omit code in FOR nCnt ... I get .NULL. in Excel
for empty fields. If I try some variants as visible I get // :: AM.
AND ACCORDING to b) and a) I can't change content !

Regards, Gojko
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform