编译成功,执行出错!
请高手指点。
function Sql_ADO():integer;
var
ConnString : string;
ADOConnection1 : _Connection;
Recordset1 : _Recordset;
count1 : integer;begin ConnString := 'Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=AIO20030729110712;Data Source=LVFENG';
ADOConnection1 := CoConnection.Create;
ADOConnection1.Open(connString, 'sa','sa', -1);
Recordset1 := CoRecordset.Create;
Recordset1.Open('select * from hrms_Emp inner JOIN Com_EmpCard on hrms_emp.EmpID = Com_EmpCard.EmpID where Com_EmpCard.CardID =7403',ADOConnection1,adOpenKeyset,adLockPessimistic,adCmdText);
Recordset1.GetTypeInfoCount(count1);
result := count1;end;
请高手指点。
function Sql_ADO():integer;
var
ConnString : string;
ADOConnection1 : _Connection;
Recordset1 : _Recordset;
count1 : integer;begin ConnString := 'Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=AIO20030729110712;Data Source=LVFENG';
ADOConnection1 := CoConnection.Create;
ADOConnection1.Open(connString, 'sa','sa', -1);
Recordset1 := CoRecordset.Create;
Recordset1.Open('select * from hrms_Emp inner JOIN Com_EmpCard on hrms_emp.EmpID = Com_EmpCard.EmpID where Com_EmpCard.CardID =7403',ADOConnection1,adOpenKeyset,adLockPessimistic,adCmdText);
Recordset1.GetTypeInfoCount(count1);
result := count1;end;
解决方案 »
- WIN XP + DELPHI2010下,service application模式的DataSnap服务端不能使用?
- 怎么这样程序出错(treeview),请各位指点!!!
- 这样的字符串如何分离?'a;b;c'
- 求购进销存软件,价格再议!
- 在delphi里怎么添加Real Producer ActiveX Control Library控件啊?
- 如何连接到SYBASE?
- delphi7如何给excel单元格设置超链接地址
- 请问各位,如何给分呀?
- 这样为什么不能继承TButton的属性?
- 如何设计一个电子书库类的文件格式
- 请问在程序中将image控件中的图片清空应该怎么写??
- 在主窗口有个‘退出系统’BUTTON,然后点击,会弹出一个FORMCLOSE,FORM里有3个BUTTON,
看看ConnString有没有写对,再改一下ADOConnection1.Open(connString, '','', -1);
请问高手,下面这句应该怎么改啊!!!!!
Recordset1.Open('select * from Pos_AccHead where AccStatus = 10 AND CardID ='+ string(CarID_Input),ADOConnection1,adOpenKeyset,adLockPessimistic,adCmdText);
现在有个问题问 poleax() ,如果用ADOConnection1 : _Connection;
Recordset1 : _Recordset;这种方式,怎么实现添加和修改数据啊!
最简单的方法!