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.

PB12 using msssql2005 has problems with wide text column in datawindow

2 posts in General Discussion Last posting was on 2013-03-14 13:46:38.0Z
LAS14 Posted on 2013-03-14 01:17:44.0Z
From: "LAS14" <laurels14@hotmail.com>
Newsgroups: sybase.public.powerbuilder.general
Subject: PB12 using msssql2005 has problems with wide text column in datawindow
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3555.308
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <51412538$1@forums-1-dub>
Date: 13 Mar 2013 17:17:44 -0800
X-Trace: forums-1-dub 1363223864 172.20.134.152 (13 Mar 2013 17:17:44 -0800)
X-Original-Trace: 13 Mar 2013 17:17:44 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249929
Article PK: 1308351

In PB9 and PB12, one of our datawindows has a text column whose default
width is 4389 pb units. When data is retrieved it doesn't show in that one
column in PB12, when using a SQL Server 2005 db. It DOES show the data when
using a SQL Server 7 database that was the ancestor of the 2005 one
(basically same data, same table defs, etc). It DOES show the data when
using PB9 on either database. In the db painter the Display Width is 0.000
(or 000.0.... I forget) in both databases.
I've tried making new, simple datawindows containing this column but the
problem persists. Once or twice I was able to see the data in the datawindow
painter but with the left 2 or 3 characters cut off. This was after
narrowing the column control to a manageable width. I think it only happened
when I clicked on the column in the display area. Couldn't reproduce
reliably.
Even though the PB units and Display Width are the same in the working and
non-working environments, the column FEELS way wider in PB12/MSS 2005. That
is, when I select it and ctrl/left arrow to narrow it, I have to wait many
more seconds for the right margin to appear than in the "good" environments.
What determines the default width of a text column in the datawindow
painter? The actual data in both databases is never wider than 20 or 30
characters.

Any thoughts?

TIA
LAS

P.S. - Apologies if this is double posted. I thought I posted it
successfully 9 hours ago, but I don't see it.
Also, I tried to post it on the sac.scn.com site (or whatever it is... may
be misremembering letters), but I got the problem I describe in my response
to Bruce A's "Subase newsgroups EOL - March 28, 2013".


LAS14 Posted on 2013-03-14 13:46:38.0Z
From: "LAS14" <laurels14@hotmail.com>
Newsgroups: sybase.public.powerbuilder.general
References: <51412538$1@forums-1-dub>
In-Reply-To: <51412538$1@forums-1-dub>
Subject: Re: PB12 using msssql2005 has problems with wide text column in datawindow
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="utf-8"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3555.308
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5141d4be$1@forums-1-dub>
Date: 14 Mar 2013 05:46:38 -0800
X-Trace: forums-1-dub 1363268798 172.20.134.152 (14 Mar 2013 05:46:38 -0800)
X-Original-Trace: 14 Mar 2013 05:46:38 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249938
Article PK: 1308363

The problem can be solved by removing the offending column from the SQL
Select datasource and re-adding it. I had removed and re-added from the
display, but that doesn???t do it.

It looks like PB12 fixes a ???bug??? that PB9 wasn???t bothered by. Probably some
klugey work-around instead of an elegant fix???. Which breaks existing
datawindows???.

In PB9, when a text column is added to the SQL Select of a datawindow, its
default width, as shown in the ???column specifications??? is 4099. But if you
select the column in the display, it has a width of 4389. If you narrow the
display, the 4389 figure changes, but the ???column specifications??? doesn???t,
which makes sense. But 4389 is too big for a 4099 width column. I suspect
PB12 coughs on that and PB9 had a work around.

If you create a fresh datawindow, the text column specification shows 32766,
way larger than the default display width of 4389.

I???m afraid I originally erroneously reported that the problem persisted in a
fresh datawindow. I can???t imagine how I experienced that??? But it sent me
down bad paths.

I have no explanation for why this problem happens using a sql server 2005
database, but not with a sql server 7 database, using exactly the same
datawindow.

"LAS14" wrote in message news:51412538$1@forums-1-dub...

In PB9 and PB12, one of our datawindows has a text column whose default
width is 4389 pb units. When data is retrieved it doesn't show in that one
column in PB12, when using a SQL Server 2005 db. It DOES show the data when
using a SQL Server 7 database that was the ancestor of the 2005 one
(basically same data, same table defs, etc). It DOES show the data when
using PB9 on either database. In the db painter the Display Width is 0.000
(or 000.0.... I forget) in both databases.
I've tried making new, simple datawindows containing this column but the
problem persists. Once or twice I was able to see the data in the datawindow
painter but with the left 2 or 3 characters cut off. This was after
narrowing the column control to a manageable width. I think it only happened
when I clicked on the column in the display area. Couldn't reproduce
reliably.
Even though the PB units and Display Width are the same in the working and
non-working environments, the column FEELS way wider in PB12/MSS 2005. That
is, when I select it and ctrl/left arrow to narrow it, I have to wait many
more seconds for the right margin to appear than in the "good" environments.
What determines the default width of a text column in the datawindow
painter? The actual data in both databases is never wider than 20 or 30
characters.

Any thoughts?

TIA
LAS

P.S. - Apologies if this is double posted. I thought I posted it
successfully 9 hours ago, but I don't see it.
Also, I tried to post it on the sac.scn.com site (or whatever it is... may
be misremembering letters), but I got the problem I describe in my response
to Bruce A's "Subase newsgroups EOL - March 28, 2013".