Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement