unit fprice;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ComCtrls, ExtCtrls, DBTables, DB;type
TFormprice = class(TForm)
Panel1: TPanel;
Label1: TLabel;
Panel2: TPanel;
Label3: TLabel;
Label4: TLabel;
Edit1: TEdit;
Label5: TLabel;
Edit2: TEdit;
Button1: TButton;
Button2: TButton;
Button3: TButton;
Table1: TTable;
DataSource1: TDataSource;
Query1: TQuery;
Label2: TLabel;
Edit3: TEdit;
Edit4: TEdit;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Formprice: TFormprice;implementation{$R *.dfm}procedure TFormprice.Button1Click(Sender: TObject);begin
if edit1.Text='' then
begin showmessage('请输入当月铜价!');
exit;
end;
if edit2.Text='' then
begin showmessage('请输入标准铜价!');
exit;
end;
if edit3.Text='' then
begin showmessage('请输入客户名称!') ;
exit;
end;
if edit4.text='' then
begin showmessage('请输入日期!');
exit;
end;with query1 do
begin
sql.Clear;
sql.Add('insert into hbprice');
sql.Add('values(:v1,:v2,:v3,v4)');
parambyname('v1').Asstring:=edit4.text;
parambyname('v2').Asinteger:=strtoint(edit1.Text);
parambyname('v3').Asinteger:=strtoint(edit2.Text);
parambyname('v4').Asstring:=edit3.Text;
execsql;
end;
table1.Refresh;
end;end.
——********
为什么运行的时候出现 query1:parameter'v4'not found
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, ComCtrls, ExtCtrls, DBTables, DB;type
TFormprice = class(TForm)
Panel1: TPanel;
Label1: TLabel;
Panel2: TPanel;
Label3: TLabel;
Label4: TLabel;
Edit1: TEdit;
Label5: TLabel;
Edit2: TEdit;
Button1: TButton;
Button2: TButton;
Button3: TButton;
Table1: TTable;
DataSource1: TDataSource;
Query1: TQuery;
Label2: TLabel;
Edit3: TEdit;
Edit4: TEdit;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Formprice: TFormprice;implementation{$R *.dfm}procedure TFormprice.Button1Click(Sender: TObject);begin
if edit1.Text='' then
begin showmessage('请输入当月铜价!');
exit;
end;
if edit2.Text='' then
begin showmessage('请输入标准铜价!');
exit;
end;
if edit3.Text='' then
begin showmessage('请输入客户名称!') ;
exit;
end;
if edit4.text='' then
begin showmessage('请输入日期!');
exit;
end;with query1 do
begin
sql.Clear;
sql.Add('insert into hbprice');
sql.Add('values(:v1,:v2,:v3,v4)');
parambyname('v1').Asstring:=edit4.text;
parambyname('v2').Asinteger:=strtoint(edit1.Text);
parambyname('v3').Asinteger:=strtoint(edit2.Text);
parambyname('v4').Asstring:=edit3.Text;
execsql;
end;
table1.Refresh;
end;end.
——********
为什么运行的时候出现 query1:parameter'v4'not found
解决方案 »
- ADOQuery多表查询,单表更新现在可以解决没?
- 函数输出自定义数据结构的地址,但该自定义结构数有动态数组,如何根据地址取得该结构体数据,示例代码如下,pchar可以得到结果,动态数组则不行
- 请问如何制作中国象棋对弈软件的界面部分?
- 急如何把DATAGRID的里数据clear了!???
- NMsmtp发送邮件的时候,为什么内容体里老有空行(最前面)??怎么才能去掉??
- 主程序device.exe如何调用另一个程序update.exe,赐教
- 查询菜问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 请问:如何才能(20032-8-11)-(2001-12-4)=多少天?
- 如何我把listbox中的每条记录 在我创建的sql数据库中查找到 并输出sql中的和这条记录相关的其他字段到另一个listbox中
- 我想设置文件属性fareadonly时,程序好想一直理解为tfielddef.attributes的fareadonly,提示出错,怎么办?
- 一个简单的DBGrid问题
- 求救!编译是出现这个问题
sql.Add('values(:v1,:v2,:v3,v4)');
------------->>>
------------->>>
sql.Add('insert into hbprice');
sql.Add('values(:v1,:v2,:v3,:v4)');
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
sql.Add('values(:v1,:v2,:v3,:v4)');
我把数据填好后,按‘添加’后,出现提示:
.... table does not support this operation because it is not uniquely indexed. ...
请大家在次帮我看看哦
谢谢!!
[email protected]
try
执行添加记录过程
except
showmessage('Error!');
end;
要插入的主键重复了?还有,执行Insert语句最好把字段列出来。
sql.Add('values(:v1,:v2,:v3,:v4)');hbprice 和'values 之间没有空格 不是错误的sql语句吗
try
执行添加记录过程
showmessage('添加成功');
except
showmessage('Error!');
end;