>Hi,
>
>1. Oracle XE means Oracle express version like MSSQL Express ver.

Still cannot see what is here oracle about. In VFP you have a cursor, and you want to work with it. Period. No oracle involved.

>
>2. ALTER TABLE how to use in code-programmatically ...

Do you have VFP HELP? There is a description. Otherwise:

ALTER TABLE cursor_name ALTER column columnname D


>
>3. Here is some relevant code:
>

>.....
>SELECT 0000 AS RB, &lcFieldList FROM OBJEKT into cursor gg WHERE  &koje  NOFILTER
>*
>SELECT 0
>USE DBF('gg') AGAIN ALIAS  ggsn
>go top
>SCAN
>  _mB = _mB + 1
>  replace Rb with _mB
>  *
>  FOR nCnt = 3 TO FCOUNT()
>      IF ISNULL( EVALUATE(FIELD(nCnt)) )
>         replace (FIELD(nCnt)) WITH   CTOD("  .  .  ")    &&  TTOD(SYS(4201)) && TTOD(CTOT("/:"))
>      ENDIF
>  ENDFOR
>  *
>  _da=.F.
>ENDSCAN
>go top
>*REPLACE ALL Rb WITH RECNO()
>*
>_VFP.DATATOCLIP('gg',,3)
>*
>USE IN ( SELECT("gg") )
>USE IN ( SELECT("ggsn") )
>*
>....
>....
>....
>....
>WITH oExcel
>     *
>     .Range( "C4", .ActiveCell.SpecialCells(11) ).Select
>     With  .selection.cells && .Activesheet.UsedRange.Cells
>          IF ISNULL(.value)
>             .value = DATE()
>          ENDIF
>     Endwith
>ENDWITH
>*
>

>
>
>Again:
>a) ISNULL does not recognize .NULL. value,
>b) EMPTY gives me error with EMPTY(.value),
>c) IF .value = ".NULL." gives also error
>d) IF I omit code in FOR nCnt ... I get .NULL. in Excel
> for empty fields. If I try some variants as visible I get // :: AM.
> AND ACCORDING to b) and a) I can't change content !
>
>Regards, Gojko

Too many unknowns:

- with _VFP.Datatoclip you then paste it to the Excel, and using what PASTE option?

- with _VFP.Datatoclip there are two transformations, one - to clipboard, second - from clipboard to Excel; who knows after that what is the actual type of the final data in the date field?
Would be better to use COPY TO ... xls command instead;

- send to me the Excel file, I will see what do you have inside, and how to clear the cells there.


Best Wishes