在 文本框输入日期 输出所要查找的资料 我这样写正确么begin
if edit1.text='' then
begin
showmessage('not null');
abort;
end; with ADOQuery1 do
begin
sql.Clear;
sql.Add('DELETE NK_ZLC..TEMP_KQ '+
'INSERT INTO NK_ZLC..TEMP_KQ '+
'SELECT W.MB001 FROM WAY2006..YAMMB W '+
'RIGHT JOIN NK_ZLC..TEMP U ON W.MB001=U.MV001 '+
'WHERE MB002='+''''+TRIM(EDIT1.TEXT)+'%'+''' '+ 'DELETE NK_ZLC..TEMP_3 '+
'INSERT NK_ZLC..TEMP_3 '+
'SELECT M.MV001 FROM NK_ZLC..TEMP M '+
'LEFT JOIN NK_ZLC..TEMP_KQ T ON M.MV001=T.MB001 '+
'WHERE MB001 IS NULL '+ 'SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3 '+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
'ORDER BY ME002 ASC');
open
end
end;
if edit1.text='' then
begin
showmessage('not null');
abort;
end; with ADOQuery1 do
begin
sql.Clear;
sql.Add('DELETE NK_ZLC..TEMP_KQ '+
'INSERT INTO NK_ZLC..TEMP_KQ '+
'SELECT W.MB001 FROM WAY2006..YAMMB W '+
'RIGHT JOIN NK_ZLC..TEMP U ON W.MB001=U.MV001 '+
'WHERE MB002='+''''+TRIM(EDIT1.TEXT)+'%'+''' '+ 'DELETE NK_ZLC..TEMP_3 '+
'INSERT NK_ZLC..TEMP_3 '+
'SELECT M.MV001 FROM NK_ZLC..TEMP M '+
'LEFT JOIN NK_ZLC..TEMP_KQ T ON M.MV001=T.MB001 '+
'WHERE MB001 IS NULL '+ 'SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3 '+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
'ORDER BY ME002 ASC');
open
end
end;
解决方案 »
- delphi转成c#的问题,有懂Delphi的高手来瞧瞧!
- D7,在某个文本文件中找某串字符串,如果找到就退出,找不到就再找另外一个字符串,然后将该字符串删除,再添加新字符串进去,然后保存
- 哪里有delphi8.0数据库开发及报表设计教程?
- 我想做个自动更新管理软件,请教大家!
- 身在北京,打算在北京找delphi or java 方面的工作。
- IB 组件的事务管理机制是什么样子的?
- 求教:如何将大段文本插入数据库(不使用insert语句)
- 用CopyMemory把Grid中的内容拷到一个数组型记录中
- 98下界面不正常
- z_x_b(长弓落日金沙丘)、cszhz(丑小鸭)、qiubolecn(来自差生市)、sleeplions(睡狮)、suzg(Eureka!)、dancemaple(枫之舞)、BigBen(江南草)请进来加分!
- 执行下列SQL语句时报错
- Delphi中使用MSComm控件,双击ONCOMM事件时出现的问题“Cannot find implementation of method MSComm1comm.”
'INSERT NK_ZLC..TEMP_3 '+ 这里就不对
还有,你这里,有delete,有insert的,还有查询的用open不对吧.
对于delete,insert应该用execsql,select的用open.
if trim(edit1.text)<>'' then begin
with ADOQuery1 do begin
close;
sql.text:='DELETE NK_ZLC..TEMP_KQ';
ExecSQL;
sql.text:=''DELETE NK_ZLC..TEMP_3';
ExecSQL;
sql.text:='INSERT INTO NK_ZLC..TEMP_KQ(你的字段名) '+
'SELECT W.MB001 FROM WAY2006..YAMMB W '+
'RIGHT JOIN NK_ZLC..TEMP U ON W.MB001=U.MV001 '+
'WHERE MB002='+QuotedStr(edit1.text);
ExecSQL;{不会返回数据集的用EXECSqL}
sql.text:='INSERT NK_ZLC..TEMP_3(你的字段名) '+
'SELECT M.MV001 FROM NK_ZLC..TEMP M '+
'LEFT JOIN NK_ZLC..TEMP_KQ T ON M.MV001=T.MB001 '+
'WHERE MB001 IS NULL ';
Execsql;
sql.text:='SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3 '+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
'ORDER BY ME002 ASC';
open;{有返回数据集的用OPEN}
end;
end else
showmessage('not null');
with ADOQuery1 do begin
close;
sql.text:='DELETE NK_ZLC..TEMP_KQ';
ExecSQL;
sql.text:='DELETE NK_ZLC..TEMP_3';
ExecSQL;
sql.text:='INSERT INTO NK_ZLC..TEMP_KQ(你的字段名) '+
'SELECT W.MB001 FROM WAY2006..YAMMB W '+
'RIGHT JOIN NK_ZLC..TEMP U ON W.MB001=U.MV001 '+
'WHERE MB002='+QuotedStr(edit1.text);
ExecSQL;{不会返回数据集的用EXECSqL}
sql.text:='INSERT NK_ZLC..TEMP_3(你的字段名) '+
'SELECT M.MV001 FROM NK_ZLC..TEMP M '+
'LEFT JOIN NK_ZLC..TEMP_KQ T ON M.MV001=T.MB001 '+
'WHERE MB001 IS NULL ';
Execsql;
sql.text:='SELECT MT001,MV002,ME002 FROM NK_ZLC..TEMP_3 '+
'LEFT JOIN WAY2006..CMSMV ON MT001=MV001 '+
'LEFT JOIN WAY2006..CMSME ON ME001=MV004 '+
'ORDER BY ME002 ASC';
open;{有返回数据集的用OPEN} end;
end else
showmessage('not null');