String literals may have at most 255 elements

[xuxugr]

SQL.Add('SELECT PP_DivisionMain.*,pp_halffinishedgoods.*,(CASE WHEN PP_DivisionMain.Status=10 THEN ''未分切'' WHEN PP_DivisionMain.Status=50 THEN ''分切完成'' END) AS 状态 FROM PP_DivisionMain inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'); //排序

怎么办呀

[gzmhero]

字符串太长了，换行相加。

SQL.Clear;

SQL.Text:='SELECT PP_DivisionMain.*,pp_halffinishedgoods.*,(CASE WHEN PP_DivisionMain.Status=10 THEN ''未分切'' WHEN PP_DivisionMain.Status=50 THEN ''分切完成'' END) AS 状态 FROM PP_DivisionMain '+
'inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'

[bruce20062006]

SQL.Add('SELECT PP_DivisionMain.*,pp_halffinishedgoods.*,(CASE WHEN PP_DivisionMain.Status=10 THEN ''未分切'' WHEN PP_DivisionMain.Status=50 THEN ''分切完成'' END) AS 状态')
SQL.Add('FROM PP_DivisionMain inner join pp_halffinishedgoods on PP_DivisionMain.pp_halffinishedgoods_id = pp_halffinishedgoods.id'); //排序