在DBGRID中有QRY1查出来的数据。
我想在底下加一个EDIT1显示总行数。
procedure TForm3.btn3Click(Sender: TObject);
var
s,b:string;
begin
s:='SELECT CMSMC.MC002,INVMC.MC002,INVMB.MB001,INVMB.MB002,INVMB.MB003,INVMC.MC007,INVMB.MB004,INVMB.MB109 FROM INVMB,INVMC,CMSMC WHERE '+
'INVMC.MC002=CMSMC.MC001 AND INVMB.MB001=INVMC.MC001 AND '+
'INVMC.MC007>0 AND INVMC.MC002='+''''+Trim(edt1.text)+''''+'ORDER BY INVMB.MB001 ASC';
b:='SELECT COUNT(MB001)FROM INVMB,INVMC WHERE INVMB.MB001=INVMC.MC001 AND '+
'INVMC.MC007>0 AND INVMC.MC002='+''''+Trim(edt1.text)+'''';
with qry1 do
begin
Close;
sql.Clear;
SQL.Add(s);
Open;
end;
with qry2 do
begin
Close;
sql.Clear;
SQL.Add(b);
Open;
edt2.Text:=qry2.fieldbyname('COUNT(MB001)').asstring;//运行时候提示这句有问题。如果在DBGRID中每行前面加序号每增一行就自动增一个序号如001 002 又应该怎么样做呢?
我想在底下加一个EDIT1显示总行数。
procedure TForm3.btn3Click(Sender: TObject);
var
s,b:string;
begin
s:='SELECT CMSMC.MC002,INVMC.MC002,INVMB.MB001,INVMB.MB002,INVMB.MB003,INVMC.MC007,INVMB.MB004,INVMB.MB109 FROM INVMB,INVMC,CMSMC WHERE '+
'INVMC.MC002=CMSMC.MC001 AND INVMB.MB001=INVMC.MC001 AND '+
'INVMC.MC007>0 AND INVMC.MC002='+''''+Trim(edt1.text)+''''+'ORDER BY INVMB.MB001 ASC';
b:='SELECT COUNT(MB001)FROM INVMB,INVMC WHERE INVMB.MB001=INVMC.MC001 AND '+
'INVMC.MC007>0 AND INVMC.MC002='+''''+Trim(edt1.text)+'''';
with qry1 do
begin
Close;
sql.Clear;
SQL.Add(s);
Open;
end;
with qry2 do
begin
Close;
sql.Clear;
SQL.Add(b);
Open;
edt2.Text:=qry2.fieldbyname('COUNT(MB001)').asstring;//运行时候提示这句有问题。如果在DBGRID中每行前面加序号每增一行就自动增一个序号如001 002 又应该怎么样做呢?
解决方案 »
- 一个循环往数据库里写东西的程序,为什么CPU占用很高,而且数据库进程占用内存越来越大?
- try...if ...exit;...finally...end;结构的疑问???
- 如何找出报表的窗体QuickRep1?谢谢!
- 找工作---广东或厦门
- 关于 DBCHART 控件的问题
- zswang-xgto技术交流(6)
- 请问有没有支持jpg格式的dbimage控件?
- 那位大哥幫我解決SQL問題,謝謝!
- listbox的添加Items
- 拨号连接到ORACLE8,在程序打开数据库后,如果掉线了,重新拨上后在程序中执行数据库操作则报错,在不重新打开程序的情况下,怎样自动重新连接数据库
- 用Dbgrideh导出EXCEL有重复数据
- 为什么AnsiContainsText('800002', '2')结果是False
edt2.Text:=IntToStr(qry1.Recordcount);增加序号,在增加过程中,如NewRecord事件写代码,
这是从1开始,前面要加几个0,变成001,002,003...自己处理一下吧
With qry1 do
FieldByName('ID').AsInteger:=Recordcount+1;
qry2.first;
edt2.Text:=inttostr(qry2.recordcount);
qry2.last;
qry2.last;
edt2.Text:=inttostr(qry2.recordcount);
qry2.first;