Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field type is D and value is .null.
Message
 
À
02/02/2006 05:20:05
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:
01092791
Vues:
24
Still I do not understand, why do you want to work with NULLs in both, VFP table/cursor, and in Excel.
Either replace NULLs with date() in the cursor, and then copy it to Excel;
or copy it to Excel, and then reformat Excel cells.

1. Having VFP cursor with Time field, use alter table command to alter this field and make it Date type. Then remove NULLs as in example I provided before.

2. If you want in Excel to SHOW the date field BLANK in case there is NULL or // :: AM , then you need to clear cells, like:
WITH objExcel.ActiveSheet.Cells(irow, icol)
  IF isnull(.value) OR;
            (TYPE('.value')="C" and;
	    EMPTY(CHRTRAN(.value,"-/\:","")))
	.clearcontents
   ENDIF
ENDWITH				
>Hi,
>Thanks. I am getting from Oracle table data in cursor.Date type fields are in fact
>datatime fields and I need only date part.
>
>If I just proceed data to Excel for empty fileds I get .NULL. If I first try to
>change in cursor .null. data with TTOD(SYS(4201)) or TTOD(CTOT("/:") or CTOD(" . . ")
>in Excel I am getting // :: AM.
>
>And in Excel I just want empty cell for .NULL. or // :: AM in the whole range from
>cell C3 or D4 to the last one.
>
>Regards, Gojko
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform