{"id":6913,"date":"2019-10-23T08:27:21","date_gmt":"2019-10-23T00:27:21","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=6913"},"modified":"2019-10-23T08:27:21","modified_gmt":"2019-10-23T00:27:21","slug":"t100-r-v-%e5%b8%a6%e5%80%bc%e6%a0%a1%e9%aa%8cadzi220","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=6913","title":{"rendered":"T100 r.v \u5e26\u503c\u6821\u9a8c(adzi220)"},"content":{"rendered":"<p><strong>r.v \u5e26\u503c\u6821\u9a8c(adzi220)<\/strong><\/p>\n<p>\u6267\u884c\u6307\u4ee4\uff1ar.v \u6216 r.r adzi220<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1344\" height=\"670\" class=\"wp-image-6914\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-263.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-263.jpeg 1344w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-263-768x383.jpeg 768w\" sizes=\"auto, (max-width: 1344px) 100vw, 1344px\" \/><\/p>\n<p>\u672c\u652f\u4f5c\u4e1a\u7684\u76ee\u7684\u662f\u4e3a\u4e86\u8ba9\u5f00\u53d1\u4eba\u5458\u53ef\u4ee5\u900f\u8fc7\u8bbe\u5b9a\u7684\u65b9\u5f0f\u5904\u7406\u6821\u9a8c\u5e26\u503c\uff0c\u8fd9\u4e9b\u8bbe\u5b9a\u53ef\u4ee5\u8ba9\u5f00\u53d1\u4eba\u5458\u91cd\u65b0\u4f7f\u7528\u8fd9\u4e9b\u8bbe\u5b9a\uff0c\u52a0\u5feb\u5f00\u53d1\u901f\u5ea6\u3002<\/p>\n<ul>\n<li><strong>\u884c\u4e1a\u522b<\/strong><\/li>\n<\/ul>\n<p>\u65b0\u589e\u6821\u9a8c\u5e26\u503c\u65f6\uff0c\u9996\u5148\u8981\u51b3\u5b9a\u5f52\u5c5e\u884c\u4e1a\u522b\uff0c\u9ed8\u8ba4\u503c\u4e3a\u6807\u51c6\u884c\u4e1a(sd)\u4e0d\u7528\u7279\u522b\u9009\u53d6\u3002\u6b64\u5b57\u6bb5\u4e0e\u6821\u9a8c\u5e26\u503c\u547d\u540d\u539f\u5219\u6709\u5173\uff1a\u5f53\u9009\u62e9\u5176\u4ed6\u884c\u4e1a\u522b(\u4f8b\u5982:\u5236\u836f\u4e1a ph)\uff0c<\/p>\n<p>\u5219\u6821\u9a8c\u5e26\u503c\u547d\u540d\u5fc5\u987b\u4ee5_ph \u4e3a\u7ed3\u5c3e\u3002<\/p>\n<ul>\n<li><strong>\u6821\u9a8c\u5e26\u503c\u578b\u6001<\/strong><\/li>\n<\/ul>\n<p><sup><img loading=\"lazy\" decoding=\"async\" width=\"399\" height=\"65\" class=\"wp-image-6915\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-264.jpeg\" \/><img loading=\"lazy\" decoding=\"async\" width=\"357\" height=\"90\" class=\"wp-image-6916\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-265.jpeg\" \/><\/sup><\/p>\n<p>\u76ee\u524d\u652f\u6301\u4e09\u79cd\u6821\u9a8c\u5e26\u503c\u60c5\u5883\uff1a<\/p>\n<p>A. \u68c0\u67e5\u5b58\u5728\uff1a\u901a\u5e38\u4f7f\u7528\u5728\u8f93\u5165\u6570\u636e\u79bb\u5f00\u65f6\u68c0\u67e5\u8f93\u5165\u503c\u662f\u5426\u5b58\u5728\uff0c\u5f53\u68c0\u67e5\u4e0d\u5b58\u5728\u65f6\u4f1a\u63d0\u793a\u9519\u8bef\u8baf\u606f\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"401\" class=\"wp-image-6917\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-266.jpeg\" \/><\/p>\n<ol>\n<li>\u5e26\u503c\uff1a\u901a\u5e38\u4f7f\u7528\u5728\u3002<\/li>\n<li>\u68c0\u67e5\u5b58\u5728\u5e76\u5e26\u503c\uff1a\u901a\u5e38\u4f7f\u7528\u5728\u6570\u636e\u68c0\u67e5\u5b58\u5728\u4e4b\u540e\u540c\u65f6\u5c06\u7b26\u5408\u7684\u6570\u636e\u5e26\u56de\uff0c\u4f8b\u5982[\u5173\u8054\u6807\u7b7e\u7f16\u53f7]\u8f93\u5165\u2019B001\u2019\u540e\uff0c\u68c0\u67e5\u65e0\u8bef\u5c31\u4f1a\u540c\u65f6\u5e26\u51fa\u5176\u8bf4\u660e\u2019\u826f\u54c1\u5e93\u4f4d\u2019\u3002<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"311\" height=\"115\" class=\"wp-image-6918\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-267.jpeg\" \/><\/p>\n<ul>\n<li><strong>\u5ba2\u5236\u6807\u793a<\/strong><\/li>\n<\/ul>\n<p><sup><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"150\" class=\"wp-image-6919\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-268.jpeg\" \/><\/sup><\/p>\n<p>\u6b64\u5b57\u6bb5\u7531\u7a0b\u5e8f\u81ea\u52a8\u63a7\u5236\uff0c\u5728\u6807\u51c6(\u4ea7\u54c1\u4e2d\u5fc3)\u73af\u5883\u65b0\u589e\u6821\u9a8c\u5e26\u503c\u65f6\uff0c\u6b64\u5b57\u6bb5(\u4e0d\u6253\u52fe)\uff0c<\/p>\n<p>\u5728\u5ba2\u6237\u73af\u5883\u65b0\u589e\u65b0\u589e\u6821\u9a8c\u5e26\u503c\u65f6\uff0c\u6b64\u5b57\u6bb5(\u6253\u52fe)\uff0c\u5728\u5ba2\u6237\u73af\u5883\u4fee\u6539\u6807\u51c6\u7684\u6821\u9a8c\u5e26\u503c\u65f6\u4f1a\u5f39\u7a97\u8be2\u95ee\uff0c\u82e5\u786e\u8ba4\u8981\u6807<\/p>\n<p>\u51c6\u8f6c\u5ba2\u5236\u5219\u6b64\u5b57\u6bb5(\u6253\u52fe)\u3002<\/p>\n<ul>\n<li><strong>SQL \u6307\u4ee4\u4e0e\u53c2\u6570\u8bbe\u5b9a<\/strong><\/li>\n<\/ul>\n<p><strong>1<\/strong><\/p>\n<p><strong>1<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"896\" height=\"448\" class=\"wp-image-6920\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-269.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-269.jpeg 896w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-269-768x384.jpeg 768w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/><\/strong><\/p>\n<p><sup>\uf06c<\/sup> SQL \u6307\u4ee4\uff1a\u8ba9\u4f7f\u7528\u8005\u81ea\u884c\u64b0\u5199\u5f00\u7a97 SQL\uff0c\u4f46\u53ef\u900f\u8fc7[SQL \u8303\u4f8b\u7f16\u8f91]\u6765\u7ef4\u62a4\u5e38\u7528\u7684 SQL \u8bed\u53e5(\u5982\u4e0b\u56fe)\uff0c\u5e76\u5728\u4e0b<\/p>\n<p>\u62c9\u9009\u5355\u9009\u62e9\u6240\u9700\u8981\u7684 SQL \u8303\u4f8b\uff0c\u53ef\u51cf\u5c11\u7f16\u8f91 SQL \u7684\u65f6\u95f4\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"963\" height=\"457\" class=\"wp-image-6921\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-270.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-270.jpeg 963w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-270-768x364.jpeg 768w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/p>\n<p>SQL \u6307\u4ee4\u7684&lt;tag&gt;\uff1atag \u662f\u4e3a\u4e86\u8ba9\u6211\u4eec\u53ef\u4ee5\u5bb9\u6613\u5730\u89e3\u6790\u5f00\u53d1\u8005\u6240\u8bbe\u8ba1\u7684 SQL \u6307\u4ee4\uff0ctag \u4e4b\u95f4\u6709\u5f88\u5927\u7684\u5f39<\/p>\n<p>\u6027\uff0c\u4f8b\u5982\u5b50\u67e5\u8be2\u53ef\u4ee5\u76f4\u63a5\u5199\u5728\u8fd9\u91cc\uff0c\u8bf4\u660e\u5982\u4e0b<\/p>\n<p>\u2013 &lt;count&gt;\uff1a\u67e5\u8be2\u8bed\u6cd5\u7684 SELECT~FROM \u4e4b\u95f4\uff0c\u4f46\u5728&lt;field&gt;\u4e4b\u524d\uff0c\u901a\u5e38\u662f\u5c06 COUNT(*)\u8bed\u6cd5\u5199\u5728\u8fd9\u4e2a tag \u8303<\/p>\n<p>\u56f4\u5185\u3002<\/p>\n<p>\u2013 &lt;field&gt;\uff1a\u67e5\u8be2\u8bed\u6cd5\u7684 SELECT~FROM \u4e4b\u95f4\uff0c\u901a\u5e38\u662f\u5c06\u56de\u4f20\u5b57\u6bb5\u5199\u5728\u8fd9\u4e2a tag \u8303\u56f4\u5185\u3002<\/p>\n<p>\u2013 &lt;table&gt;\uff1a\u67e5\u8be2\u8bed\u6cd5\u7684 FROM~WHERE \u4e4b\u95f4\uff0c\u901a\u5e38\u662f\u5c06\u67e5\u8be2\u8bed\u6cd5\u6240\u7528\u5230\u7684 Table \u5199\u5728\u8fd9\u4e2a tag \u8303\u56f4\u5185\u3002<\/p>\n<p>\u2013 &lt;wc&gt;\uff1a\u67e5\u8be2\u8bed\u6cd5\u7684 WHERE~ORDER BY \u4e4b\u95f4\uff0c\u4f46\u5728&lt;inwc&gt;\u4e4b\u524d\uff0c\u901a\u5e38\u662f\u5c06\u67e5\u8be2\u8bed\u6cd5\u7684 WHERE \u6761\u4ef6\u5199\u5728\u8fd9\u4e2a tag \u8303\u56f4\u5185\u3002<\/p>\n<ul>\n<li>\u53c2\u6570\u8bbe\u5b9a\uff1a\u6700\u591a 9 \u7ec4\uff0c\u53ea\u63a5\u53d7 arg1\u3001arg2\u3001\u2026\u3001arg9\u3002<\/li>\n<li>\u53ef\u4f7f\u7528\u7684\u516c\u7528\u53d8\u91cf\uff1a\u5728 SQL \u6307\u4ee4\u5185\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u5217\u4e3e\u51fa\u7684\u516c\u7528\u53d8\u91cf\uff0c\u7a0b\u5e8f\u5728\u6267\u884c\u65f6\u4f1a\u81ea\u52a8\u66ff\u6362\u8fd9\u4e9b\u516c\u7528\u53d8\u91cf\u3002<\/li>\n<\/ul>\n<p>\u4e09\u79cd\u6821\u9a8c\u5e26\u503c\u60c5\u5883\u7684 SQL \u8303\u4f8b\uff1a<\/p>\n<ol>\n<li>\u68c0\u67e5\u5b58\u5728\uff1a<\/li>\n<li>\u5e26\u503c\uff1a<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"70\" class=\"wp-image-6922\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-271.jpeg\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"769\" height=\"69\" class=\"wp-image-6923\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-272.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-272.jpeg 769w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-272-768x69.jpeg 768w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/p>\n<p>C. \u68c0\u67e5\u5b58\u5728\u5e76\u5e26\u503c\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"94\" class=\"wp-image-6924\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-273.jpeg\" \/><\/p>\n<p>\u4e5f\u53ef\u900f\u8fc7[SQL Builder]\u6765\u534f\u52a9\u5efa\u7f6e SQL(\u5982\u4e0b\u56fe\uff0c\u64cd\u4f5c\u65b9\u5f0f\u53ef\u53c2\u8003\u6863\uff1a[\u64cd\u4f5c\u624b\u518c]r.q,r.v \u4e4b SQL Builder \u8bf4\u660e.docx)\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"994\" height=\"780\" class=\"wp-image-6925\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-274.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-274.jpeg 994w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-274-768x603.jpeg 768w\" sizes=\"auto, (max-width: 994px) 100vw, 994px\" \/><\/p>\n<ul>\n<li><strong>\u4e0d\u5b58\u5728\u7684\u63d0\u793a\u8baf\u606f<\/strong><\/li>\n<\/ul>\n<p>\u53ef\u4ee5\u8bbe\u5b9a\u5f53\u68c0\u67e5\u4e0d\u5b58\u5728\u7684\u65f6\u5019\u8981\u51fa\u73b0\u751a\u4e48\u6837\u7684\u9519\u8bef\u8baf\u606f\u3002<\/p>\n<ul>\n<li><strong>\u5b58\u5728\u65f6\u7684\u989d\u5916\u5224\u65ad\u6761\u4ef6<\/strong><\/li>\n<\/ul>\n<p>\u82e5\u68c0\u67e5\u5b58\u5728\u6709\u5206\u5c42\u7ea7\u6761\u4ef6\u68c0\u67e5\uff0c\u5219\u53ef\u900f\u8fc7\u989d\u5916\u7684\u6761\u4ef6\u8bbe\u5b9a\u6765\u8fbe\u5230\u68c0\u67e5\u7684\u76ee\u7684\u3002<\/p>\n<ul>\n<li><strong>\u6821\u9a8c\u5e26\u503c\u6d4b\u8bd5\u5de5\u5177<\/strong><\/li>\n<\/ul>\n<p><sup><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"150\" class=\"wp-image-6926\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-275.jpeg\" \/><\/sup><\/p>\n<p>\u6b64\u529f\u80fd\u53ef\u4ee5\u534f\u52a9\u9a8c\u8bc1\u6240\u8bbe\u8ba1\u7684\u6821\u9a8c\u5e26\u503c\u662f\u5426\u6b63\u786e\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"823\" height=\"676\" class=\"wp-image-6927\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-276.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-276.jpeg 823w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-276-768x631.jpeg 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/p>\n<p><sup>\uf06c<\/sup> <strong>\u4fee\u6539\u548c\u5220\u9664\u65f6\u7684\u63d0\u9192<\/strong><\/p>\n<p>\u4fee\u6539\u548c\u5220\u9664\u6821\u9a8c\u5e26\u503c\u8bbe\u8ba1\u6570\u636e\u65f6\uff0c\u4f1a\u81ea\u52a8\u68c0\u67e5\u6b64\u6821\u9a8c\u5e26\u503c\u8bbe\u5b9a\u662f\u5426\u5728\u7a0b\u5e8f\u4e2d\u88ab\u4f7f\u7528\uff0c\u5e76\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u63d0\u9192\u753b\u9762\uff0c\u5efa\u8bae\u8981\u53bb\u8c03\u6574\u4e00\u4e0b\u8fd9\u4e9b\u7a0b\u5e8f\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"151\" class=\"wp-image-6928\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-277.jpeg\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-277.jpeg 901w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-277-768x129.jpeg 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/p>\n<ul>\n<li><strong>\u67e5\u8be2\u4f7f\u7528\u4e2d\u7a0b\u5e8f<\/strong><\/li>\n<\/ul>\n<p><sup><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"150\" class=\"wp-image-6929\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/10\/word-image-278.jpeg\" \/><\/sup><\/p>\n<p>\u6b64\u529f\u80fd\u53ef\u4ee5\u534f\u52a9\u5217\u51fa\u6b64\u6821\u9a8c\u5e26\u503c\u76ee\u524d\u88ab\u54ea\u4e9b\u7a0b\u5e8f\u547c\u53eb\u3002<\/p>\n<ul>\n<li><strong>\u5728\u7a0b\u5e8f\u4e2d\u5982\u4f55\u4f7f\u7528\u6821\u9a8c\u5e26\u503c\u8bbe\u5b9a<\/strong><\/li>\n<\/ul>\n<p>\u6821\u9a8c\u5e26\u503c libarary \u7684\u8bbe\u8ba1\u7684\u53d8\u91cf\u4e3b\u8981\u4f7f\u7528 top_global.inc \u4e2d g_chkparam.*\u5168\u5c40\u53d8\u91cf\uff0c\u4e3b\u8981\u7684 library \u90fd\u653e\u5728 com\/lib\/cl_chk_validate.4gl\uff0c\u5e95\u4e0b\u4e3a\u8303\u4f8b\uff1a<\/p>\n<p>\u4e00\u3001\u4ee5\u4e0b\u662f g_chkparam \u7684\u89c4\u5212\uff1a #cl_chk_validate.4gl \u4e13\u7528\u53d8\u6570<\/p>\n<p>DEFINE g_chkparam RECORD<\/p>\n<table>\n<tbody>\n<tr>\n<td>where<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u989d\u5916\u8bbe\u5b9a\u7684 WHERE \u6761\u4ef6<\/td>\n<\/tr>\n<tr>\n<td>default1<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e00\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default2<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e8c\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default3<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e09\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default4<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u56db\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default5<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e94\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default6<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u516d\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default7<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e03\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default8<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u516b\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>default9<\/td>\n<td>STRING,<\/td>\n<td>#\u76f8\u5173\u5b57\u6bb5\u4e5d\u7684\u9ed8\u8ba4\u503c<\/td>\n<\/tr>\n<tr>\n<td>arg1<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e00<\/td>\n<\/tr>\n<tr>\n<td>arg2<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e8c<\/td>\n<\/tr>\n<tr>\n<td>arg3<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e09<\/td>\n<\/tr>\n<tr>\n<td>arg4<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u56db<\/td>\n<\/tr>\n<tr>\n<td>arg5<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e94<\/td>\n<\/tr>\n<tr>\n<td>arg6<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u516d<\/td>\n<\/tr>\n<tr>\n<td>arg7<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e03<\/td>\n<\/tr>\n<tr>\n<td>arg8<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u516b<\/td>\n<\/tr>\n<tr>\n<td>arg9<\/td>\n<td>STRING,<\/td>\n<td>#\u5916\u90e8\u53c2\u6570\u4e5d<\/td>\n<\/tr>\n<tr>\n<td>return1<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e00<\/td>\n<\/tr>\n<tr>\n<td>return2<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e8c<\/td>\n<\/tr>\n<tr>\n<td>return3<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e09<\/td>\n<\/tr>\n<tr>\n<td>return4<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u56db<\/td>\n<\/tr>\n<tr>\n<td>return5<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e94<\/td>\n<\/tr>\n<tr>\n<td>return6<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u516d<\/td>\n<\/tr>\n<tr>\n<td>return7<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e03<\/td>\n<\/tr>\n<tr>\n<td>return8<\/td>\n<td>STRING,<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u516b<\/td>\n<\/tr>\n<tr>\n<td>return9<\/td>\n<td>STRING<\/td>\n<td>#\u56de\u4f20\u8d44\u6599\u4e5d<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>END RECORD<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>library \u7684\u4ecb\u7ecd\u548c\u4f7f\u7528\u8303\u4f8b<\/li>\n<\/ul>\n<ol>\n<li>\u68c0\u67e5\u5b58\u5728\u7684 library\uff1acl_chk_exist(p_chk_id)<\/li>\n<\/ol>\n<p>############################################################<\/p>\n<p>#+ @code<\/p>\n<p>#+ \u51fd\u5f0f\u76ee\u7684 \u68c0\u67e5\u662f\u5426\u5b58\u5728,\u6839\u636e\u5176 SQL(l_dzcd003)\u8fdb\u884c\u68c0\u67e5\u5b58\u5728,\u82e5\u6570\u636e\u4e0d\u5b58\u5728\u5219\u663e\u793a\u9519\u8bef\u8baf\u606f(l_dzcd004)<\/p>\n<p>#+ @param p_chk_id CHAR(20) \u6821\u9a8c\u5e26\u503c\u6807\u8bc6\u7b26<\/p>\n<p>#+ @return BOOLEAN FALSE(\u6570\u636e\u4e0d\u5b58\u5728\u6216 SQL \u8bed\u53e5\u9519\u8bef)\/TRUE(\u6570\u636e\u5b58\u5728)<\/p>\n<p>############################################################<\/p>\n<p>\u4f7f\u7528\u8303\u4f8b<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570\u524d\uff0c\u5148\u5c06\u5176\u521d\u59cb\u5316\uff0c\u907f\u514d\u4e4b\u524d\u8bbe\u5b9a\u9057\u7559\u7684\u53c2\u6570\u503c\u9020\u6210\u5f71\u54cd\u3002<\/p>\n<p>INITIALIZE g_chkparam.* TO NULL<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570 LET g_chkparam.arg1 = &#8216;v_test1&#8217; LET g_chkparam.arg2 = &#8216;111&#8217;<\/p>\n<p>LET g_chkparam.where = &#8216; AND 1=1&#8217;<\/p>\n<p>#\u547c\u53eb\u68c0\u67e5\u5b58\u5728\u7684 library IF cl_chk_exist(&#8220;v_test1&#8221;) THEN<\/p>\n<p>DISPLAY &#8220;\u6570\u636e\u5b58\u5728&#8221;<\/p>\n<p>ELSE<\/p>\n<p>DISPLAY &#8220;\u6570\u636e\u4e0d\u5b58\u5728\u6216 SQL \u8bed\u53e5\u9519\u8bef&#8221;<\/p>\n<p>END IF<\/p>\n<ol>\n<li>\u5e26\u503c\u7684 library\uff1acl_ref_val(p_chk_id)<\/li>\n<\/ol>\n<p>############################################################<\/p>\n<p>#+ @code<\/p>\n<p>#+ \u51fd\u5f0f\u76ee\u7684 \u6839\u636e\u5176 SQL(l_dzcd003)\u5e26\u51fa\u53c2\u7167\u7684\u57df\u503c,\u82e5\u8d44\u6599\u7b14\u6570\u4e0d\u552f\u4e00\u5219\u663e\u793a\u9519\u8bef\u8baf\u606f(l_dzcd004)<\/p>\n<p>#+ ,\u7136\u540e\u5e26\u56de\u9ed8\u8ba4\u503c<\/p>\n<p>#+ @param p_chk_id CHAR(20) \u6821\u9a8c\u5e26\u503c\u6807\u8bc6\u7b26<\/p>\n<p>############################################################<\/p>\n<p>\u4f7f\u7528\u8303\u4f8b<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570\u524d\uff0c\u5148\u5c06\u5176\u521d\u59cb\u5316\uff0c\u907f\u514d\u4e4b\u524d\u8bbe\u5b9a\u9057\u7559\u7684\u53c2\u6570\u503c\u9020\u6210\u5f71\u54cd\u3002<\/p>\n<p>INITIALIZE g_chkparam.* TO NULL<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570<\/p>\n<p>LET g_chkparam.arg1 = &#8220;v_test1&#8221; LET g_chkparam.arg2 = &#8220;1&#8221;<\/p>\n<p>LET g_chkparam.where = &#8221; AND 1=1 &#8221; LET g_chkparam.default1 =&#8217;111&#8242;<\/p>\n<p>LET g_chkparam.default2 =&#8217;222&#8242; LET g_chkparam.default2 =&#8217;333&#8242;<\/p>\n<p>#\u547c\u53eb\u5e26\u503c\u7684 library<\/p>\n<p>CALL cl_ref_val(&#8220;v_test2&#8221;)<\/p>\n<p>#\u68c0\u89c6\u56de\u4f20\u503c<\/p>\n<p>DISPLAY &#8220;return1 = &#8220;,g_chkparam.return1<\/p>\n<p>DISPLAY &#8220;return2 = &#8220;,g_chkparam.return2<\/p>\n<p>DISPLAY &#8220;return3 = &#8220;,g_chkparam.return3<\/p>\n<p>DISPLAY &#8220;return4 = &#8220;,g_chkparam.return4<\/p>\n<p>DISPLAY &#8220;return5 = &#8220;,g_chkparam.return5<\/p>\n<p>3. \u68c0\u67e5\u5b58\u5728\u5e76\u5e26\u503c\u7684 library\uff1acl_chk_exist_and_ref_val(p_chk_id)<\/p>\n<p>############################################################<\/p>\n<p>#+ @code<\/p>\n<p>#+ \u51fd\u5f0f\u76ee\u7684 \u6839\u636e\u5176 SQL(l_dzcd003) \u68c0\u67e5\u5b58\u5728\u5e76\u5e26\u51fa\u53c2\u7167\u7684\u57df\u503c , \u82e5\u8d44\u6599\u7b14\u6570\u4e0d\u552f\u4e00\u5219\u663e\u793a\u9519\u8bef\u8baf\u606f<\/p>\n<p>(l_dzcd004)<\/p>\n<p>#+ ,\u7136\u540e\u5e26\u56de\u9ed8\u8ba4\u503c<\/p>\n<p>#+ @param p_chk_id CHAR(20) \u6821\u9a8c\u5e26\u503c\u6807\u8bc6\u7b26<\/p>\n<p>#+ @return BOOLEAN FALSE(\u6570\u636e\u7b14\u6570\u4e0d\u552f\u4e00\u6216 SQL \u8bed\u53e5\u9519\u8bef)\/TRUE(\u6570\u636e\u7b14\u6570\u552f\u4e00\u4e14\u5df2\u5e26\u503c)<\/p>\n<p>############################################################<\/p>\n<p>\u4f7f\u7528\u8303\u4f8b<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570\u524d\uff0c\u5148\u5c06\u5176\u521d\u59cb\u5316\uff0c\u907f\u514d\u4e4b\u524d\u8bbe\u5b9a\u9057\u7559\u7684\u53c2\u6570\u503c\u9020\u6210\u5f71\u54cd\u3002<\/p>\n<p>INITIALIZE g_chkparam.* TO NULL<\/p>\n<p>#\u8bbe\u5b9a g_chkparam.*\u7684\u53c2\u6570<\/p>\n<p>LET g_chkparam.arg1 = &#8220;v_test3&#8221;<\/p>\n<p>LET g_chkparam.where = &#8220;AND 1=1&#8221; LET g_chkparam.default1 =&#8217;111&#8242;<\/p>\n<p>LET g_chkparam.default2 =&#8217;222&#8242;<\/p>\n<p>#\u547c\u53eb\u68c0\u67e5\u5b58\u5728\u5e76\u5e26\u503c\u7684 library<\/p>\n<p>IF cl_chk_exist_and_ref_val(&#8220;v_test3&#8221;) THEN<\/p>\n<p>DISPLAY &#8220;\u8d44\u6599\u4e3a\u4e00\u7b14\u4e14\u5df2\u5e26\u503c&#8221;<\/p>\n<p>ELSE<\/p>\n<p>DISPLAY &#8220;\u6570\u636e\u7b14\u6570\u4e0d\u552f\u4e00\u6216 SQL \u8bed\u53e5\u9519\u8bef&#8221;<\/p>\n<p>END IF<\/p>\n<p>#\u68c0\u89c6\u56de\u4f20\u503c<\/p>\n<p>DISPLAY &#8220;return1 = &#8220;,g_chkparam.return1<\/p>\n<p>DISPLAY &#8220;return2 = &#8220;,g_chkparam.return2<\/p>\n<p>DISPLAY &#8220;return3 = &#8220;,g_chkparam.return3<\/p>\n<p>DISPLAY &#8220;return4 = &#8220;,g_chkparam.return4<\/p>\n<p>DISPLAY &#8220;return5 = &#8220;,g_chkparam.return5<\/p>\n<p>&nbsp;<\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.hefeiyu.com\">\u8d6b\u975e\u57df<\/a> &raquo; <a href=\"https:\/\/www.hefeiyu.com\/?p=6913\">T100 r.v \u5e26\u503c\u6821\u9a8c(adzi220)<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>r.v \u5e26\u503c\u6821\u9a8c(adzi220) \u6267\u884c\u6307\u4ee4\uff1ar.v \u6216 r.r adzi220 \u672c\u652f\u4f5c\u4e1a\u7684\u76ee\u7684\u662f\u4e3a\u4e86\u8ba9\u5f00\u53d1\u4eba\u5458\u53ef\u4ee5\u900f\u8fc7\u8bbe\u5b9a\u7684\u65b9\u5f0f\u5904\u7406\u6821\u9a8c\u5e26\u503c\uff0c\u8fd9\u4e9b\u8bbe\u5b9a\u53ef\u4ee5\u8ba9\u5f00\u53d1\u4eba\u5458\u91cd\u65b0\u4f7f\u7528\u8fd9\u4e9b\u8bbe\u5b9a\uff0c\u52a0\u5feb\u5f00\u53d1\u901f\u5ea6\u3002 \u884c\u4e1a\u522b \u65b0\u589e\u6821\u9a8c\u5e26\u503c\u65f6\uff0c\u9996\u5148\u8981\u51b3\u5b9a\u5f52\u5c5e\u884c\u4e1a\u522b\uff0c\u9ed8\u8ba4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[489],"tags":[894,896,897],"class_list":["post-6913","post","type-post","status-publish","format-standard","hentry","category-489","tag-894","tag-896","tag-897"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/6913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6913"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/6913\/revisions"}],"predecessor-version":[{"id":6930,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/6913\/revisions\/6930"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}