sqlserverdelphi
查询 

所属分类:Pascal/Delphi编程
开发工具:Delphi
文件大小:274KB
下载次数:2
上传日期:2013-01-25 17:04:30
上 传 者wutongdong
说明:  上传一份Delphi做的SQL查询分析器,用来查询数据十分方便,欢迎分享
(Upload a Delphi SQL Query Analyzer used to query data is very convenient, welcome to share)

文件列表:
sqlserverdelphi\sql server(delphi)\1.ico (318, 2006-08-08)
sqlserverdelphi\sql server(delphi)\111.bmp (4318, 2006-08-05)
sqlserverdelphi\sql server(delphi)\2.ico (766, 2006-08-08)
sqlserverdelphi\sql server(delphi)\222.bmp (4318, 2006-08-05)
sqlserverdelphi\sql server(delphi)\2ccc.com.nfo (731, 2007-03-13)
sqlserverdelphi\sql server(delphi)\About.dcu (4057, 2007-10-31)
sqlserverdelphi\sql server(delphi)\About.dfm (3673, 2007-05-10)
sqlserverdelphi\sql server(delphi)\About.pas (702, 2013-01-04)
sqlserverdelphi\sql server(delphi)\ADOBinding.dcu (12031, 2007-10-31)
sqlserverdelphi\sql server(delphi)\ADOBinding.pas (11995, 2007-05-08)
sqlserverdelphi\sql server(delphi)\ADOIntStd.pas (154172, 2007-05-16)
sqlserverdelphi\sql server(delphi)\ADOISqlW.cfg (866, 2007-05-16)
sqlserverdelphi\sql server(delphi)\ADOISqlW.dof (2479, 2007-05-16)
sqlserverdelphi\sql server(delphi)\ADOISqlW.dpr (560, 2007-05-16)
sqlserverdelphi\sql server(delphi)\ADOISqlW.res (876, 2006-08-08)
sqlserverdelphi\sql server(delphi)\ADOISqlW.stat (166, 2008-03-07)
sqlserverdelphi\sql server(delphi)\Close.bmp (414, 2006-08-06)
sqlserverdelphi\sql server(delphi)\Close2.bmp (342, 2006-08-06)
sqlserverdelphi\sql server(delphi)\ConnWait.dcu (3954, 2007-10-31)
sqlserverdelphi\sql server(delphi)\ConnWait.dfm (787, 2007-05-17)
sqlserverdelphi\sql server(delphi)\ConnWait.pas (562, 2007-05-17)
sqlserverdelphi\sql server(delphi)\DataGrid.dcu (21694, 2007-10-31)
sqlserverdelphi\sql server(delphi)\DataGrid.pas (19469, 2007-05-18)
sqlserverdelphi\sql server(delphi)\FastMM4.dcu (37015, 2007-10-31)
sqlserverdelphi\sql server(delphi)\FastMM4.pas (299815, 2007-05-06)
sqlserverdelphi\sql server(delphi)\FastMM4Messages.dcu (5629, 2007-10-31)
sqlserverdelphi\sql server(delphi)\FastMM4Messages.pas (6025, 2007-05-06)
sqlserverdelphi\sql server(delphi)\FastMM4Options.inc (14343, 2013-01-25)
sqlserverdelphi\sql server(delphi)\Login.dcu (9836, 2007-10-31)
sqlserverdelphi\sql server(delphi)\Login.dfm (11609, 2007-05-16)
sqlserverdelphi\sql server(delphi)\Login.pas (4837, 2013-01-04)
sqlserverdelphi\sql server(delphi)\logo.bmp (3834, 2006-08-05)
sqlserverdelphi\sql server(delphi)\Main.dcu (18568, 2007-10-31)
sqlserverdelphi\sql server(delphi)\Main.dfm (162163, 2007-05-12)
sqlserverdelphi\sql server(delphi)\Main.pas (12079, 2013-01-04)
sqlserverdelphi\sql server(delphi)\obj.bmp (2806, 2007-04-17)
sqlserverdelphi\sql server(delphi)\ObjectsBrowser.dcu (53652, 2007-10-31)
sqlserverdelphi\sql server(delphi)\ObjectsBrowser.pas (35822, 2007-05-18)
sqlserverdelphi\sql server(delphi)\ObjectsBrowser.RES (28508, 2007-04-18)
sqlserverdelphi\sql server(delphi)\penal_ADO_ISqlW_1.00.gif (40101, 2007-05-19)
... ...

做这个东东, 原属偶然. 只是因为需要在客户那里维护一些数据, 但是人家的电脑不见得都安装了SQL Server客户端, 每次带光盘去给人家装程序也不好意思. 于是就写这个东东. 开始时, 也是很简单的, 只用了TADODataSet + TDBGrid来做. 代码也很稳定, 功能也够用了, 但是有些有些细微之处, 比如PRINT语句打出的来消息, 却获取不了. 后来抛弃了TADODataSet, 直接使用ADOInt.pas中的接口, 并且重新做一个简单的网格控件, 这才看起来像一回事. 写这东东也就是玩玩, 没花太多精力, 只是随兴而写, 代码不够艺术, 结构也松散, 如果代码看不懂, 只好见谅了. 程序中用到的图标, 动画都是从微软的SQLServer搞过来的, 罪过罪过. 我很少把一个程序坚持写到最后. 编写的过程出现的一些问题, 让我一直想改用OLE DB或ODBC来重做, 不过业余时间有限, 只好做罢了, 希望有兴趣的人继续. ^_^! 唯一值得一提的是, 我用了ADO Binding for VC++ Extension(MSDN上有详细资料), 速度比用Variant快(在ADOBinding.pas和RowData.pas) 目前仍存在的一些问题: Recordset.NextRecordset 返回的记录影响数目不太准确. 怀疑是ADO本身的BUG Connection出现连接问题时, State属性仍然是adStateOpen, 好像判断连接问题没有正式的文档说明. 对于消息性错误, ADO没什么好办法来判断. SQL调试, 实在不会搞.... 只在Delphi7编译, XP Pro SP2, ADO 2.8下运行测试过, 其它的平台没试过, 反正我的客户也都是XP的, 不想再花时间了. 谨以此作, 纪念那些辛苦维护垃圾代码的同志们! penal 2007.05.19

近期下载者

相关文件


收藏者