{"id":1349,"date":"2025-10-04T12:05:57","date_gmt":"2025-10-04T04:05:57","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=1349"},"modified":"2026-01-24T08:10:54","modified_gmt":"2026-01-24T00:10:54","slug":"from-q1-%e5%95%9f%e5%8b%95%e5%be%8c-%e7%9a%84%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a0%85","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=1349","title":{"rendered":"From.Q1 \u555f\u52d5\u5f8c \u7684\u6ce8\u610f\u4e8b\u9805"},"content":{"rendered":"<p>Form.Q1.active := true \u4e4b\u5f8c. \u8b8a\u66f4 \u53c3\u6578\u503c \u53ea\u80fd\u4f7f\u7528 reQuery()<br \/>\n\u6216\u662f \u5efa\u7acb \u76f8\u540c\u7684 Local Q \u5373\u6642 \u5efa\u7acb \u5373\u6642 \u95dc\u9589.<\/p>\n<p>\u6e1b\u5c11 \u756b\u9762 \u9583\u52d5 \u5feb\u901f \u5927\u91cf \u65b0\u589e\u8cc7\u6599. \u505c\u7528 Grid \u7684 visible<br \/>\nf.C2.GA.visible := false<\/p>\n<p>\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502 Query \u7269\u4ef6\u5efa\u7acb \u2502<br \/>\n\u2502 Q = new ADOQ(this) \u2502<br \/>\n\u2502 SQL\u3001\u53c3\u6578\u5c1a\u672a\u57f7\u884c \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<br \/>\n\u2502<br \/>\n\u25bc<br \/>\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502 Q.active := true (\u7b2c\u4e00\u6b21\u958b\u555f) \u2502<br \/>\n\u2502 1. SQL \u57f7\u884c \u2502<br \/>\n\u2502 2. Rowset \u751f\u6210 \u2502<br \/>\n\u2502 &#x2705; \u62ff\u5230\u8cc7\u6599 \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<br \/>\n\u2502<br \/>\n\u25bc<br \/>\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502 \u6539\u8b8a\u53c3\u6578\u5f8c\u518d Q.active := true \u2502<br \/>\n\u2502 1. dBASE \u53ef\u80fd\u4e0d\u5237\u65b0 rowset \u2502<br \/>\n\u2502 2. Rowset \u4ecd\u662f\u820a\u8cc7\u6599\u6216\u7a7a\u8cc7\u6599 \u2502<br \/>\n\u2502 &#x274c; \u7121\u6cd5\u4fdd\u8b49\u66f4\u65b0\u8cc7\u6599 \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<br \/>\n\u2502<br \/>\n\u25bc<br \/>\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n\u2502 \u4f7f\u7528 Q.ReQuery() \u2502<br \/>\n\u2502 1. \u81ea\u52d5\u6aa2\u67e5 Query \u662f\u5426 open \u2502<br \/>\n\u2502 2. \u5982\u679c open\uff0c\u5148\u95dc\u9589 rowset \u2502<br \/>\n\u2502 3. \u4f7f\u7528\u6700\u65b0\u53c3\u6578\u91cd\u65b0\u57f7\u884c SQL \u2502<br \/>\n\u2502 4. Rowset \u91cd\u65b0\u751f\u6210\uff0c\u62ff\u5230\u8cc7\u6599 \u2502<br \/>\n\u2502 &#x2705; \u6c38\u9060\u53ef\u9760\u5237\u65b0\u8cc7\u6599 \u2502<br \/>\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Form.Q1.active := true \u4e4b\u5f8c. \u8b8a\u66f4 \u53c3\u6578\u503c \u53ea\u80fd\u4f7f\u7528 reQuery() \u6216\u662f \u5efa\u7acb  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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-1349","post","type-post","status-publish","format-standard","hentry","category-dbase-problems"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1349","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=1349"}],"version-history":[{"count":3,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1349\/revisions"}],"predecessor-version":[{"id":1788,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1349\/revisions\/1788"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1349"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}