{"id":416,"date":"2020-10-24T17:45:39","date_gmt":"2020-10-24T09:45:39","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=416"},"modified":"2020-12-09T17:28:01","modified_gmt":"2020-12-09T09:28:01","slug":"dbase_ado","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=416","title":{"rendered":"dBase.. .Ado \u7684\u5c0f\u5e38\u8b58"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  this.Q3 = new ADOQ(this)\n  with (this.Q3)\n      sql = \"select * from V_A1023\"\n      active = true\n  endwith\n  with (this.Q3.rowset)\n\tsort = \"\u65e5\u671f DESC\"\n  endwith\t\n\n   this.Q1 = new ADOQ(this)\n   with (this.Q1)\n      sql = \"select * from V_A1021 WHERE \u5e74\u6708\u65e5=:\u5e74\u6708\u65e5\"\n      masterSource = form.q3.rowset\n      with (parameters&#91;\"\u5e74\u6708\u65e5\"])\n        type = 'varChar'\n\tvalue = \" \"\n      endwith\t\t\n      active = true\n   endwith\n\n   with (this.Q1.rowset)\n      sort = \"\u5e74\u6708\u65e5\"\n   endwith<\/code><\/pre>\n\n\n\n<p>\u4ee5\u524d \u4e0d\u6e05\u695a  \u70ba\u4f55\u53c3\u6578 \u9700\u8981 \u9810\u8a2d value <\/p>\n\n\n\n<p>\u5f9e \u6bcf\u65e5\u5e63\u5225\u7dad\u8b77,  \u7d42\u65bc \u767c\u73fe\u554f\u984c\u4e86..<\/p>\n\n\n\n<p>Q3.rowset \u70baNULL \u6642, <\/p>\n\n\n\n<p>Q1\u7684\u53c3\u6578\u9700\u8981 \u4e00\u500b\u9810\u8a2d\u503c,\u8b93 rowset \u6771\u897f\u51fa\u73fe(\u88e1\u9762\u6c92\u8cc7\u6599\uff0c\u4f46\u662f\u67b6\u69cb\u5728)<\/p>\n\n\n\n<p>\u9019\u6642\u5019  sort=&#8217;\u5e74\u6708\u65e5&#8217;  \u89f8\u52d5\u5f8c\u624d\u4e0d\u6703 \u5831\u932f&#8230;.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u524d \u4e0d\u6e05\u695a \u70ba\u4f55\u53c3\u6578 \u9700\u8981 \u9810\u8a2d value \u5f9e \u6bcf\u65e5\u5e63\u5225\u7dad\u8b77, \u7d42\u65bc \u767c\u73fe\u554f\u984c\u4e86.. Q3.rowset  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":242,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dbase-problems"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.dxQerp.com\/wp-content\/uploads\/2020\/09\/k_t9zj3se8k-scaled.jpg?fit=2560%2C1706","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=416"}],"version-history":[{"count":3,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":600,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/416\/revisions\/600"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/media\/242"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}