''''+'诊断计划.'+Trim(ComboBox3.Text+''''
解决方案 »
- DELPHI中CHART的标题在哪里修改?
- 大哥哥,大姐姐,动画的图片如何进行点阵(比如在LED屏上显示一只鸟儿在飞)?
- delphi2006控制word2003的域的问题
- DBEdit组件的问题
- 如何修改DELPHI中题目栏中的默认图标
- 简单问题结帐了,再问一个数据库的小问题(200分相送)..........
- 用什么按钮控件可以实现按下去是一种显示,再按一次又是另一种状态,就是许多软件里有的那种!不只是变图案!
- 动态创建已有窗体的副本,停留2s消失
- 一个delphi的 **底层** 问题? 高分求解...
- 如何用DELPHI的TQUERY控件打开access数据库中链接到MS SQL7.0表
- 如何指定表单中某一行获取焦点?
- 新手现遇到一问题,不知道怎么给DBGRID指定域,请大哥大姐过来帮帮忙
' where 诊断计划.'+Trim(ComboBox3.Text)+'='+QuotedStr(Trim(Edit3.Text)); 这样写法就可以了!
Where前面加空格,.字段不能有空格 后面的值要加双引号(等效于QuotedStr)
建議SQL數據庫表關聯級聯語句使用別名,(別名或表名)盡量不要使用中文字段。。尤其是寫在sourcecode中
For example:select *,(select COLDSC from RES_BUYER_CODE where COLCODE=ff.BuyerCode) as ZQ from (
select a.Account_Id,a.full_name,a.zj,a.CB,a.BM,a.KB,a.xb,a.jcrq,a.SF,a.BYXX,a.ZJQF,ltrim(rtrim(a.xl)) as xl,ltrim(rtrim(a.jn)) as jn,a.cbzx,a.sex,a.address,a.sfzno,a.lzr,b.Startdt,b.enddt,b.paramid as id,b.mbid,getdate() as NewDate,
(case ltrim(rtrim(a.zjqf)) when 'D1' then (select max(buyercode) from res_xb where xb=a.xb) else (select BuyerCode From JJ_BC where GH=a.Account_ID) end) as BuyerCode,
(select mb_alias from RES_HTMB where id=b.MBID ) as 'mbname',
(case b.approve when (select ID from RES_HT_Status where id=b.approve) then (select StatusName from RES_HT_Status where id=b.approve) else '' end) as Approve,
(case when EXISTS(select account_id from syqkh where account_id=a.account_id) then (select statusname from res_ht_status where Id=(select khstatus from syqkh e where e.account_id=a.account_id) ) else '未打印' end) as khstatus,
(case when EXISTS(select account_id from syqkh where account_id=a.account_id) then (select statusname from res_ht_status where Id=(select kh from syqkh f where f.account_id=a.account_id) ) else '未考核' end) as kh,dateadd(mm,3,a.jcrq) as khrq1,
(case when EXISTS(select account_id from syqkh where account_id=a.account_id) then (select statusname from res_ht_status where Id=(select DSH from syqkh f where f.account_id=a.account_id) ) else '' end) as DSH,
d.khrq2,('KH'+ CONVERT(nvarchar(50),a.jcrq,112)+ convert(nvarchar(50),a.account_id)) as khbh,
(case b.htstat when (select ID from RES_HT_Status where id=b.htstat) then (select StatusName from RES_HT_Status where id=b.htstat) else '未簽' end) as Htstat,
(case b.htjbzt when (select ID from RES_HT_Status where id=b.htjbzt) then (select StatusName from RES_HT_Status where id=b.htjbzt) else '待簽' end) as htjbzt,
(select TEndDt2 from RES_ht_param where id=b.paramid) as sxr,
b.cdwz from Res_Hrd_Temp a left join RES_HTQD b
on a.Account_Id=b.Usrid left join syqkh d on a.account_id=d.account_id ) ff where isnull(ff.sfzno,'')<>''
and ff.Account_Id not like '9____' and ff.account_id not like '7____' and ff.Account_Id not like '8____'
and (ff.Account_Id not In(select Account_Id from Res_Hrd_Temp where JN='離職' and Account_Id not in (select Usrid from RES_HTQD)))
order by ff.account_id