General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only