您好,
显示时压行的问题是由于flash在处理char(13)和char(10)的时候,转换多了一个空行
我修改了- ALTER function [dbo].[fun_GetConno3](@keyid nvarchar(4000))
- returns nvarchar(4000) as
- begin
- DECLARE @STR varchar(8000)
- SELECT @STR=ISNULL(@STR+Char(10),'')+item1
- FROM (SELECT '(CN): '+CAST(isnull(conno,'') as varchar(8000))+
- ' (SN): '+CAST(isnull(seal,'') as varchar(8000))+
- ' '+CAST(isnull(consize,'') as varchar(8000))+
- ''''+CAST(isnull(contype,'') as varchar(8000))+
- ' '+CAST(isnull(ef,'') as varchar(8000))+
- ' CW: '+CAST(isnull(gwgt,0) as varchar(8000))+
- ' NW: '+CAST(isnull(netwgt,0) as varchar(8000))+
- ' TARE: '+CAST(isnull(tarewgt,0) as varchar(8000))+
- ' MEAS: '+CAST(isnull(meas,0) as varchar(8000))+
- ' PKG: '+CAST(isnull(pkgs,0) as varchar(8000))
- +CAST(isnull(pkgunit,'') as varchar(8000)) as item1
- FROM ia_con WHERE ia_con.dockeyid =@keyid)AS T
- return @STR
- end
复制代码
|