Bug 5742

Tabular Datawindows are not displaying SQL information for fields of Data Type Text 13 January, 2021

Rory O'Neill
14 December, 2020
Product: PowerBuilder Category: DataWindow
Version: 2019 R2 Build: 2353
Classification: Publishing: Public
Priority: P2
Status: Analyzing Reason:
Communication Status: Waiting for Appeon
Chris Pollach @Appeon 13 January, 2021
#4
Hi Rory;

  Please provide a small reproducible test case PB App for this issue.

Many thanks in advance!

Regards ... Chris
Rory O'Neill 13 January, 2021
#3
This is a Bug.

From Chris' note "If the TEXT data stream is <32K though, then the Tabular DWO's should work OK", it DOES NOT work. I'm having to change all Tabular Data Windows that have a column which pulls from a SQL Server field with data type of Text. Free Form and Grid Data Windows work okay.
armando herrera @Appeon 11 January, 2021
#2
Hi Rory,

I would like to check with you if the response provided has been helpful enough to resolve your case. If so, can we proceed to close the ticket?. Otherwise, please let us know if we can provide you with any further assistance, remember you can always open another ticket any time you need it.  

Regards!
Chris Pollach @Appeon 14 December, 2020
#1
Hi Rory;

  We have recorded issues with character data coming from SQL Server unless the text length itself exceeds 32K. In that case, your PB App(s) need to treat the TEXT data type as a Blob (or even Clob in Oracle) and issue a SelectBlob command instead to get the full data stream.

  If the TEXT data stream is <32K though, then the Tabular DWO's should work OK but will truncate the text display area once the text exceeds the space provided for the column. In order to see more of the text you would have to either: a) use the AutoSize feature on the column and its related band or b) allow editing and also turn on the AutoHorizontalScroll property.

HTH
Regards ... Chris
Rory O'Neill 14 December, 2020
same as subject: "Tabular Datawindows are not displaying SQL information for fields of Data Type Text". These fields are display okay within Free Form or Grid type Datawindows.
OS:
Windows 10
Platform:
All
Database Type:
Microsoft SQL Server
Database Version:
2017