Table Conversion and Varchar

[Gergely_Pongracz]

Hi List,
I am trying to write a table conversion writing data into an MS-Access table from a One World table. It seems to work but when I try to write a Varchar field (with anything: input coloumn, variable, literal) it stops the entire conversion. Nothing happens to the access table and I get the following line in jde.log:
TCE009023 - Delimited column DL01 will not fit in the output column.
Current System is Xe on NT Client, W2K Server, SQL2000
Any Ideas?
Regards:
Gergely Pongrácz
Synergon, Hungary

 

[flyingmg]

Gergely,

JDE tables seem always use CHAR type instead of VARCHAR. That is, every f=
ield will be padded with trailing blanks. Could you try to change your MS=
-Access table design by using CHAR instead of VARCHAR? =20

MG
Win2000/SQL2000 =20

----- Original Message -----
From: Gergely_Pongracz
Sent: Thursday, February 07, 2002 8:45 AM
To: [email protected]
Subject: Table Conversion and Varchar

Hi List,
I am trying to write a table conversion writing data into an MS-Access ta=
ble from a One World table. It seems to work but when I try to write a Va=
rchar field (with anything: input coloumn, variable, literal) it stops th=
e entire conversion. Nothing happens to the access table and I get the fo=
llowing line in jde.log:
TCE009023 - Delimited column DL01 will not fit in the output column.
Current System is Xe on NT Client, W2K Server, SQL2000
Any Ideas?
Regards:
Gergely Pongr=E1cz
Synergon, Hungary


--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=3D&Board=3DOWDE=
V&Number=3D28325
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World=AE / XE Developers mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards=AE

+ - - - - - - - - - - - - - - - - - - - - - - - -+Get more from the Web. =
FREE MSN Explorer download : http://explorer.msn.com



G
[email protected]

 

[vbojan]

Hello Gergely,

Varchar should be Zero Terminated String. Check for '/0' terminator and for buffer length (30 or 31).

Hope this helps

Bojan.

 

[Gergely_Pongracz]

Hi!
I found some very interesting new things when continueing work on SP15.1
Here I couldn't map sting or variable string data items to a Varchar field, Table Conversion only accepted data type 17: Character(Blob). I tried to write a business function that converts string to this type but when I generated the typedef of a data structure containing such a field I got the following:

typedef struct tagDSD5505001B
{
char szInputString[81];
INVALID ITEM DATA TYPE: 17 vchOutput;
} DSD5505001B, *LPDSD5505001B;

So it seems that the only data type that can be mapped to varchar cannot be handled in OneWorld. Quite funny.
Has anybody got any new ideas?
Regards:
Gergely Pongrácz
Synergon, Hungary