2454
社区成员
dataset not in edit or insert mode
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Edit;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open;
adoquery1.Active:=true;
if str<>'' then
adoquery1.FieldByName('str').AsString:=str;
end;
我是delphi新手，不知道为什么出在哪里？一按确定就弹出dataset not in edit or insert mode
哪位大哥可以帮我解决一下
begin
adoquery1.Edit;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open;
adoquery1.Active:=true;
if str<>'' then
adoquery1.FieldByName('str').AsString:=str;
end;
我是delphi新手，不知道为什么出在哪里？一按确定就弹出dataset not in edit or insert mode
哪位大哥可以帮我解决一下
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
coderee 2009-12-07
路过。
npkaida 2009-12-07
对不起，少了一个 Edit
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.Edit;
adoquery1.FieldByName('str').AsString:=str;
adoquery1.Post;
end;
end;
lyhoo163 2009-12-07
up
汉语很 2009-12-07
顺序搞错了
suuuu 2009-12-07
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.Edit;//如果你想做插入动作的话这里改为 adoquery1.append
adoquery1.FieldByName('str').AsString:=str;
adoquery1.Post;
end;
end;
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.Edit;//如果你想做插入动作的话这里改为 adoquery1.append
adoquery1.FieldByName('str').AsString:=str;
adoquery1.Post;
end;
end;
hwill 2009-12-06
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.Edit; //进入编辑状态
adoquery1.FieldByName('str').AsString:=str; //也可以写成adoquery1['str']:=str;
adoquery1.Post; //保存编辑结果
end;
end;
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.Edit; //进入编辑状态
adoquery1.FieldByName('str').AsString:=str; //也可以写成adoquery1['str']:=str;
adoquery1.Post; //保存编辑结果
end;
end;
思远周 2009-12-06
顺序搞错了！如果要对数据进行修改，必须先要打开数据源，这样才可以进行操作!不然是不可以对数据进行edit,Append等操作的！希望人兄好好学习一下Ado控件的使用！
npkaida 2009-12-06
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Close; //等同于 adoquery1.Active:=false;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open; //等同于 adoquery1.Active:=true;
if str <>'' then
begin
adoquery1.FieldByName('str').AsString:=str;
adoquery1.Post;
end;
end;
fa_ge 2009-12-06
procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from fs where xh="'+dbtext1.Caption+'"');
adoquery1.open;
adoquery1.Edit;
if str <>'' then
adoquery1.FieldByName('str').AsString:=str;
end;
修改数据结果出现dataset not in edit or insert mode 想让程序在查询后修改数据结果出现dataset not in edit or insert mode ，问题，想要修改数据，不能随意移动纪录指针，并且在每次修改纪录后马上post，前面加上Edit 模式 基本语句如下所示： while not self....
关于DBGrideh出现Dataset not in edit or insert mode 我是在选择框的数据改变是事件onupdatedata的事件中对数进行修改，但有时候可以修改，有时候就会出现adoquery1: dataset not in edit or insert mode 的错误，我百思不得其解。 在网上找了好久，有人说是把DBGrideh...
数据库操作 INSERT into vlookup(gh,xm,sfzh,sbh) VALUES('5','6','7','8'); -- 修改 UPDATE vlookup SET xm = '马瑞华',sfzh='88888888888' WHERE gh = '1'; 转载于:...
Oracle/SQL 修改字段类型和长度 标准SQL修改字段类型和长度语句： ALTER TABLE tableName modify column columnName 类型; 例如Mysql的修改字段类型语句： alter table test modify column name varchar(255); ...Oracle修改字段类型和长度语句： ...
Client Dataset Basics 文章出处:... In the preceding two chapters, I discussed dbExpress—a unidirectional database technology. In the real world, most applications support b...
delphi 错误 Cannot modify a read-only dataset 1、“Cannot modify a read-only dataset. “解决方法：选中Query1，然后在Object Inspector中把Properties的...2、Query2: Dataset not in edit or insert mode’.很可能是漏写了Query2.Edit和Query2.Post 。
GDAL & Python | Chapter 3. Reading and writing vector data In this chapter you’ll learn basic ideas behind vector data and how to use the OGR library to read, write, and edit these types of datasets. 3.1. Introduction to vector data At its most basic, ...
缓存cache 填充dataset sout = sout & "<td align=center ><a href=""" & sret & """><IMG src='images/edit.png' align='baseline' border=0></a></td>" sout = sout & "<td align=center> ('您确定删除吗?一旦删除将无法恢复!')"" href...
Disecting the Postgres Bulk Insert and Binary Format Introduction This post delves deep into the world of bulk loading data withPostgresSQL... I’ve written about this subject before inOptimizing Innodb for Bulk Insertfor MySQL-esque databases. These p...
Insert, Update, Delete in ASP.NET Gridview, DataSource as SQL Server, MS Access (mdb/accdb), XML and This demo is a continuation of my previous example “Binding GridView with Data... If you are not familiar of binding the GridView the ado.net way then I would suggest looking at my previous example f
第一部分 Below is the Design time EditMode property Editor from the AstaClientDataSet. 注意 : 这个例子从服务器提取数据和修改数据都没使用事务，而我们建议写 cs 程序的时候对所有修改远程数据库的 Post 使用...
使用dataset数据集实现ListView简单的增删该查 DataSetPerson.xsd： <?xml version="1.0" encoding="utf-8"?...xs:schema id="DataSetPerson" targetNamespace="http://tempuri.org/DataSetPerson.xsd" xmlns:mstns="http://tempuri.org/DataSet...
post processing in CFD This text command is not available in the parallel version of ANSYS Fluent. extrusion is not possible from boundary face zones that have hanging nodes. Extruding face zones is not allowed on ...
SAP R/3 ABAP 开发过程中一些总结 1、ST05是用于在开发ABAP程序时，对应事务...2、跟踪时如果有涉及到“数量”这类有对数据表进行更新或插入操作的，则直接去查Update和Insert的SQL语句； 3、在跟踪后，直接双击“对象名”列的名称，点选“表格”转到
SQLDirect组件库用户指南 , the SQLDirect Library uses deferred mode of statement execution for minimizing network traffic and piecewise insert, update and fetch of long BLOB-fields, it is supported only by Oracle Server 7.2(+...
