{"id":126,"date":"2009-12-01T17:42:16","date_gmt":"2009-12-01T09:42:16","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/index.php\/2009\/12\/01\/delphi%e4%bd%bf%e7%94%a8adoquery%e7%9a%84%e5%8b%95%e6%85%8b%e5%8f%83%e6%95%b8%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a0%85\/"},"modified":"2011-04-07T10:54:57","modified_gmt":"2011-04-07T02:54:57","slug":"delphi%e4%bd%bf%e7%94%a8adoquery%e7%9a%84%e5%8b%95%e6%85%8b%e5%8f%83%e6%95%b8%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a0%85","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=126","title":{"rendered":"DELPHI\u4f7f\u7528ADOQuery\u7684\u52d5\u614b\u53c3\u6578\u6ce8\u610f\u4e8b\u9805"},"content":{"rendered":"<p><font size=\"3\">WGLProcstat2Query.Close;     <br \/>WGLProcstat2Query.SQL.Clear;      <br \/>WGLProcstat2Query.SQL.Add(&#8216;select * from dbo.gdsinfomt, dbo.procstat&#8217;);      <br \/>WGLProcstat2Query.SQL.Add(&#8216;where ((dbo.gdsinfomt.gdsno=:<font color=\"#ff0000\">E_gdsno<\/font>) and (dbo.procstat.gdsno=:<font color=\"#ff0000\">E_gdsno<\/font>))&#8217;);      <br \/>\/\/Roger 20091201 \u52d5\u614b\u53c3\u6578\u82e5\u4f7f\u7528\u76f8\u540c\u7684\u53c3\u6578\u540d\u7a31\u5169\u500b\u4ee5\u4e0a\uff0c\u8acb\u6539\u7528\u9663\u5217\u65b9\u5f0f\uff0c\u4e26\u628a\u6bcf\u500b\u53c3\u6578\u90fd\u7576\u6210\u7368\u7acb\u53c3\u6578      <br \/><\/font><font size=\"3\"><font color=\"#ff0000\">WGLProcstat2Query.Parameters[0].Value:= Trim(GdsNoEdit.Text);       <br \/>WGLProcstat2Query.Parameters[1].Value:= Trim(GdsNoEdit.Text);<\/font>      <br \/>WGLProcstat2Query.Open;      <br \/>WGLProcstat2Query.RecordCount;<\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<p><font size=\"3\">\u4e0a\u9762\u7684\u4f8b\u5b50\uff0c\u82e5\u6709\u4f7f\u7528\u52d5\u614b SQL \u53c3\u6578 :E_gdsno \u76f8\u540c\u7684\u53c3\u6578\u5169\u500b\u4ee5\u4e0a\uff1a     <br \/>\u8acb\u6539\u7528\u9663\u5217\u65b9\u5f0f\uff0c\u4e26\u628a\u6bcf\u500b\u53c3\u6578\u90fd\u7576\u6210\u7368\u7acb\u53c3\u6578\u7d66\u503c\u624d\u884c      <br \/><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WGLProcstat2Query.Close;     WGLProcstat2Query.SQL.Clear;      WGLProcstat2Query.SQL.Add(&#8216;select * from dbo.gdsinfomt, dbo.procstat&#8217;);      WGLProcstat2Query.SQL.Add(&#8216;where ((dbo.gdsinfomt.gdsno=:E_gdsno) and (dbo.procstat.gdsno=:E_gdsno))&#8217;);      \/\/Roger 20091201 \u52d5\u614b\u53c3\u6578\u82e5\u4f7f\u7528\u76f8\u540c\u7684\u53c3\u6578\u540d\u7a31\u5169\u500b\u4ee5\u4e0a\uff0c\u8acb\u6539\u7528\u9663\u5217\u65b9\u5f0f\uff0c\u4e26\u628a\u6bcf\u500b\u53c3\u6578\u90fd\u7576\u6210\u7368\u7acb\u53c3\u6578      WGLProcstat2Query.Parameters[0].Value:= Trim(GdsNoEdit.Text);       WGLProcstat2Query.Parameters[1].Value:= Trim(GdsNoEdit.Text);      WGLProcstat2Query.Open;  [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[34],"tags":[92,539,129],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/126"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=126"}],"version-history":[{"count":2,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/126\/revisions"}],"predecessor-version":[{"id":573,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/126\/revisions\/573"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=126"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}