提问
SAP HANA, express edition odbc create local temporary table sqlbindparameter

SAP HANA ODBC 292错误，带有CREATE LOCAL TEMPORARY TABLE AS（...？...）的参数数量错误

2020-08-26 20:47发布

站内问答 / HANA
1702 4 6

点击此处---> 群内免费提供SAP练习系统（在群公告中）加入QQ群：457200227（SAP S4 HANA技术交流） 群内免费提供SAP练习系统（在群公告中）当执行SQLPrepareW（）...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统（在群公告中）

加入QQ群：457200227（SAP S4 HANA技术交流） 群内免费提供SAP练习系统（在群公告中）


当执行SQLPrepareW（）+ SQLBindParameter（）+ SQLExecute（）时

创建本地速度表AS（SELECT * FROM t1 WHERE pk =？）

我收到以下错误：

[SAP AG] [LIBODBCHDB SO] [HDBODBC]常规错误；参数数目错误292

这种SQL语句是否有某些限制？或者这是一个错误？

我将在后续评论中提供ODBC API跟踪。

Seb

4条回答
派大星 ヾ
2020-08-26 21:14

附加了ODBC API跟踪...我在做错什么吗？！？

      
 
 libSQLDBCHDB 2.2.23.1499440855
 系统：Linux/X64
 建立于：2017-07-07 18:15:01
 分公司：未知
 应用：fglrun


 SQLAllocHandle 2017-09-07 14：54：02.697746
 HandleType [输入]：SQL_HANDLE_ENV
 InputHandle [输入]：0x0000000000000000
 OutputHandlePtr [输出]：0x000060d00000ac90
 SQLRETURN：SQL_SUCCESS


 SQLSetEnvAttr 2017-09-07 14：54：02.697772
 EnvironmentHandle [输入]：0x000060d00000ac90
 属性[输入]：SQL_ATTR_ODBC_VERSION
 ValuePtr [输入]：SQL_OV_ODBC3
 StringLength [in]：-5
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.697844
 HandleType [输入]：SQL_HANDLE_DBC
 InputHandle [输入]：0x000060d00000ac90
 OutputHandlePtr [输出]：0x000061a000010e89
 SQLRETURN：SQL_SUCCESS


 SQLConnect 2017-09-07 14：54：02.697902
 ConnectionHandle [输入]：0x000061a000010e89
 ServerName [输入]：HANADB1
 NameLength1 [in]：SQL_NTS
 用户名[输入]：hdbuser
 NameLength2 [in]：SQL_NTS
 enc：ASCII
 ODBC连接属性：
         #当地：ISO-8859-15
         数据库名称：TEST1
 SQLRETURN：SQL_SUCCESS


 SQLSetConnectAttr 2017-09-07 14：54：02.704993
 ConnectionHandle [输入]：0x000061a000010e89
 属性[输入]：SQL_ATTR_AUTOCOMMIT
 StringLength [in]：0
 enc：ASCII
 ValuePtr [输入]：SQL_AUTOCOMMIT_OFF
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.705015
 HandleType [输入]：SQL_HANDLE_STMT
 InputHandle [输入]：0x000061a000010e89
 OutputHandlePtr [输出]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLExecDirect 2017-09-07 14：54：02.705042
 StatementHandle [输入]：0x000061400000e460
 StatementText [in]："从m_database选择版本；"
 TextLength [in]：SQL_NTS
 enc：ASCII
 SQLRETURN：SQL_SUCCESS


 SQLBindCol 2017-09-07 14：54：02.705760
 StatementHandle [输入]：0x000061400000e460
 ColumnNumber [输入]：1
 TargetType [输入]：SQL_C_CHAR
 目标值[输入/输出]：0x00007ffdf999e7a0
 BufferLength [in]：100
 StrLen_or_IndPtr [输入/输出]：0
 SQLRETURN：SQL_SUCCESS


 SQLFetch 2017-09-07 14：54：02.705783
  -> SQLExtendedFetch
 SQLExtendedFetch 2017-09-07 14：54：02.705788
 StatementHandle [输入]：0x000061400000e460
 FetchOrientation [in]：SQL_FETCH_NEXT
 FetchOffset [输入]：0
 RowCountPtr [out]：0x0000000000000000
 RowStatusArray [输出]：0x0000000000000000
 SQLRETURN：SQL_SUCCESS
  <-SQLExtendedFetch


 SQLCloseCursor 2017-09-07 14：54：02.705821
 StatementHandle [输入]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLFreeHandle 2017-09-07 14：54：02.705843
 HandleType [输入]：SQL_HANDLE_STMT
 提手[输入]：0x000061400000e460
 SQLRETURN：SQL_SUCCESS


 SQLAllocHandle 2017-09-07 14：54：02.705973
 HandleType [输入]：SQL_HANDLE_STMT
 InputHandle [输入]：0x000061a000010e89
 OutputHandlePtr [输出]：0x000061400000e440
 SQLRETURN：SQL_SUCCESS


 SQLSetCursorName 2017-09-07 14：54：02.705994
 StatementHandle [输入]：0x000061400000e440
 CursorName [in]：scu1
 NameLength [in]：SQL_NTS
 SQLRETURN：SQL_SUCCESS


 SQLSetStmtAttr 2017-09-07 14：54：02.706128
 StatementHandle [输入]：0x000061400000e440
 属性[输入]：SQL_ATTR_NOSCAN
 StringLength [in]：SQL_NTS
 ValuePtr [输入]：SQL_NOSCAN_ON
 SQLRETURN：SQL_SUCCESS


 SQLPrepare 2017-09-07 14：54：02.706154
 StatementHandle [输入]：0x000061400000e440
 StatementText [in]："将本地临时表#tt2创建为（从t1中选择*，其中pk =？）"
 TextLength [in]：SQL_NTS
 enc：UCS2（LE）（本机）
 SQLRETURN：SQL_SUCCESS


 SQLBindParameter 2017-09-07 14：54：02.708007
 StatementHandle [输入]：0x000061400000e440
 ParameterNumber [输入]：1
 InputOutputType [输入]：SQL_PARAM_INPUT
 ValueType [输入]：SQL_C_LONG
 ParameterType [输入]：SQL_INTEGER
 ColumnSize [输入]：0
 DecimalDigits [in]：0
 ParameterValPtr [in]：0x000060200001e030
 BufferLength [输入/输出]：0
 StrLen_or_IndPtr [输入]：0x000060600000c350
 SQLRETURN：SQL_SUCCESS


 SQLExecute 2017年9月7日14：54：02.708047
 StatementHandle [输入]：0x000061400000e440
 SQLRETURN：SQL_ERROR


 SQLGetDiagRec 2017-09-07 14：54：02.714404
 HandleType [输入]：SQL_HANDLE_STMT
 处理[输入]：0x000061400000e440
 RecNumber [输入]：1
 缓冲区长度[输入]：513
 enc：ASCII
 SQLState [输出]：S1000
 NativeErrorPtr [输出]：292
 MessageText [out]：[SAP AG] [LIBODBCHDB SO] [HDBODBC]常规错误； 292个错误的参数数目
 TextLengthPtr [出]：76
 SQLRETURN：SQL_SUCCESS
 <CURRENT WRITE POSITION> <br> </pre>                                                                    <div class="appendcontent">
                                                        </div>
            </div>
           
            <div class="tool-group">
             <!-- cdn节点 回答操作 -->
<div class="cdn_question_answer102364"></div>
<script type="text/javascript">
  getquestioncaozuo(5,36471,102364);
</script>

                </div>
                </div>
             
                </div>
                <div class="comments-mod "  style="display: none; float:none;padding-top:10px;" id="comment_102364">
                    <div class="areabox clearfix">


                  <div class="input-group">
             <input type="text" placeholder="请输入评论内容，不少于5个字" AUTOCOMPLETE="off" class="comment-input form-control" name="content" />
                        <input type='hidden' value='0' name='replyauthor' />
              <span class="input-group-btn"><input type="button" value="评论"  class="btn btn-green" name="submit" onclick="addcomment(102364);"/> </span>
            </div>

                    </div>
                    <ul class="my-comments-list nav">
                        <li class="loading">
                        <img src='https://www.easysap.com/static/css/default/loading.gif' align='absmiddle' />
                        &nbsp;加载中...
                        </li>
                    </ul>
                </div>
                </div>

                         
   
               </div>
               </div>
     <div>
        
                 
        </div>
               </div>
                              <div class="noreplaytext bb">
<center><div>   <a href="https://www.easysap.com/q-36471.html">  查看其它4个回答
</a>
</div></center>
</div>             <!-- cdn 问答邀请 -->
<div class="cdn_question_invate"></div>		
<script type="text/javascript">
getquestioncaozuo(7,36471);
</script>
                                     <div class="new-answer bb">
       <h3 class="title">一周热门 <a href="content/solve" target="_blank" class="more">更多<font>&gt; </font></a></h3>
       <div class="inf-list">
          <ul class="clearfix">
                   
                        
                      </ul>
       </div>
    </div>
    
               </div>
    </div>


</div>

   </div>

   <div class="col-md-7  aside ">
   <div class="standing">
  <div class="positions bb" id="rankScroll">
      <h3 class="title">相关问答</h3>
      <ul>
      
                  <li class="no-video">
        <a href="https://www.easysap.com/q-109172.html" title="适用于SAP HANA的HANA Express 1 SP12 AWS SAP WebIDE-Builder'mtabuilder'不适用于工作区" >   适用于SAP HANA的HANA Express 1 SP12 AWS SAP WebIDE-Builder'mtabuilder'不适用于工作区 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-109172.html"  class="anum"> 4 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-109165.html" title="如何获取SAP HANA Express的di-space-enablement-ui" >   如何获取SAP HANA Express的di-space-enablement-ui </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-109165.html"  class="anum"> 4 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-108667.html" title="我的WebIDE有什么问题" >   我的WebIDE有什么问题 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-108667.html"  class="anum"> 2 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-108211.html" title="HANA CDS关联阻止ODBC正常工作" >   HANA CDS关联阻止ODBC正常工作 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-108211.html"  class="anum"> 2 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-108046.html" title="SAP HANA XSA WebIDE 2.0 SP 1：监视器-管理工具-审核日志" >   SAP HANA XSA WebIDE 2.0 SP 1：监视器-管理工具-审核日志 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-108046.html"  class="anum"> 10 个回答</a>
               </div>
              </li>
                                  
                </ul>
  </div>
  </div>
                                 


            <!--广告位5-->
           </div>
</div>
</div>

<div class="modal fade" id="dialogadopt">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">采纳回答</h4>
    </div>
    <div class="modal-body">

     <form class="form-horizontal"  name="editanswerForm"  method="post" >
        <input type="hidden"  value="36471" id="adopt_qid" name="qid"/>
        <input type="hidden" id="adopt_answer" value="0" name="aid"/>
        <table  class="table ">
            <tr valign="top">
                <td>向帮助了您的知道网友说句感谢的话吧!</td>
            </tr>
            <tr>
                <td>
                    <div class="inputbox mt15">
                        <textarea class="form-control" id="adopt_txtcontent"  name="content">非常感谢!</textarea>
                    </div>
                </td>
            </tr>
            <tr>
                <td><button type="button" id="adoptbtn" class="btn btn-success" >确&nbsp;认</button></td>
            </tr>
        </table>
    </form>

    </div>

  </div>
</div>
</div>
<script>
function checkpay(_qid,_aid){

var url="https://www.easysap.com/answerpay/poppay/"+_qid+"/"+_aid+".html";
var myModalTrigger = new $.zui.ModalTrigger({url:url});
myModalTrigger.show({
'backdrop':'static'
});


}
if(typeof($(".work-show-box").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".work-show-box").find("img").attr("data-original");
$(".work-show-box").find("img").attr("src",imgurl);
}
$(".work-show-box").find("img").attr("data-toggle","lightbox");

$("#adoptbtn").click(function(){
  var data={
    			content:$("#adopt_txtcontent").val(),
    			qid:$("#adopt_qid").val(),
    			aid:$("#adopt_answer").val()

    	}

$.ajax({
    //提交数据的类型 POST GET
    type:"POST",
    //提交的网址
    url:"https://www.easysap.com/question/ajaxadopt.html",
    //提交的数据
    data:data,
    //返回数据的格式
    datatype: "json",//"xml", "html", "script", "json", "jsonp", "text".
    //在请求之前调用的函数
    beforeSend:function(){},
    //成功返回之后调用的函数
    success:function(data){
    	var data=eval("("+data+")");
       if(data.message=='ok'){
    	   new $.zui.Messager('采纳成功!', {
    		   type: 'success',
    		   close: true,
       	    placement: 'center' // 定义显示位置
       	}).show();
    	   setTimeout(function(){
               window.location.reload();
           },1500);
       }else{
    	   new $.zui.Messager(data.message, {
        	   close: true,
        	    placement: 'center' // 定义显示位置
        	}).show();
       }


    }   ,
    //调用执行后调用的函数
    complete: function(XMLHttpRequest, textStatus){

    },
    //调用出错执行的函数
    error: function(){
        //请求出错处理
    }
 });
})

</script>
</div>
<!-- 编辑标签 -->

<div class="modal fade" id="dialog_tag">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">编辑标签</h4>
    </div>
    <div class="modal-body">

    <form onsubmit=" return checktagsubmit()" class="form-horizontal"  name="edittagForm"  action="https://www.easysap.com/question/edittag.html" method="post" >
        <input type="hidden"  value="36471" name="qid"/>

                <p>最多设置5个标签!</p>

                    <div class="inputbox mar-t-1">
                      <div class=" dongtai ">
          <div class="tags">
                       <div class="tag"><span tagid="122">SAP HANA, express edition</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="2381">        odbc</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="13628">create local temporary table</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="13629">sqlbindparameter</span><i class="fa fa-close"></i></div>
                       </div>
            <input type="text" autocomplete="off"  data-toggle="tooltip" data-placement="bottom" title="" placeholder="检索标签，最多添加5个,添加标签更容易被回答" data-original-title="检索标签，最多添加5个" name="topic_tagset" value=""  class="txt_taginput" >
            <i class="fa fa-search"></i>
           <div class="tagsearch">
        
          
           </div>
            
          </div>
          
                        <input type="hidden"  class="form-control" id="qtags" name="qtags" value=""/>
                    </div>

            <div class="mar-t-1">

                <button type="submit" class="btn btn-success">保存</button>
                 <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
      </div>
    </form>

    </div>

  </div>
</div>
</div>
 <!-- 举报 -->
<div class="modal fade panel-report" id="dialog_inform">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">举报内容</h4>
    </div>
    <div class="modal-body">

<form id="rp_form" class="rp_form"  action="https://www.easysap.com/inform/add.html" method="post">
<input value="" type="hidden" name="qid" id="myqid">
<input value="" type="hidden" name="aid" id="myaid">
<input value="" type="hidden" name="qtitle" id="myqtitle">
<div class="js-group-type group group-2">
<h4>检举类型</h4><ul>
<li class="js-report-con">
<label><input type="radio" name="group-type" value="1"><span>检举内容</span></label>
</li>
<li class="js-report-user">
<label><input type="radio" name="group-type" value="2"><span>检举用户</span></label>
</li>
</ul>
</div>
<div class="group group-2">
<h4>检举原因</h4><div class="list">
<ul>
<li>
<label class="reason-btn"><input type="radio" name="type" value="4"><span>广告推广</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="5"><span>恶意灌水</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="6"><span>回答内容与提问无关</span>
</label>
</li>
<li>
<label class="copy-ans-btn"><input type="radio" name="type" value="7"><span>抄袭答案</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="8"><span>其他</span></label>
</li>
</ul>
</div>
</div>
<div class="group group-3">
<h4>检举说明(必填)</h4>
<div class="textarea">
<ul class="anslist" style="display:none;line-height:20px;overflow:auto;height:171px;">
</ul>
<textarea name="content" maxlength="200" placeholder="请输入描述200个字以内">
</textarea>
</div>
</div>
    <div class="mar-t-1">

                <button type="submit" id="btninform" class="btn btn-success">提交</button>
                 <button type="button" class="btn btn-default mar-ly-1" data-dismiss="modal">关闭</button>
      </div>
</form>


    </div>

  </div>
</div>
</div>

<!-- 微信分享 -->
<div class="modal share-wechat animated" style="display: none;"><div class="modal-dialog"><div class="modal-content"><div class="modal-header"><button type="button" data-dismiss="modal" class="close">×</button></div> <div class="modal-body"><h5>打开微信“扫一扫”，打开网页后点击屏幕右上角分享按钮</h5> <div data-url="https://www.easysap.com/answer/36471/102364.html" class="qrcode" title="https://www.easysap.com/answer/36471/102364.html"><canvas width="170" height="170" style="display: none;"></canvas>
<div id="qr_wxcode">
</div></div></div> <div class="modal-footer"></div></div></div></div>

<!-- 设置付费金额 -->
<div class="modal pay-money animated" style="display: none;">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">

<button type="button" data-dismiss="modal" class="close">×</button>
</div>
<div class="modal-body">
<h5>付费偷看金额在0.1-10元之间</h5>
<div class="mar-t-1">

<input type="number" value="0" id="chakanjine" class="form-control" />

</div>
 <button id="comfirm_pay" class="btn btn-success mar-t-1">确定</button>
</div>
 <div class="modal-footer">

 </div>
 </div>
 </div>
 </div>

 <!-- 邀请回答 -->

<div class="modal fade" id="dialog_invate" >
<div class="modal-dialog" style="width:700px;top:-30px;">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title"></h4>
       <div class="m_invateinfo">
              <span class="m_i_text""> 您已邀请<span class="m_i_persionnum">0</span>人回答</span>
       <span  data-toggle="popover" data-tip-class="popover-info" data-html="ture" data-placement="bottom" data-content="" title="我的邀请列表" class="m_i_view">查看邀请</span>

       <div class="m_i_warrper">
        <input data-qid="36471" type="text" id="m_i_searchusertxt" class="m_i_search" placeholder="搜索你想邀请的人">
        <i class="fa fa-search"></i>
       </div>

       </div>
    </div>
    <div class="modal-body" >
     <!-- 邀请回答 -->
    <ul class="trigger-menu m_invate_tab" data-pjax-container="#list-container">
 <li class="active" data-qid="36471" data-item="1"><a href="javascript:">擅长该话题的人</a></li>
<li class="" data-qid="36471" data-item="2"><a href="javascript:"> 回答过该话题的人</a></li>
<li class="" data-qid="36471" data-item="3"><a href="javascript:">我关注的人</a></li>

 </ul>
     <!-- 邀请回答列表 -->
       <div class="m_invatelist">
       </div>

    </div>

  </div>
</div>
</div>
  <script>
  getquestioncaozuo(1,36471);
  getquestioncaozuo(2,36471);
  getquestioncaozuo(3,36471);
  getquestioncaozuo(4,36471);
  $(".btnshowall").click(function(){
    $(".shortquestioncontent").toggle();
    $(".hidequestioncontent").toggle();
  });

//根据分类读取改分类下有回答的人
  function showeditor(){
$(".canwirteanswer").slideDown();
scrollTo(0,$('#showanswerform').offset().top-200);


  }


    var needcode=0;
      var g_id = 6;
  var qid = 36471;
  function listertext(){
  	 var _content=$("#anscontent").val();
  	 if(_content.length>0&&g_id!=1){

  		 $(".code_hint").show();
  	 }else{
  		 $(".code_hint").hide();
  	 }
  }
    var mobile_localyuyin=0;
  //  var userAgent = window.navigator.userAgent.toLowerCase();
//  $.browser.msie8 = $.browser.msie && /msie 8\.0/i.test(userAgent);
 // if($.browser.msie8==true){
//  var mobile_localyuyin=0;
 // }
  var targetplay=null;
  function checktagsubmit(){
if(gettagsnum()<=0){
alert("请设置标签");
return false;
}
if(gettagsnum()>5){
    alert("最多添加5个标签");
    return false;
}
 var _tagstr=gettaglist();
 $("#qtags").val(_tagstr);
 
  }
  $(".txt_taginput").on(" input propertychange",function(){
 var _txtval=$(this).val();
 if(_txtval.length>1){

 //检索标签信息
 var _data={tagname:_txtval};
 var _url="https://www.easysap.com/tags/ajaxsearch.html";
 function success(result){
 console.log(result)
 if(result.code==200){
 console.log(_txtval)
  $(".tagsearch").html("");
for(var i=0;i<result.taglist.length;i++){

 var _msg=result.taglist[i].tagname
 
           $(".tagsearch").append('<div class="tagitem" tagid="'+result.taglist[i].id+'">'+_msg+'</div>');
}
$(".tagsearch").show();
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
var _tagid=$.trim($(this).attr("tagid"));
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span tagid="'+_tagid+'">'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
        
 }
 
 }
 ajaxpost(_url,_data,success);
 }else{
$(".tagsearch").html("");
$(".tagsearch").hide();
 }
})
function checktag(_tagname){
var tagrepeat=false;
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).html());
if(_tagnametmp==_tagname){
tagrepeat=true;
}
})
return tagrepeat;
}
function gettaglist(){
var taglist='';
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).attr("tagid"));
taglist=taglist+_tagnametmp+",";

})
taglist=taglist.substring(0,taglist.length-1);

return taglist;
}
function gettagsnum(){
      return $(".dongtai .tags .tag").length;
}
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span>'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
  $(".yuyinplay").click(function(){
  	targetplay=$(this);
  	var _serverid=targetplay.attr("id");
  	   if(_serverid == '') {
  			alert('语音文件丢失');
             return;
         }
  	   $(".wtip").html("免费偷听");
  	   targetplay.find(".wtip").html("播放中..");
  	   if(mobile_localyuyin==1){
  		 $(".htmlview").removeClass("hide");
   $(".ieview").addClass("hide");

  		   var myAudio =targetplay.find("#voiceaudio")[0];
  	  	  // myAudio.pause();
  	  	   //myAudio.play();
  	  	   if(myAudio.paused){
  	  		   targetplay.find(".wtip").html("播放中..");
  	             myAudio.play();
  	         }else{
  	      	   targetplay.find(".wtip").html("暂停..");
  	             myAudio.pause();
  	         }
  	  	   function endfun(){ targetplay.find(".wtip").html("播放结束");alert("播放结束!")}
  	  	   var   is_playFinish = setInterval(function(){
  	             if( myAudio.ended){

  	          	   endfun();
  	  	                    window.clearInterval(is_playFinish);
  	             }
  	     }, 10);
  	   }else{

  		 $(".ieview").removeClass("hide");
  		   $(".htmlview").addClass("hide");
  	   }




  })
function deleteanswer(current_aid){
  if(confirm("是否删除此回答?")){
window.location.href=g_site_url + "index.php" + query + "question/deleteanswer/"+current_aid+"/36471";
  
  }

}
  function adoptanswer(aid) {

      $("#adopt_answer").val(aid);

      $('#dialogadopt').modal('show');
}
  //编辑标签
  function edittag() {
 	 $('#dialog_tag').modal('show');

 }
  if(typeof($(".show-content").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".show-content").find("img").attr("data-original");
$(".show-content").find("img").attr("src",imgurl);
}
$(".show-content").find("img").attr("data-toggle","lightbox");

  var category1 = [["42","S/4HANA"],["17","Fiori"],["45","UI5"],["20","HANA"],["2","ABAP"],["16","FICO"],["47","SD"],["26","MM"],["36","PP"],["34","PM"],["37","PS"],["54","WM"],["38","QM"],["12","CRM"],["8","BPC"],["9","BPM"],["11","BW"],["7","BO"],["32","PI"],["44","PO"],["6","Basis"],["46","SCM"],["49","SRM"],["21","HCM"],["24","Logistics Execution"],["33","PLM"],["15","EWM"],["41","RPA"],["4","Ariba"],["50","SuccessFactors"],["55","Workflow"],["3","APO"],["5","B1"],["10","BSP"],["13","DATA"],["22","HTML5"],["53","Web Dynpro"],["18","GRC"],["43","SAP Cloud"],["19","GTS"],["23","Hybris"],["25","Lumira"],["27","Mobile"],["28","NetWeaver"],["1","SAP Industry Solutions"],["35","PORTAL"],["48","SOLMAN"],["52","UI"],["59","Machine Learning"],["56","Big Data"],["57","Blockchain"],["58","Training"],["31","Others"]];
  var category2 = [];
  var category3 = [];
  var selectedcid = "20,0,0";
  //修改分类
  function change_category() {
      var category1 = $("#category1 option:selected").val();
              var category2 = $("#category2 option:selected").val();
              var category3 = $("#category3 option:selected").val();
              if (category1 > 0) {
      $("#categoryid").val(category1);
      }
      if (category2 > 0) {
      $("#categoryid").val(category2);
      }
      if (category3 > 0) {
      $("#categoryid").val(category3);
      }
      $("#catedialog").model("hide");
              $("form[name='editcategoryForm']").submit();
      }
  //投诉
  function openinform(qid ,qtitle,aid) {
  $("#myqid").val(qid);
  $("#myqtitle").val(qtitle);
  $("#myaid").val(aid);
 	 $('#dialog_inform').modal('show');

 }
  $(".showcommentid").each(function(){
       var dataid=$(this).attr("data-id");
       show_comment(dataid);
  });
  function show_comment(answerid) {
      if ($("#comment_" + answerid).css("display") === "none") {
      load_comment(answerid);
              $("#comment_" + answerid).slideDown();
      } else {
      $("#comment_" + answerid).slideUp();
      }
      }
  //添加评论
  function addcomment(answerid) {
  var content = $("#comment_" + answerid + " input[name='content']").val();
  var replyauthor = $("#comment_" + answerid + " input[name='replyauthor']").val();
  if (g_uid == 0){
      login();
      return false;
  }
  if (bytes($.trim(content)) < 5){
  alert("评论内容不能少于5字");
          return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/addcomment.html",
          data: "content=" + content + "&answerid=" + answerid+"&replyauthor="+replyauthor,
          success: function(status) {
          if (status == '1') {
          $("#comment_" + answerid + " input[name='content']").val("");
                  load_comment(answerid);
          }else{
          	if(status == '-2'){
          		alert("问题已经关闭，无法评论");
          	}
          }
          }
  });
  }
  
  //删除评论
  function deletecomment(commentid, answerid) {
  if (!confirm("确认删除该评论?")) {
  return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/deletecomment.html",
          data: "commentid=" + commentid + "&answerid=" + answerid,
          success: function(status) {
          if (status == '1') {
          load_comment(answerid);
          }
          }
  });
  }
  //加载评论
  function load_comment(answerid){
  $.ajax({
  type: "GET",
          cache:false,
          url: "https://www.easysap.com/index.php?answer/ajaxviewcomment/" + answerid,
          success: function(comments) {
          $("#comment_" + answerid + " .my-comments-list").html(comments);
          }
  });
  }

  function replycomment(commentauthorid,answerid){
      var comment_author = $("#comment_author_"+commentauthorid).attr("title");
      $("#comment_"+answerid+" .comment-input").focus();
      $("#comment_"+answerid+" .comment-input").val("回复 "+comment_author+" :");
      $("#comment_" + answerid + " input[name='replyauthor']").val(commentauthorid);
  }
$(function(){
  initcategory(category1);
          fillcategory(category2, $("#category1 option:selected").val(), "category2");
          fillcategory(category3, $("#category2 option:selected").val(), "category3");
        	var qrurl="https://www.easysap.com/answer/36471/102364.html";
//微信二维码生成
$('#qr_wxcode').qrcode(qrurl);
     //显示微信二维码
     $(".share-weixin").click(function(){
    	 $(".share-wechat").show();
     });
     //关闭微信二维码
     $(".close").click(function(){
    	 $(".share-wechat").hide();
    	 $(".pay-money").hide();
     });
  
     $(".button_agree").click(function(){
             var supportobj = $(this);
                     var answerid = $(this).attr("id");
                     $.ajax({
                     type: "GET",
                             url:"https://www.easysap.com/index.php?answer/ajaxhassupport/" + answerid,
                             cache: false,
                             success: function(hassupport){
                             if (hassupport != '1'){






                                     $.ajax({
                                     type: "GET",
                                             cache:false,
                                             url: "https://www.easysap.com/index.php?answer/ajaxaddsupport/" + answerid,
                                             success: function(comments) {

                                             supportobj.find("span").html(comments+"人赞");
                                             }
                                     });
                             }else{
                            	 alert("您已经赞过");
                             }
                             }
                     });
             });

})


                </script>
<div id="usercard" style="position:absolute;z-index:999999999;"></div>
   <script src="https://www.easysap.com/static/js/jquery.lazyload.min.js" type="text/javascript"></script>
<script>

   

                    $("img.lazy").lazyload({effect: "fadeIn" });

</script>

  <div class="side-tool" id="to_top"><ul><li data-placement="left" data-toggle="tooltip" data-container="body" data-original-title="回到顶部" >
    <a href="#" class="function-button"><i class="fa fa-angle-up"></i></a>
    </li>



      </ul></div>
      <script>
window.onload = function(){
  $(".edui-upload-video").attr("preload","");
  var oTop = document.getElementById("to_top");

  var screenw = document.documentElement.clientWidth || document.body.clientWidth;
  var screenh = document.documentElement.clientHeight || document.body.clientHeight;
  window.onscroll = function(){
    var scrolltop = document.documentElement.scrollTop || document.body.scrollTop;
 
    if(scrolltop<=screenh){
    	oTop.style.display="none";
    }else{
    	oTop.style.display="block";
    }
    if(scrolltop>30){
     
    	$(".scrollshow").show();
    }else{
    	$(".scrollshow").hide();
    }
  }
  oTop.onclick = function(){
    document.documentElement.scrollTop = document.body.scrollTop =0;
  }
}

</script>

    <footer id="footer">
        <div class="footer-wrapper">
            <div class="footer-wrapper-top">
                <div class="footer-wrapper-top-left">
                    <a href="https://www.easysap.com/tags.html"><i class="hide"></i>标签大全</a>
                    <a href="https://www.easysap.com/new.html" >站内问题</a>
                    <a href="https://www.easysap.com/topic/default.html" >专栏文章</a>
                    <a href="https://www.easysap.com/expert/default.html">站内专家</a>
                    <a href="https://www.easysap.com/category/viewtopic/hot" >站内话题</a>
                    <a href="https://www.easysap.com/note/list.html" >站内公告</a>
                     <a href="https://www.easysap.com/rule/index.html">财富值规则</a>
                       <script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?91cd836d35676d254ee158461ecf506f";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script>                     
                </div>
               
            </div>
            
                        
         
           
            <div class="footer-wrapper-bottom space-footer-bottom">
                <a href="http://www.12377.cn/" target="_blank">网上有害信息举报专区</a>
                    <i></i>
                    <a href="https://beian.miit.gov.cn/" target="_blank">京ICP备2021023650号</a>
                <i></i>
                <span ><a href="https://www.easysap.com/rss/articlelist.xml" target="_blank">站内文章地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/list.xml" target="_blank">站内问答地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/userspace.xml" target="_blank">站内作者地图xml</a></span>
               <i></i>
                <span><a href="https://www.easysap.com/rss/tag.xml" target="_blank">站内标签地图xml</a></span>
            
              <!--<span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>-->
              <span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>
            </div>
        </div>
    </footer>

</div>

</body>
</html>