我的问题是:qry4.LockType := ltBatchOptimistic;qry4的SQL语句是:
select iaa,aa=sum(case ia when 1 then idays end)
,bb=sum(case ib when 2 then idays end)
,cc=sum(case ic when 3 then idays end)
,dd=sum(case id when 4 then idays end)
from a group by iaa当qry4打开后,我想在dbgrid中修改aa,bb,cc,dd(注意了:aa,bb,cc,dd可不是表中的真实字段)中的值,但我post后,数值又变回原来的值了,
郁闷!!!! 解决马上结帐!
select iaa,aa=sum(case ia when 1 then idays end)
,bb=sum(case ib when 2 then idays end)
,cc=sum(case ic when 3 then idays end)
,dd=sum(case id when 4 then idays end)
from a group by iaa当qry4打开后,我想在dbgrid中修改aa,bb,cc,dd(注意了:aa,bb,cc,dd可不是表中的真实字段)中的值,但我post后,数值又变回原来的值了,
郁闷!!!! 解决马上结帐!
對於一個Group By的結果集,你還能怎麼修改呢?
,bb=sum(case ib when 2 then idays end)
,cc=sum(case ic when 3 then idays end)
,dd=sum(case id when 4 then idays end)
from a group by iaa) test