DBGRID中最后加上一条临时记录怎么取值?
例如:表里的内容是Query1.sql.add('select name sl from abc where sl=0');
我想在最后显示sum(sl)
sql语句应该怎么写?才能到表格的最后面加上这条统计结果?
例如:表里的内容是Query1.sql.add('select name sl from abc where sl=0');
我想在最后显示sum(sl)
sql语句应该怎么写?才能到表格的最后面加上这条统计结果?
调试欢乐多
例如:表里的内容是Query1.sql.add('select name sl from abc where sl=0');
我想在最后显示sum(sl)
sql语句应该怎么写?才能到表格的最后面加上这条统计结果?Select name, s1 From abc Where ...
union
Select '合计' as name, Sum(s1) as s1 From abc Where ...
title怎么才能点击?直接在OnTitleClick事件里写代码,他就能点击了吗?这三句:
Select name, s1 From abc Where ...
union
Select '合计' as name, Sum(s1) as s1 From abc Where ...我应该在哪个事件里添加这条合计记录呢?
SQL.Add('Select name, s1 From abc Where ...');
SQL.Add('union ');
SQL.Add('Select '合计' as name, Sum(s1) as s1 From abc Where ...');
Open;