select distinct Number,reporter,reportdate,CAST(comment as Char) as Comment, CAST(response as Char) as response ,Cast(result as Char) as result, reportareaid,reportplace,handled,reporttypeid,handlerid from MobileComplain ,Users Order by ReportDate,Number
说明:Comment,Response,result在表中都是text型,
这个语句在sql server 中执行是没有问题的,但按照下面的方式在Delphi中写就会出错, str :=' select distinct Number,reporter,reportdate,CAST(comment as VarChar(200)) as Comment, '+
' CAST(response as VarChar(200)) as response ,Cast(result as VarChar(200)) as result,'+
' reportareaid,reportplace,handled,reporttypeid,handlerid from MobileComplain Order by Number ';
Sql.Add(str);
Open;
但这条语句会报下面的错误,请各位高手指导一下
---------------------------
移动客户服务管理系统
---------------------------
QueryMobileComplain: Type mismatch for field 'Comment', expecting: Memo actual: String.
---------------------------
确定
---------------------------
说明:Comment,Response,result在表中都是text型,
这个语句在sql server 中执行是没有问题的,但按照下面的方式在Delphi中写就会出错, str :=' select distinct Number,reporter,reportdate,CAST(comment as VarChar(200)) as Comment, '+
' CAST(response as VarChar(200)) as response ,Cast(result as VarChar(200)) as result,'+
' reportareaid,reportplace,handled,reporttypeid,handlerid from MobileComplain Order by Number ';
Sql.Add(str);
Open;
但这条语句会报下面的错误,请各位高手指导一下
---------------------------
移动客户服务管理系统
---------------------------
QueryMobileComplain: Type mismatch for field 'Comment', expecting: Memo actual: String.
---------------------------
确定
---------------------------
但是注意内容不超过CHAR类型的和度1!