Database values being truncated in DW?

[bentleygt]

I have a database field(MSSQL Server 7) with datatype of varchar(3000). My datawindow, when exported, has the column type = chae(3000), edit.limit property = 3000.

The value I have in the database, which I double checked, has about 1000 characters. However, when I retrieve this value/field into the datawindow, the dw only display 255 characters.

What is causing the data field from being truncated?

I'm using PB6.5

 

[mbalent]

If you are using the native drivers, 255 is the limit. You might want to switch to OLE DB drivers to utilize the newer features of MS SQL Server (features since version 6.5).