分享

查询分析器里面没有问题,在ADOQuery.sql.add()种为什么就出错呢?

 kenwang 2007-05-09
HBADOConnString =
    ‘Provider=SQLOLEDB.1;Persist Security Info=True;PassWord=%s;User ID=%s;Initial Catalog=%s;Data Source=%s‘;
--------------------------------------------
function ConnectHBDataBase(const ServerName,DataBaseName,UserName,UserPassword: string;
                           ADOConnectionTest: TADOConnection;  ShowMsg: Boolean = True): Boolean;
var
  fCS: string;
  fQuery: TADOQuery;
  fUserName, fPassWord: string;
begin
  fCS := Format(HBADOConnString, [UserPassword,UserName , DataBaseName, ServerName]);
  ADOConnectionTest.Close;
  ADOConnectionTest.ConnectionString := fCS;
  try
    ADOConnectionTest.Open;
  except
    Result := False;
    if ShowMsg then
      MessageError(‘对不起,数据库服务器地址错误!‘);
    Exit;
  end;
  Result := true;
end;
----------------------------------------------------------------------
procedure ADOExecuteSQL(ConnectionObjects: TADOConnection; SQLStr: string);
begin
  with TADOQuery.Create(nil) do
  try
    Connection := ConnectionObjects;
    SQL.Text := SQLStr;
    ExecSQL;
  finally
    Free;
  end; //try
end;
//调用
接口服务启动后就保持连接,这样更节省资源  ?
  HBConnected := ConnectHBDataBase( ZNHBSvrParam.HB_ServerName,ZNHBSvrParam.HB_DataBaseName,
                            ZNHBSvrParam.HB_UserName,ZNHBSvrParam.HB_UserPassword, HBDBConnection, False);
U_MODE_SQLStr = ‘ UPDATE A  SET A.TIMEMARK = GETDATE() FROM MODE A ‘+
                 ‘ WHERE A.TIMEMARK IS NULL  AND A.TYPE_NO = ‘‘%S‘‘  AND A.ORDER_NO = %D ‘;
ADOExecuteSQL(HBDbconn, U_MODE_SQLStr,[fQuery.Fields[0].AsString,fQuery.Fields[1].AsInteger]);

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多