为什么我做修改和添加数据库记录,只能用ADOTable.用ADOquery和sql语句就不能完成呢??
在ADOTable中我的程序如下:
with ADOTable do
begin
tablename:="info";
open;
locate('num','request.contentfields.value['num'],[])
edit;
fieldbyname('name').asstring:=request.contentfields.value['name'];
close;
end;
用ADOquery 程序如下;
with ADOQuery do
begin
close;
sql.clear;
sql.text:='updata info set name='''+request.contentfields.value ['name']+''' where num='''+request.contentfields.value['name']+'''';
prepared;
execsql;
end;
在以前的桌面程序和c/s结构中.我都是用的ADOquery.可在web程序中会错喃??
帮帮我...
在ADOTable中我的程序如下:
with ADOTable do
begin
tablename:="info";
open;
locate('num','request.contentfields.value['num'],[])
edit;
fieldbyname('name').asstring:=request.contentfields.value['name'];
close;
end;
用ADOquery 程序如下;
with ADOQuery do
begin
close;
sql.clear;
sql.text:='updata info set name='''+request.contentfields.value ['name']+''' where num='''+request.contentfields.value['name']+'''';
prepared;
execsql;
end;
在以前的桌面程序和c/s结构中.我都是用的ADOquery.可在web程序中会错喃??
帮帮我...
begin
close;
sql.clear;
sql.add('updata info set name='''+request.contentfields.value ['name']+''' where num='''+request.contentfields.value['name']+'''');
prepared;
execsql;
end;