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 09:31:08
 
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:
01092815
Vues:
23
Hi,

1. How should I test cell.value for ".NULL." as text/string value; not .null. ?!
( for me IF ISNULL(.value) does not recognize .null. so I tried if it can recognize it
as text, but then I get error of invalid operand ... )

2. For now I SELECT some fields from ORACLE table all of which are datetime and then
copy to clippboard and then to Excel. For empty values I get .NULL. in Excel. If I try
first to change content of fileds to date ( as explained previously ) I am getting
// :: AM in Excel. AND I WANT JUST empty cell !. (in what either way !)
( I am working with Oracle XE)

3. How should I alter field type from datetime in date "on the fly" ?

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

Click here to load this message in the networking platform