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.

DW Update in MS SQL Server Not Working

3 posts in Appeon (partner product) Last posting was on 2008-06-17 18:50:46.0Z
Jim Doyle Posted on 2008-06-14 12:29:24.0Z
Sender: 7c28.4853b755.1804289383@sybase.com
From: Jim Doyle
Newsgroups: sybase.public.appeon
Subject: DW Update in MS SQL Server Not Working
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4853b9a4.7c50.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Jun 2008 05:29:24 -0700
X-Trace: forums-1-dub 1213446564 10.22.241.41 (14 Jun 2008 05:29:24 -0700)
X-Original-Trace: 14 Jun 2008 05:29:24 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2157
Article PK: 21550

DataWindow updates to a SQL Server 2005 database column type
Varchar are padded with extra spaces when applciation is
deployed to Appeon.

The same application running under Client Server works
perfectly well.

Any suggestions please - we are moving to End User testing
with a major app this week and this is a critical Show
Stopper!!!!


steven.yang Posted on 2008-06-16 08:47:39.0Z
Sender: 5c65.485624ad.1804289383@sybase.com
From: Steven.yang
Newsgroups: sybase.public.appeon
Subject: Re: DW Update in MS SQL Server Not Working
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <485628ab.5cb8.1681692777@sybase.com>
References: <4853b9a4.7c50.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Jun 2008 01:47:39 -0700
X-Trace: forums-1-dub 1213606059 10.22.241.41 (16 Jun 2008 01:47:39 -0700)
X-Original-Trace: 16 Jun 2008 01:47:39 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2158
Article PK: 13309

Hi Jim,
According to my test there is no problem on my side. Could
you check your table definition? The column type is varchar
or char?
Could you provide us with the table define scripts in SQL
Server 2005 and datawindow syntax?

Regards,
Steven