{"id":491,"date":"2017-12-21T13:37:42","date_gmt":"2017-12-21T04:37:42","guid":{"rendered":"https:\/\/www.oqiita.com\/?p=491"},"modified":"2018-05-30T18:48:14","modified_gmt":"2018-05-30T09:48:14","slug":"post-491","status":"publish","type":"post","link":"https:\/\/www.oqiita.com\/?p=491","title":{"rendered":"\u3010GeneXus\u3011IsNull \u5224\u5b9a\u3068\u304b"},"content":{"rendered":"

GeneXus\u3067DB\u5024\u306eNull\u5224\u5b9a\u304c\u4f55\u56de\u805e\u3044\u3066\u3082\u899a\u3048\u3089\u308c\u306a\u3044\u3002<\/p>\n

\u4e0b\u8a18\u306e\u72b6\u614b\u306e\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306bGeneXus\u306e\u6761\u4ef6\u5f0f\u3067\u306e\u6319\u52d5\u3002
\n\"\"<\/a><\/p>\n

<\/p>\n

\u60f3\u5b9a\u74b0\u5883<\/h3>\n

GeneXus X Ev3 u6
\nOracle 11g R2<\/p>\n

Where \u3067 IsNull \u3092\u4f7f\u7528<\/h3>\n
For each\n\tWhere COMPANY_NAME.IsNull()\n\tMSG(COMPANY_ID.ToString().Trim())\nEndfor<\/code><\/pre>\n
\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9
\nCOMPANY_ID\uff1a3<\/p>\n
Where \u3067 IsEmpty \u3092\u4f7f\u7528<\/h3>\n
For each\n\tWhere COMPANY_NAME.IsEmpty()\n\tMSG(COMPANY_ID.ToString().Trim())\nEndfor<\/code><\/pre>\n
\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9
\nCOMPANY_ID\uff1a4<\/p>\n
If\u6587\u3067 IsNull \u3092\u4f7f\u7528<\/h3>\n
For each\n\tIf COMPANY_NAME.IsNull()\n\t\tMSG(COMPANY_ID.ToString().Trim())\n\tEndif\nEndfor<\/code><\/pre>\n
\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9
\nCOMPANY_ID\uff1a3<\/p>\n
If\u6587\u3067 IsEmpty \u3092\u4f7f\u7528<\/h3>\n
For each\n\tIf COMPANY_NAME.IsEmpty()\n\t\tMSG(COMPANY_ID.ToString().Trim())\n\tEndif\nEndfor<\/code><\/pre>\n
\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9
\nCOMPANY_ID\uff1a3\u30014<\/p>\n
\u5909\u6570\u683c\u7d0d\u5f8cIf\u6587\u3067 IsEmpty \u3092\u4f7f\u7528<\/h3>\n
For each\n\t&COMPANY_NAME= COMPANY_NAME\n\tIf &COMPANY_NAME.IsEmpty()\n\t\tMSG(COMPANY_ID.ToString().Trim())\n\tEndif\nEndfor<\/code><\/pre>\n
\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9
\nCOMPANY_ID\uff1a3\u30014<\/p>\n
\n
\u3061\u3083\u3093\u3068\u899a\u3048\u306a\u304d\u3083\u306a\u30fb\u30fb\u30fb\u30fb<\/p>\n

\n\u203b\u5f53\u8a18\u4e8b\u306e\u60c5\u5831\u306f\u30d0\u30fc\u30b8\u30e7\u30f3\u3084\u8a00\u8a9e\u306b\u3088\u3063\u3066\u6319\u52d5\u304c\u9055\u3046\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002
\n\u3042\u304f\u307e\u3067\u3082\u53c2\u8003\u7a0b\u5ea6\u306b\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
GeneXus\u3067DB\u5024\u306eNull\u5224\u5b9a\u304c\u4f55\u56de\u805e\u3044\u3066\u3082\u899a\u3048\u3089\u308c\u306a\u3044\u3002 \u4e0b\u8a18\u306e\u72b6\u614b\u306e\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306bGeneXus\u306e\u6761\u4ef6\u5f0f\u3067\u306e\u6319\u52d5\u3002 \u60f3\u5b9a\u74b0\u5883 GeneXus X Ev3 u6 Oracle 11g R2 Where \u3067 … <\/p>\n","protected":false},"author":1,"featured_media":722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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":[6],"tags":[37,116],"class_list":{"0":"post-491","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-genexus","8":"tag-genexus","9":"tag-null","10":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.oqiita.com\/wp-content\/uploads\/2018\/05\/sango_gx_icatch.png","jetpack_shortlink":"https:\/\/wp.me\/p8QluP-7V","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=491"}],"version-history":[{"count":9,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/491\/revisions"}],"predecessor-version":[{"id":501,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/491\/revisions\/501"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/media\/722"}],"wp:attachment":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}