Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field type is D and value is .null.
Message
 
À
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:
01092847
Vues:
22
>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 ... )


What is the code that gives the error?



>
>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.


It does not matter how do you collect data into cursor. What do you mean,
" copy to clippboard and then to 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)
>

What do you mean, "I am working with Oracle XE"? What is here Oracle about?
To clear content of the Excel cell use Excel.Automation from VFP following example that I provided previously

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

Are you in ORACLE or in VFP? In VFP use ALTER TABLE command.

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

Click here to load this message in the networking platform