为什么我编的控件的方法不能在一个中调用两次 CISConn是什么?将CISConn动态创建试试 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 try CISQuery.Close; //加试试 CISQuery.CursorLocation := clUseServer; CISQuery.LockType := ltBatchOptimistic; CISQuery.Connection := CIsConn; function TCISSQLCotrol.CsData(TableIdArray: OleVariant; const FSQLStr, BSQLStr: WideString): OleVariant;var TableName,CsSQLStr: string; i,IDNum: Integer;begin TableName := ''; if CISConn.Connected = false then begin Result := '尚未连结数据库'; exit; end; for i:= VarArrayLowBound(TableIDArray,1) to VarArrayHighBound(TableIDArray,1)-1 do begin IDNum := TableIDArray[i]; case IDNum of//生成SQL语句 1:TableName := TableName + 'JJR_MAIN'; 2:TableName := TableName + 'JJR_JBZL'; 3:TableName := TableName + 'BMGL'; 4:Tablename := TableName + 'GSGL'; 5:TableName := TableName + 'BMYJ'; 6:Tablename := TableName + 'RY_GDGL'; 7:Tablename := TableName + 'GLYTABLE'; end; Tablename := Tablename + ' '+ chr(65+i) + ','; end; Tablename[Length(Tablename)]:=' '; if CISConn.Connected = false then begin Result := '尚未连结数据库'; exit; end; try CISQuery.CursorLocation := clUseServer; CISQuery.LockType := ltBatchOptimistic; CISQuery.Connection := CIsConn; CSSQLStr := FSQLStr + ' '+TableName+' '+ BSQLStr; CheckQuery.SQL.Clear; CISQuery.SQL.Add(CsSQLStr); CISQuery.Open; result:=ADODB_TLB._Recordset(CIsQuery.Recordset); except begin Result := '查询出错'; exit; end; end; CISQuery.Close; //打开数据没有关闭end; TIdUDPServer.Active:=true;错误后的异常处理 招聘志愿者参加游戏Script开发 急用??? 很简单的有关流的问题(但有点难),如何改进?(用流合并文件,有点像rar,但是如果合并的文件太大时,就很慢了) ■■■献上100分,求各位大哥大姐兄弟姐妹帮帮小弟我吧~ 请问各位大虾,dhlphi7中一般用什么工具做报表阿? 如何在interbase数据库中存放图片? 制作什么样的共享软件,会受到欢迎?(在线结分) DBGridEH输出到excel问题? 如何调用regsvr32.exe注册控件 怎样屏蔽程序中的所有异常错误? 大虾们,这个sql语句怎么写啊,能写吗
CISQuery.Close; //加试试
CISQuery.CursorLocation := clUseServer;
CISQuery.LockType := ltBatchOptimistic;
CISQuery.Connection := CIsConn;
BSQLStr: WideString): OleVariant;
var TableName,CsSQLStr: string;
i,IDNum: Integer;
begin
TableName := ''; if CISConn.Connected = false then
begin
Result := '尚未连结数据库';
exit;
end;
for i:= VarArrayLowBound(TableIDArray,1) to VarArrayHighBound(TableIDArray,1)-1 do
begin
IDNum := TableIDArray[i];
case IDNum of//生成SQL语句
1:TableName := TableName + 'JJR_MAIN';
2:TableName := TableName + 'JJR_JBZL';
3:TableName := TableName + 'BMGL';
4:Tablename := TableName + 'GSGL';
5:TableName := TableName + 'BMYJ';
6:Tablename := TableName + 'RY_GDGL';
7:Tablename := TableName + 'GLYTABLE';
end;
Tablename := Tablename + ' '+ chr(65+i) + ',';
end;
Tablename[Length(Tablename)]:=' ';
if CISConn.Connected = false then
begin
Result := '尚未连结数据库';
exit;
end;
try
CISQuery.CursorLocation := clUseServer;
CISQuery.LockType := ltBatchOptimistic;
CISQuery.Connection := CIsConn;
CSSQLStr := FSQLStr + ' '+TableName+' '+ BSQLStr;
CheckQuery.SQL.Clear;
CISQuery.SQL.Add(CsSQLStr);
CISQuery.Open;
result:=ADODB_TLB._Recordset(CIsQuery.Recordset);
except
begin
Result := '查询出错';
exit;
end;
end;
CISQuery.Close; //打开数据没有关闭
end;