我的代码如下:
str1:='select Goods.G_Class as C_Code1,Goods.G_Code Code1 ,Goods.G_Name GName1,Goods.G_GuiGe GuiGe1 ,Class.C_Name CName1,Goods.G_DanWei DanWei1,Goods.G_Min min1,Goods.G_Max max1, ';
str2:='round(Goods.G_Num,2) Num1,round(Goods.G_Jia,2) Jia1,round(Goods.G_Amount,2) Amount1 ';
str3:='from Goods,Class where Goods.G_Class=Class.C_Code and Class.C_Name='''+trim(cmtcom1.text)+'''';
end;
str1:=str1+str2+str3;
cmttable1.Close;
cmttable1.SQL.Clear;
cmttable1.SQL.Add(str1);
cmttable1.Open; Pdata.Classstr:='';
Pdata.classstr:=cmttable1.fieldbyname('C_Code1').value;
end;
dbgrid1.Columns[0].FieldName:='Code1';
dbgrid1.Columns[1].FieldName:='GName1';
dbgrid1.Columns[2].FieldName:='GuiGe1';
dbgrid1.Columns[3].FieldName:='CName1';
dbgrid1.Columns[4].FieldName:='DanWei1';
dbgrid1.Columns[5].FieldName:='min1';
dbgrid1.Columns[6].FieldName:='max1';
dbgrid1.Columns[7].FieldName:='Num1';
dbgrid1.Columns[8].FieldName:='Jia1';
dbgrid1.Columns[9].FieldName:='Amount1';
str1:='select Goods.G_Class as C_Code1,Goods.G_Code Code1 ,Goods.G_Name GName1,Goods.G_GuiGe GuiGe1 ,Class.C_Name CName1,Goods.G_DanWei DanWei1,Goods.G_Min min1,Goods.G_Max max1, ';
str2:='round(Goods.G_Num,2) Num1,round(Goods.G_Jia,2) Jia1,round(Goods.G_Amount,2) Amount1 ';
str3:='from Goods,Class where Goods.G_Class=Class.C_Code and Class.C_Name='''+trim(cmtcom1.text)+'''';
end;
str1:=str1+str2+str3;
cmttable1.Close;
cmttable1.SQL.Clear;
cmttable1.SQL.Add(str1);
cmttable1.Open; Pdata.Classstr:='';
Pdata.classstr:=cmttable1.fieldbyname('C_Code1').value;
end;
dbgrid1.Columns[0].FieldName:='Code1';
dbgrid1.Columns[1].FieldName:='GName1';
dbgrid1.Columns[2].FieldName:='GuiGe1';
dbgrid1.Columns[3].FieldName:='CName1';
dbgrid1.Columns[4].FieldName:='DanWei1';
dbgrid1.Columns[5].FieldName:='min1';
dbgrid1.Columns[6].FieldName:='max1';
dbgrid1.Columns[7].FieldName:='Num1';
dbgrid1.Columns[8].FieldName:='Jia1';
dbgrid1.Columns[9].FieldName:='Amount1';
解决方案 »
- 关于内存释放的问题。
- 很简单的,就是如何移动指针
- 请教大家:什么是设备描述表和设备场景?HDC是什么?
- 很简单的问题,产生随机数的函数
- 不知这句sql怎么写,关系到两张表的,很简单,拿分拉,谁先回答对给大头
- 关于使用TADOConnection的事务功能的问题
- 各位中秋愉快,我可在加班,请帮小弟怎样在一个Tmemo的控件打开的文件中查找包含有<Table>以及与之相对应的</Table>的lines,可以加分,今
- 我的gf给个谜语我猜,大家帮帮我吧,急急急急!!!
- 请教Delphi高手,关于内存释放的问题
- 我用antinimda查杀尼姆达病毒后造成sqlserver管理器无法启动请问怎么解决?
- 在delphi怎么调用access数据库的查询?
- 各位介绍一下,想显示word文件用什么控件好?(别告诉我用RichEdit和嵌入Word)
if cmtablel.isempty then exit;
Pdata.classstr:=cmttable1.fieldbyname('C_Code1').value;
你把adoquery的active属性设置为false看看,使用的时候打开它