×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Truncated Strings after inserting into Pervasive tables

Truncated Strings after inserting into Pervasive tables

Truncated Strings after inserting into Pervasive tables

(OP)
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!

RE: Truncated Strings after inserting into Pervasive tables

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

RE: Truncated Strings after inserting into Pervasive tables

(OP)
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.

RE: Truncated Strings after inserting into Pervasive tables

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

RE: Truncated Strings after inserting into Pervasive tables

(OP)
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.

RE: Truncated Strings after inserting into Pervasive tables

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

RE: Truncated Strings after inserting into Pervasive tables

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close