Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Help! Data get truncated

2 posts in PB Infomaker Report Writer Last posting was on 1998-11-05 13:32:29.0Z
Alvie Yap Posted on 1998-11-05 07:08:56.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 05 Nov 1998 15:08:56 +0800
From: Alvie Yap <lvyap@pc.jaring.my>
Organization: Decom Systems Sdn. Bhd.
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
CC: Terry Dykstra <tdykstra@cfol.ab.ca>
Subject: Help! Data get truncated
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 7
Message-ID: <348_36414F07.2EDC1F97@pc.jaring.my>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6778
Article PK: 241764

I encounter this error msg when I'm trying to preview the report.

Select error:SQLSTATE = 01004
[oracle][ODBC Oracle Driver] Data Truncated Column 6

I'm using...
- IM version 5
- Running on Oracle 7.3 RDBMS

Please Help, this is urgent.

Thank you & Regards


Rick Marden Posted on 1998-11-05 13:32:29.0Z
Newsgroups: sybase.public.infomaker.general
From: "Rick Marden" <mardens@cybertours.com>
Subject: Re: Help! Data get truncated
Date: Thu, 5 Nov 1998 08:32:29 -0500
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_YxfFKbLC#GA.164@forums.powersoft.com>
References: <348_36414F07.2EDC1F97@pc.jaring.my>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6777
Article PK: 241763

Has the width of one or more of your columns changed? IM probably still has
the old width stored in the report definition. If so, I find the easiest
way to get around this is to convert the SQL painter to syntax, select all,
cut, and paste the statement back in. This seems to cause IM to look at the
new definition of the DB.

Rick Marden
Primavera Systems, Inc.

Alvie Yap wrote in message <36414F07.2EDC1F97@pc.jaring.my>...
>I encounter this error msg when I'm trying to preview the report.
>
>Select error:SQLSTATE = 01004
>[oracle][ODBC Oracle Driver] Data Truncated Column 6
>
>I'm using...
>- IM version 5
>- Running on Oracle 7.3 RDBMS
>
>Please Help, this is urgent.
>
>Thank you & Regards
>