| Joan Puchol 2006-03-13, 1:23 pm |
| I Work in dBasePlus with DBF7 files and SET AUTONULLFIELDS OFF
"_XTMK02.DBF" is a empty file and it have the similar structure that "FXTMK02.DBF", but with 74 records, where someone have any fields are full and others fields have blank characters
(ex: NOMABONAT has 25 blank characters, is a field filled with spaces).
I wish to copy the data of FXTMK02 to provisional file WFXINT, with a new structure fields of _XTMK02.
The problem is the command "APPEND FROM datafile REINDEX", because no translate the 25 original blank characters of FXTMK02->NOMABONAT field to WFXINT->NOMABONAT.
Why the result is Null?
I attach practic case in zip.
The language code is:
********************
*****
SET AUTONULLFIELDS OFF
USE _XTMK02 AUTOMEM && empty file, no records
USE
USE FXTMK02
SELECT FXTMK02
GO 65 && record with NOMABONAT field with 25 blank characters
USE
RUN DEL WFXINT.*
COPY TABLE _XTMK02 TO WFXINT TYPE DBASE
SET EXCLUSIVE ON
USE WFXINT IN SELECT(10)
SELECT WFXINT
CONVERT
APPEND FROM FXTMK02 REINDEX
GO 65 && record with NOMABONAT field Null
* NOMABONAT is character field no filled with spaces. Is ERROR, is Null
USE
USE WFXINT IN SELECT(10) && for to Check, new verification
SELECT WFXINT
GO 65 && record with NOMABONAT field Null
* NOMABONAT is character field no filled with spaces. Is ERROR, is Null
USE
SET EXCLUSIVE OFF
********************
*******
Thank you,
Joan Puchol
|