有两个问题,一个是degrid里除了数字显示的都是乱码,还有就是查询不出来,出错提示为:gerenal sql error!请大家帮忙看看,谢谢了~
procedure TForm11.BitBtn3Click(Sender: TObject);
var
sqlstr,strval,comstr:string;
flag:integer;
begin
memo1.clear;
memo1.Lines.Add( " 商品名称, 数量 ");
memo1.Lines.Add( "---------------------------------------------------------------------------------- ") ;
flag:=0;
strval:=trim(edit1.Text);
if strval < > " "then
begin
sqlstr:= "select*from rkguanli where(mingcheng= "+ ""+strval+") ";
flag:=1;
end;
strval:=trim(edit2.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(caigouren= "+ ""+strval+") ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(name= "+ ""+strval+") ";
end;
strval:=trim(edit3.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(zongjia=edit3.Text) ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(zongjia= "+ ""+strval+") ";
end; strval:=trim(edit4.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(rukuriqi= "+ ""+strval+") ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(rukuriqi= "+ ""+strval+") ";
end;
if flag=0 then
begin
showmessage ( "请正确输入查询条件 ");
end;
query1.Close;
query1.sql.text:=sqlstr;
query1.Open;
flag:=0;
while not query1.Eof do
begin
sqlstr:=query1.fieldbyname( "mingcheng ").AsString ;
sqlstr:=sqlstr+ ", "+query1.fieldbyname( "shuliang ").asstring;
memo1.Lines.add(sqlstr);
query1.Next;
flag:=flag+1;
end;
memo1.Lines.Add( "--------------------------------------------- ") ;
memo1.Lines.add( "一共有 "+inttostr(flag)+ "项符合查询条件 ");
end;
end.
procedure TForm11.BitBtn3Click(Sender: TObject);
var
sqlstr,strval,comstr:string;
flag:integer;
begin
memo1.clear;
memo1.Lines.Add( " 商品名称, 数量 ");
memo1.Lines.Add( "---------------------------------------------------------------------------------- ") ;
flag:=0;
strval:=trim(edit1.Text);
if strval < > " "then
begin
sqlstr:= "select*from rkguanli where(mingcheng= "+ ""+strval+") ";
flag:=1;
end;
strval:=trim(edit2.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(caigouren= "+ ""+strval+") ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(name= "+ ""+strval+") ";
end;
strval:=trim(edit3.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(zongjia=edit3.Text) ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(zongjia= "+ ""+strval+") ";
end; strval:=trim(edit4.Text);
if strval < > " "then
begin
sqlstr:= "select *from rkguanli where(rukuriqi= "+ ""+strval+") ";
flag:=1;
end
else
begin
sqlstr:=sqlstr + "and(rukuriqi= "+ ""+strval+") ";
end;
if flag=0 then
begin
showmessage ( "请正确输入查询条件 ");
end;
query1.Close;
query1.sql.text:=sqlstr;
query1.Open;
flag:=0;
while not query1.Eof do
begin
sqlstr:=query1.fieldbyname( "mingcheng ").AsString ;
sqlstr:=sqlstr+ ", "+query1.fieldbyname( "shuliang ").asstring;
memo1.Lines.add(sqlstr);
query1.Next;
flag:=flag+1;
end;
memo1.Lines.Add( "--------------------------------------------- ") ;
memo1.Lines.add( "一共有 "+inttostr(flag)+ "项符合查询条件 ");
end;
end.
解决方案 »
- delphi 将100个数字平均分布到600个数组里
- 查看并能运行本地程序的API函数..
- 关于四舍五入
- 怎样在StringGrid中加入一个随单元格移动的edit?
- 一个关于软件加密的问题,制作钥匙盘的程序?急!
- 请告诉我Rxlib的下载地址?
- 如何动态生成数据库?
- Acrobat Reader 5.0中文版在看书时会出现“字体'HYclgj'包含错误/外框”错误框!?
- 请问:为什么我在Dephi5中不能使用SQL Server中的nvarchar类型字段???急!
- 如何检测CD-ROM或是其他磁盘是否有过变化(即制作启动盘)???
- Delphi7+ADO+SQL在某些机器上连接遇到的问题
- 關於Twebbrowser的execScript()用法
这里是双引号:"