Truncated Strings after inserting into Pervasive tables

[ricolamint]

Hi,

is there anywhere a specialist to give me one hint to fix the following described problem:

I have problems after inserting with my strings in a table. My string was cutted at his end for 1 character.

I was used database manager for pervasive and tried to import my data via import-wizzard and normally inserts are doing the same. What I will do for inserting my strings correctly?

I'm working with WIN XP Prof, Pervasive 9.

Thanx a lot!

 

[mirtheil]

What are the data types for the strings according to the PCC (post the CREATE TABLE script).
How were the tables and Btrieve files were created?
Which character is cut off (the first, the last, somewhere in the middle)?



Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[ricolamint]

Hi Mirtheil,

there only normal CHAR-Fields, exept the column 'BGR' that i have modified over DDF Editor up to String with 339bytes length.

Here is the script from the PPC:

CREATE TABLE "KFZ_BUSCH"(
"VT_ID" BIGINT,
"KD_ID" BIGINT,
"KENNZEICHEN_1" CHAR(8),
"VMT_1" CHAR(12),
"VT_ART_1" CHAR(20),
"ID_1" INTEGER,
"SYS_TIME_1" CHAR(14),
"M_1" CHAR(2),
"KENNUNG_1" CHAR(8),
"SYS_TIME_2" CHAR(14),
"M_2" CHAR(2),
"KENNUNG_2" CHAR(28),
"VT_ART_2" CHAR(8),
"VT_NUMMER_1" CHAR(25),
"VMT_2" CHAR(20),
"VT_ART_3" CHAR(47),
"ID_3" CHAR(156),
"VSN" CHAR(25),
"GES" CHAR(5),
"GESST" CHAR(5),
"VERTRIEB" CHAR(5),
"VERTRIEBSNR" CHAR(25),
"VMT" CHAR(6),
"UNTERVERM2" CHAR(30),
"ART" CHAR(5),
"DUMMY1" CHAR(50),
"RIS" CHAR(40),
"RISIKO2" CHAR(40),
"RISIKO3" CHAR(40),
"RISIKO4" CHAR(40),
"DUMMY2" CHAR(40),
"BEG" CHAR(8),
"ABL" CHAR(8),
"HFL" CHAR(4),
"LFZ" CHAR(2),
"LAUFZEITINFO" CHAR(35),
"OPZ" CHAR(2),
"FKT" CHAR(3),
"STA" CHAR(2),
"AKZ" CHAR(2),
"ABRECHKZ" CHAR(3),
"VVU" CHAR(5),
"VVB" CHAR(35),
"VORVERSKUEND" CHAR(8),
"KUENDDURCH" CHAR(35),
"VORSCHADEN" CHAR(35),
"L12" CHAR(2),
"ZAW" CHAR(1),
"INK" CHAR(1),
"ZAA" CHAR(1),
"RKZ" CHAR(1),
"BEZD" CHAR(8),
"MKZ" CHAR(1),
"KTO" CHAR(35),
"BLZ" CHAR(8),
"KTOINH" CHAR(35),
"BANKINFO" CHAR(35),
"PKF" CHAR(5),
"PKT" CHAR(13),
"WAE" CHAR(3),
"BRT" CHAR(13),
"BRTRECH" CHAR(13),
"NET" CHAR(13),
"BRUTTO" CHAR(20),
"BJB" CHAR(13),
"NJB" CHAR(13),
"VST" CHAR(5),
"ZFZ" CHAR(5),
"GEB" CHAR(6),
"DNP" CHAR(5),
"BGR" CHAR(339),
"ADA" CHAR(8),
"ANTRAGSART" CHAR(40),
"DZD" CHAR(8),
"DA1" CHAR(20),
"DZANVUDAT" CHAR(8),
"MA2" CHAR(20),
"AENDERDAT" CHAR(8),
"EGR" CHAR(35),
"EDA" CHAR(8),
"AENDERINFO" CHAR(35),
"DST" CHAR(8),
"STOGRU" CHAR(40),
"NACHTRAGSDAT" CHAR(8),
"ERSETZT" CHAR(35),
"PORTAL" CHAR(35),
"UEBERTRART" CHAR(35),
"AGES" CHAR(8),
"VGES" CHAR(8),
"VZUR" CHAR(8),
"VERZUR" CHAR(8),
"SBNAME" CHAR(35),
"SBFUNKTION" CHAR(35),
"SACHBETEL" CHAR(35),
"SACHBEFAX" CHAR(35),
"SACHBEMAIL" CHAR(35),
"SACHBEVERT" CHAR(35),
"SCHLFELD" CHAR(35),
"ERST_COURTAGE" CHAR(20),
"FOLGE_COURTAGE" CHAR(20),
"ERST_UVPROF" CHAR(20),
"FOLGE_UVPROV" CHAR(20),
"ERST_DECKUNGSBEITRAG" CHAR(20),
"FOLGE_DECKUNGSBEITRA" CHAR(20),
"INFOLANG1" CHAR(150),
"INFOLANG2" CHAR(150),
"HST" CHAR(35),
"TYP" CHAR(35),
"HSN" CHAR(4),
"TSN" CHAR(3),
"WKZ" CHAR(4),
"FGN" CHAR(35),
"LKW" CHAR(5),
"LCCM" CHAR(5),
"LTONNEN" CHAR(5),
"LSITZE" CHAR(5),
"SKENNVON" CHAR(2),
"SKENNBIS" CHAR(2),
"SKMONATE" CHAR(9),
"ZUL" CHAR(8),
"EBS" CHAR(1),
"ERW" CHAR(8),
"LEASING" CHAR(1),
"LBIS" CHAR(8),
"P01" CHAR(13),
"KUF" CHAR(13),
"P02" CHAR(6),
"MW_ART1" CHAR(35),
"MW_ART2" CHAR(35),
"KMS" CHAR(9),
"WFSSICH" CHAR(1),
"WPSART" CHAR(25),
"P06" CHAR(1),
"SICHAN" CHAR(25),
"AWH" CHAR(35),
"FAH" CHAR(35),
"FSK" CHAR(35),
"FSN" CHAR(35),
"FSD" CHAR(8),
"FSB" CHAR(35),
"RABATTBER" CHAR(35),
"TB28VON" CHAR(35),
"TB28AM" CHAR(8),
"WERKAN" CHAR(1),
"WERKFA" CHAR(30),
"SCHWERBEH" CHAR(35),
"VBDAT" CHAR(8),
"VBGES" CHAR(5),
"VBNR" CHAR(35),
"VBDECK" CHAR(150),
"KML" CHAR(9),
"HNACH1" CHAR(9),
"VNACH1" CHAR(9),
"TNACH1" CHAR(9),
"NVM" CHAR(30),
"HNACH2" CHAR(9),
"VNACH2" CHAR(9),
"TNACH2" CHAR(9),
"NF2" CHAR(40),
"HNACH3" CHAR(9),
"VNACH3" CHAR(9),
"TNACH3" CHAR(9),
"NAP" CHAR(50),
"HNACH4" CHAR(9),
"VNACH4" CHAR(9),
"TNACH4" CHAR(9),
"FAHRZALT" CHAR(50),
"HNACH5" CHAR(9),
"VNACH5" CHAR(9),
"TNACH5" CHAR(9),
"RABSONST1" CHAR(30),
"RABART1" CHAR(50),
"HNACH6" CHAR(9),
"VNACH6" CHAR(9),
"TNACH6" CHAR(9),
"RABSONST2" CHAR(30),
"RABART2" CHAR(50),
"HNACH7" CHAR(9),
"VNACH7" CHAR(9),
"TNACH7" CHAR(9),
"RABSONST3" CHAR(30),
"RABART3" CHAR(50),
"HNACH8" CHAR(9),
"VNACH8" CHAR(9),
"TNACH8" CHAR(9),
"RABSONST4" CHAR(30),
"RABART4" CHAR(50),
"HNACH9" CHAR(9),
"VNACH9" CHAR(9),
"TNACH9" CHAR(9),
"RABSONST5" CHAR(30),
"RABART5" CHAR(50),
"HNACH10" CHAR(9),
"VNACH10" CHAR(9),
"TNACH10" CHAR(9),
"JUEFAHR" CHAR(35),
"GEBJUEFA" CHAR(8),
"GJFA" CHAR(2),
"AELTFAHR" CHAR(35),
"GEBAELTFA" CHAR(8),
"GAFA" CHAR(2),
"GEBJK" CHAR(8),
"GBJKA" CHAR(2),
"GEBAK" CHAR(8),
"GEBAKA" CHAR(2),
"SONINFO1" CHAR(20),
"INFORAB1" CHAR(35),
"SONINFO2" CHAR(20),
"INFORAB2" CHAR(35),
"SONINFO3" CHAR(20),
"INFORAB3" CHAR(35),
"SONINFO4" CHAR(20),
"INFORAB4" CHAR(35),
"SONINFO5" CHAR(20),
"INFORAB5" CHAR(35),
"KREUZBEIJAHRH" CHAR(1),
"KREUZBEIZAHLH" CHAR(1),
"KREUZBEIBRUTTOH" CHAR(1),
"HJN" CHAR(1),
"HAFJN" CHAR(4),
"VKJ" CHAR(1),
"VKJN" CHAR(4),
"TKJ" CHAR(1),
"FELD359" CHAR(4),
"DSU" CHAR(30),
"TKH" CHAR(2),
"TAH" CHAR(6),
"SH1" CHAR(3),
"P24" CHAR(2),
"SF2" CHAR(5),
"TBTRKH" CHAR(13),
"TBTRKHIND" CHAR(13),
"RABZUPROZH" CHAR(6),
"RABPROZH" CHAR(13),
"RABABSOH" CHAR(13),
"RABZUH" CHAR(30),
"RABZUEURH" CHAR(13),
"HSU" CHAR(13),
"TARIFKH" CHAR(20),
"TAKO" CHAR(25),
"AKBKH" CHAR(8),
"AKBKO" CHAR(25),
"TBDATUMH" CHAR(8),
"TBDKO" CHAR(25),
"VSBVKV" CHAR(5),
"VSBTKV" CHAR(5),
"TKV" CHAR(2),
"TAV" CHAR(4),
"SV1" CHAR(3),
"P43" CHAR(2),
"SF3" CHAR(5),
"TBTRKV" CHAR(13),
"TBTRKVIND" CHAR(13),
"RABZUPROZVK" CHAR(6),
"RABPROZVK" CHAR(13),
"RABABSOVK" CHAR(13),
"RABZUVK" CHAR(30),
"RABZUEURVK" CHAR(13),
"KSV" CHAR(13),
"TARIFKV" CHAR(8),
"TAKOM" CHAR(25),
"AKBKV" CHAR(8),
"AKBKOM" CHAR(25),
"TBDATUMVK" CHAR(8),
"VKTBKOM" CHAR(25),
"SBT" CHAR(5),
"TKT" CHAR(2),
"TAT" CHAR(4),
"BEISATZTK" CHAR(3),
"GRUNDJAHRTK" CHAR(2),
"SFKLASSETK" CHAR(5),
"TBTRKTIND" CHAR(13),
"TBTRKT" CHAR(13),
"RABZUPROZTK" CHAR(6),
"RABPROZTK" CHAR(13),
"RABABSOTK" CHAR(13),
"RABZUTK" CHAR(30),
"RABZUEURTK" CHAR(13),
"KST" CHAR(13),
"TARIFKT" CHAR(20),
"TAKOMM" CHAR(25),
"AKBKT" CHAR(8),
"ABKOMM" CHAR(25),
"TBDATUMTK" CHAR(8),
"TKTBKOMM" CHAR(25),
"KREUZSBKEINER" CHAR(1),
"KREUZSBEIGEN" CHAR(1),
"KREUZSBH" CHAR(1),
"KREUZSBVK" CHAR(1),
"KREUZSBTK" CHAR(1),
"KREUZSBENTH" CHAR(1),
"KREUZSBSEP" CHAR(1),
"TBTRSB" CHAR(13),
"RABZUPROZSB" CHAR(6),
"RABPROZSB" CHAR(13),
"RABABSOSB" CHAR(13),
"BEITRAGSB" CHAR(13),
"IUART" CHAR(30),
"INV" CHAR(15),
"MITML" CHAR(1),
"MITPROG" CHAR(1),
"PROG" CHAR(4),
"TOD" CHAR(15),
"KHTG" CHAR(15),
"MGEN1" CHAR(1),
"KTG" CHAR(15),
"P78" CHAR(15),
"TBTRKU" CHAR(13),
"RABZUPROZIU" CHAR(6),
"RABPROZIU" CHAR(13),
"RABABSOIU" CHAR(13),
"RABZUIU" CHAR(30),
"RABZUEURIU" CHAR(13),
"USU" CHAR(15),
"TARIFIU" CHAR(20),
"TUK" CHAR(25),
"AKBIU" CHAR(20),
"AKBUK" CHAR(25),
"TBDATUMIU" CHAR(20),
"TBK" CHAR(25),
"SONSTBEZ" CHAR(30),
"SONSTART" CHAR(300),
"TBTRSONST" CHAR(13),
"RABZUPROZSONST" CHAR(6),
"RABPROZSONST" CHAR(13),
"RABABSOLUSONST" CHAR(13),
"RABZUSONST" CHAR(30),
"RABZUEURSONST" CHAR(13),
"BEITRAGSONST" CHAR(13),
"TARIFSONST" CHAR(20),
"TUKO" CHAR(25),
"AVBSONST" CHAR(8),
"AVBKO" CHAR(25),
"TBDATUMSONST" CHAR(8),
"TBKO" CHAR(25),
"GEPART" CHAR(30),
"Q04" CHAR(15),
"GEPERL" CHAR(250),
"TBTRGEP" CHAR(13),
"RABZUPROZGEP" CHAR(6),
"RABPROZGEP" CHAR(13),
"RABABSOLUGEP" CHAR(13),
"RABZUGEP" CHAR(30),
"RABZUEURGEP" CHAR(13),
"Q05" CHAR(13),
"TARIFGEP" CHAR(8),
"TGK" CHAR(25),
"AVBGEP" CHAR(8),
"AVBKOM" CHAR(25),
"TBDATUMGEP" CHAR(8),
"TBKOM" CHAR(25),
"INDI9" CHAR(300),
"DUMMY10" CHAR(80),
"DUMMY20" CHAR(80),
"DUMMY3" CHAR(80),
"DUMMY4" CHAR(80),
"DUMMY5" CHAR(80),
"DUMMY6" CHAR(80),
"GESBEIH" CHAR(13),
"GESBEIVK" CHAR(13),
"GESBEITK" CHAR(13),
"GESBEISB" CHAR(13),
"GESBEIIU" CHAR(13),
"GESBEIBEZSONST" CHAR(30),
"GESBEISONST" CHAR(13),
"GESBEIGEP" CHAR(13),
"GESAMTBEITRAG" CHAR(13),
"HNACHSUM" CHAR(9),
"VNACHSUM" CHAR(9),
"TNACHSUM" CHAR(9),
"HNACHKOR" CHAR(9),
"VNACHKOR" CHAR(9),
"TNACHKOR" CHAR(9),
"LEER_99" CHAR(1),
"KDR" INTEGER
);
CREATE NOT MODIFIABLE INDEX "key0" ON "KFZ_BUSCH"("VT_ID");

The BTR-File was created by an application in Version 6.X. And I was made the DDF-informations by using the Btsearch32-tool. So after this I was made create-table-statements for all my other tables like the statement before.

Characters will be cutted at the end of the string and leave this blank.

Any idea?

Thx for your help!

Rico.

 

[mirtheil]

Can you post a BUTIL -STAT report of the actual Btrieve file?
Also, are these files you've created or are they created by a third party application? If it's a third party application, have you contatacted them for DDFs?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[ricolamint]

Hi Mirtheil,

here is the statistic of my Btrieve-File:


Btrieve Maintenance Utility 9.10.020.000
Copyright (C) Pervasive Software Inc. 2005
All Rights Reserved.

File Statistics for VT_DATA.BTR

File Version = 6.00
Page Size = 2048
Page Preallocation = No
Key Only = No
Extended = No

Total Number of Records = 335
Record Length = 4889
Data Compression = Yes
Variable Records = No
Free Space Threshold = 5%

Available Linked Duplicate Keys = 0
Balanced Key = No
Log Key = 0
System Data = No
Total Number of Keys = 12
Total Number of Segments = 17

Key Position Type Null Values* ACS
Segment Length Flags Unique Values
0 1 1 4 Integer M -- 335 --
1 1 5 4 Integer MD -- 1 --
1 2 123 2 Integer MD -- 1 --
1 3 129 8 String MD -- 1 --
2 1 17 8 String MD -- 1 --
2 2 37 20 String MD -- 1 0
3 1 9 4 Integer MD -- 180 --
3 2 123 2 Integer MD -- 180 --
3 3 129 8 String MD -- 180 --
10 1 137 25 String RMD 20L 0 0
11 1 162 20 String RMD 20L 0 0
12 1 182 8 String RMD 20L 0 0
13 1 190 3 String RMD 20L 0 0
14 1 193 5 String RMD 20L 0 0
15 1 198 12 String RMD 20L 0 0
16 1 210 8 String RMD 20L 0 0
17 1 218 20 String RMD 20L 0 0

Alternate Collating Sequence(ACS) List:
0 GERSORT

Legend:
< = Descending Order
D = Duplicates Allowed
I = Case Insensitive
M = Modifiable
R = Repeat Duplicate
A = Any Segment (Manual)
L = All Segments (Null)
* = The values in this column are hexadecimal.
?? = Unknown
-- = Not Specified

The command completed successfully.

The file are from a 3rd-party-app. There is no way to get the DDF's from the programmers side of the application. So I had to be created the DDF's on my own.

Could you see any things clearer of my problem?

Best regards, Rico.

 

[mirtheil]

So let me make sure I understand. You are inserting data and the last character is missing after the insert. Is that correct? Does this occur on every string field or only certain string fields. If it's only certain fields, what fields?
Can you post an Insert statement and then what it puts in the field?
Why is there "no way to get the DDF's from the programmers side"? Are they refusing to give you DDFs?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[ricolamint]

Hi,

here is an insert for testing:

INSERT INTO FOR_EXP_KFZ ( VT_ID, KD_ID, KENNZEICHEN_1, VMT_1, VT_ART_1, ID_1, SYS_TIME_1, M_1,KENNUNG_1, SYS_TIME_2, M_2, KENNUNG_2, VT_ART_2, VT_NUMMER_1, VMT_2, VT_ART_3, ID_3, VSN, GES,GESST, VERTRIEB, VERTRIEBSNR, VMT, UNTERVERM2, ART, DUMMY1, RIS, RISIKO2, RISIKO3, RISIKO4, DUMMY2,BEG, ABL, HFL, LFZ, LAUFZEITINFO, OPZ, FKT, STA, AKZ, ABRECHKZ, VVU, VVB, VORVERSKUEND, KUENDDURCH,VORSCHADEN, L12, ZAW, INK, ZAA, RKZ, BEZD, MKZ, KTO, BLZ, KTOINH, BANKINFO, PKF, PKT, WAE, BRT,BRTRECH, NET, BRUTTO, BJB, NJB, VST, ZFZ, GEB, DNP, BGR, ADA, ANTRAGSART, DZD, DA1, DZANVUDAT, MA2,AENDERDAT, EGR, EDA, AENDERINFO, DST, STOGRU, NACHTRAGSDAT, ERSETZT, PORTAL, UEBERTRART, AGES, VGES,VZUR, VERZUR, SBNAME, SBFUNKTION, SACHBETEL, SACHBEFAX, SACHBEMAIL, SACHBEVERT, SCHLFELD,ERST_COURTAGE, FOLGE_COURTAGE, ERST_UVPROF, FOLGE_UVPROV, ERST_DECKUNGSBEITRAG,FOLGE_DECKUNGSBEITRA, INFOLANG1, INFOLANG2, HST, TYP, HSN, TSN, WKZ, FGN, LKW, LCCM, LTONNEN,LSITZE, SKENNVON, SKENNBIS, SKMONATE, ZUL, EBS, ERW, LEASING, LBIS, P01, KUF, P02, MW_ART1, MW_ART2,KMS, WFSSICH, WPSART, P06, SICHAN, AWH, FAH, FSK, FSN, FSD, FSB, RABATTBER, TB28VON, TB28AM, WERKAN,WERKFA, SCHWERBEH, VBDAT, VBGES, VBNR, VBDECK, KML, HNACH1, VNACH1, TNACH1, NVM, HNACH2, VNACH2,TNACH2, NF2, HNACH3, VNACH3, TNACH3, NAP, HNACH4, VNACH4, TNACH4, FAHRZALT, HNACH5, VNACH5, TNACH5,RABSONST1, RABART1, HNACH6, VNACH6, TNACH6, RABSONST2, RABART2, HNACH7, VNACH7, TNACH7, RABSONST3,RABART3, HNACH8, VNACH8, TNACH8, RABSONST4, RABART4, HNACH9, VNACH9, TNACH9, RABSONST5, RABART5,HNACH10, VNACH10, TNACH10, JUEFAHR, GEBJUEFA, GJFA, AELTFAHR, GEBAELTFA, GAFA, GEBJK, GBJKA, GEBAK,GEBAKA, SONINFO1, INFORAB1, SONINFO2, INFORAB2, SONINFO3, INFORAB3, SONINFO4, INFORAB4, SONINFO5,INFORAB5, KREUZBEIJAHRH, KREUZBEIZAHLH, KREUZBEIBRUTTOH, HJN, HAFJN, VKJ, VKJN, TKJ, FELD359, DSU,TKH, TAH, SH1, P24, SF2, TBTRKH, TBTRKHIND, RABZUPROZH, RABPROZH, RABABSOH, RABZUH, RABZUEURH, HSU,TARIFKH, TAKO, AKBKH, AKBKO, TBDATUMH, TBDKO, VSBVKV, VSBTKV, TKV, TAV, SV1, P43, SF3, TBTRKV,TBTRKVIND, RABZUPROZVK, RABPROZVK, RABABSOVK, RABZUVK, RABZUEURVK, KSV, TARIFKV, TAKOM, AKBKV,AKBKOM, TBDATUMVK, VKTBKOM, SBT, TKT, TAT, BEISATZTK, GRUNDJAHRTK, SFKLASSETK, TBTRKTIND, TBTRKT,RABZUPROZTK, RABPROZTK, RABABSOTK, RABZUTK, RABZUEURTK, KST, TARIFKT, TAKOMM, AKBKT, ABKOMM,TBDATUMTK, TKTBKOMM, KREUZSBKEINER, KREUZSBEIGEN, KREUZSBH, KREUZSBVK, KREUZSBTK, KREUZSBENTH,KREUZSBSEP, TBTRSB, RABZUPROZSB, RABPROZSB, RABABSOSB, BEITRAGSB, IUART, INV, MITML, MITPROG, PROG,TOD, KHTG, MGEN1, KTG, P78, TBTRKU, RABZUPROZIU, RABPROZIU, RABABSOIU, RABZUIU, RABZUEURIU, USU,TARIFIU, TUK, AKBIU, AKBUK, TBDATUMIU, TBK, SONSTBEZ, SONSTART, TBTRSONST, RABZUPROZSONST,RABPROZSONST, RABABSOLUSONST, RABZUSONST, RABZUEURSONST, BEITRAGSONST, TARIFSONST, TUKO, AVBSONST,AVBKO, TBDATUMSONST, TBKO, GEPART, Q04, GEPERL, TBTRGEP, RABZUPROZGEP, RABPROZGEP, RABABSOLUGEP,RABZUGEP, RABZUEURGEP, Q05, TARIFGEP, TGK, AVBGEP, AVBKOM, TBDATUMGEP, TBKOM, INDI9, DUMMY10,DUMMY20, DUMMY3, DUMMY4, DUMMY5, DUMMY6, GESBEIH, GESBEIVK, GESBEITK, GESBEISB, GESBEIIU,GESBEIBEZSONST, GESBEISONST, GESBEIGEP, GESAMTBEITRAG, HNACHSUM, VNACHSUM, TNACHSUM, HNACHKOR,VNACHKOR, LEER_99 ) VALUES ( 4, 317, '$', '001', 'KFZ', 1, '20051103074236', 'M', 'ADMIN', '20051103074236', 'M', 'ADMIN', 'KFZ', '13810247615', '9999', 'KFZ', '011000', '13810247615', '00002', NULL, NULL, NULL, '001', NULL, '010', NULL, 'S-WS 1200', 'Wolfgang', 'DK085423 AL 220202', NULL, NULL, '20020308', '20060225', '2502', '4', NULL, 'E', '402', 'A', '01', 'A', NULL, NULL, NULL, NULL, NULL, '01', '4', '1', '1', '0', '20040801', '1', '2455433', '60050101', NULL, NULL, '0,00', '868,40', 'EUR', '251,84', '0000000000000', '251,84', 'netto', '1.007,3', '0000000000000', '16,00', '0,00', '0,00', '0,00', '217,10', '20020405', 'Fax', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Sachbearbeiter', NULL, NULL, NULL, NULL, NULL, '23,88', '23,88', '0,00', '0,00', '23,88', '23,88', NULL, NULL, NULL, '210', '0710', '319', '112', 'WDB2100811X052372', '150', '00000', '0,0', '00000', NULL, NULL, '0 Monate', '19020307', 'N', NULL, 'N', NULL, '43460', '0,00', '0', NULL, NULL, '0', 'J', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, NULL, '0', '000000000', '000000000', '000000000', NULL, '000000000', '000000000', '000000000', 'N', '000000000', '000000000', '000000000', 'G', '000000000', '000000000', '000000000', NULL, '000000000', '000000000', '000000000', NULL, NULL, '000000000', '000000000', '000000000', NULL, NULL, '000000000', '000000000', '000000000', NULL, NULL, '000000000', '000000000', '000000000', NULL, NULL, '000000000', '000000000', '000000000', NULL, NULL, '000000000', '000000000', '000000000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'J', 'J', NULL, NULL, NULL, NULL, NULL, NULL, 'unbegr.', '19', 'N5', '30', '82', 'SF30', '230,38', '0000000000000', '000000', '0000000000000', '0000000000000', NULL, '0000000000000', '0000000000000', NULL, NULL, NULL, NULL, NULL, NULL, '300', NULL, '27', 'N6', '35', '89', 'SF14', '465,39', '0000000000000', '000000', '0000000000000', '0000000000000', NULL, '0000000000000', '0000000000000', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, '100', '00', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '61', NULL, NULL, NULL, '31', '0', NULL, '0', NULL, '19,84', NULL, NULL, NULL, NULL, NULL, '19,84', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

By the way: It seems so that strings are truncated with whole numeric characters in it. By strings with letters or symbolics it seems so that it works.

I'm asked the producer of the app for the DDF. They are not amused about this ;-).

Rico.