Returning string from db table to DW using SQL Server

[JuniorS]

Hi, i´d found another post about this case, but no replies. I´ll be glad if anyone could help me.

I have a SQL table which helds a long string(more then 256 chars), I´m using SQL Server db. When the SP retrieves the string on the report I can see only a part of the string not the whole. The variable is defined in the PB as string (1000).
In the Query Analizer when I selected that table for the string first it showed only 256 charter from the string, after I changed it to show 1000 I could see the whole string. Can it be the problem, that SP can pass only 256 char?
PowerBuilder version is 8.0

Thanks the help in advance.

 

[mbalent]

Have you tried to re-create the dw object (rebuild it from the stored proc as if it were new)?

Matt

"Nature forges everything on the anvil of time

 

[JuniorS]

Yes, I had...
Taks Matt.