如何删除一行?(能正常连接显示和编辑)
如何刷新(我采取了重新建立连接的方法)在MSDN是这样写的:
**************************************************************************
Delete
You are more restricted in deleting Excel data than data from a relational datasource. In a relational database, "row" has no meaning or existence apart from "record"; in an Excel worksheet, this is not true. (1)You can delete values in fields (cells). However, you cannot: Delete an entire record at once or you receive the following error message:
Deleting data in a linked table is not supported by this ISAM. You can only delete a record by blanking out the contents of each individual field.(难道字段全填空就行,就能删除一个记录吗,但没有成功。没有办法直接删除一行吗,要像(1)所说的You can delete values in fields(cells) )?Delete the value in a cell containing an Excel formula or you receive the following error message:
Operation is not allowed in this context. You cannot delete the empty spreadsheet row(s) in which the deleted data was located, and your recordset will continue to display empty records corresponding to these empty rows. A caution about editing Excel data with ADO: When you insert text data into Excel with ADO, the text value is preceded with a single quote. This may cause problems later in working with the new data.
**************************************************************************
如何刷新(我采取了重新建立连接的方法)在MSDN是这样写的:
**************************************************************************
Delete
You are more restricted in deleting Excel data than data from a relational datasource. In a relational database, "row" has no meaning or existence apart from "record"; in an Excel worksheet, this is not true. (1)You can delete values in fields (cells). However, you cannot: Delete an entire record at once or you receive the following error message:
Deleting data in a linked table is not supported by this ISAM. You can only delete a record by blanking out the contents of each individual field.(难道字段全填空就行,就能删除一个记录吗,但没有成功。没有办法直接删除一行吗,要像(1)所说的You can delete values in fields(cells) )?Delete the value in a cell containing an Excel formula or you receive the following error message:
Operation is not allowed in this context. You cannot delete the empty spreadsheet row(s) in which the deleted data was located, and your recordset will continue to display empty records corresponding to these empty rows. A caution about editing Excel data with ADO: When you insert text data into Excel with ADO, the text value is preceded with a single quote. This may cause problems later in working with the new data.
**************************************************************************
解决方案 »
- 窗体置顶与浮动问题
- delphi中有什么办法可以判断一个界面是模式的还是非模式的?
- 请教:StringGrid如何绘制焦点。
- ListView的基础问题~!
- 限定最大宽度,宽度是两行,如何使QRDBText自动换行?
- INSTALLSHIELD安装时,怎么样加入数据库安装?
- 请问D5是否有个升级包?在那里有下载?
- 大家好,我今天刚学DELPHI,请帮忙看看我这里哪里错了好吗?
- 高手支招:delphi 5+win98编译的系统在win2000下运行会产生某些字体的变化(变大),有什么办法能够解决?谢谢赐教!
- 如何取得TPrinterSetupDialog执行后,是否横打(纵打)?以及打印的次数?
- 哪里有DELPHI6中文版或其中的帮助文件下载?有可靠链接的第一个给分50分以上(QQ:51129127)(无内容)
- D菜求救!!在线等待!!
begin
adoconnecitonstr:='......';
sql.text:='delete from table where ....';
execsql;
refresh;
end;