{"id":5496,"date":"2002-07-29T23:30:57","date_gmt":"2002-07-29T14:30:57","guid":{"rendered":"https:\/\/sonlab.mycafe24.com\/wp\/db%ec%97%b0%eb%8f%99%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8-%ec%8b%a4%ec%8a%b567-%ec%bd%94%eb%94%a92\/"},"modified":"2002-07-29T23:30:57","modified_gmt":"2002-07-29T14:30:57","slug":"db%ec%97%b0%eb%8f%99%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8-%ec%8b%a4%ec%8a%b567-%ec%bd%94%eb%94%a92","status":"publish","type":"post","link":"http:\/\/sonbm.com\/wp\/db%ec%97%b0%eb%8f%99%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8-%ec%8b%a4%ec%8a%b567-%ec%bd%94%eb%94%a92\/","title":{"rendered":"DB\uc5f0\ub3d9\ud504\ub85c\uadf8\ub7a8 \uc2e4\uc2b5(6\/7) &#8211; \ucf54\ub529(2)"},"content":{"rendered":"<p>\uc7a0\ub3c4 \uc124\uce58\uace0 \ud68c\uc0ac \uc77c\ub3c4 \ubc14\uc058\uace0&#8230; \uc9d1\uc5d0 \uc624\ub2c8 \ud55c\uc2dc\uac04 \uc549\uc544 \uc788\uae30\ub3c4 \ud798\ub4dc\ub124\uc694. \uc878\ub9b0 \ub208\uc744 \ubd80\ub985\ub728\uba70, \uadf8\ub798\ub3c4 7\uc6d4\uc774 \uac00\uae30 \uc804\uc5d0 \uac15\uc88c\ub97c \ub9c8\ubb34\ub9ac\ud558\uae30 \uc704\ud574 \uc624\ub298, \ub0b4\uc77c \ud55c \uac15\uc88c\uc529 \uc62c\ub9b4 \uc608\uc815\uc785\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/bar01.gif\"><br \/>\n\uba3c\uc800 31\uac15\uc5d0\uc11c \ub9cc\ub4e4\uc5c8\ub358 \ub450 \ubc88\uc9f8 \ud3fc\uc778&nbsp;&nbsp;<b>frmDb1S<\/b> \ud3fc\uc744 \uc5f4\uace0 \ucf54\ub4dc \ucc3d\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc740 \ucf54\ub4dc\ub97c \uc785\ub825\ud558\uba74 \ub429\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/lecture\/vb34-1.gif\" border=1><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/lecture\/vb34-2.gif\" border=1><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/bar01.gif\"><br \/>\n<b><font face=arial color=red size=3>[1]<\/font><\/b><br \/>\nForm \uac1c\uccb4\uc758 Activate \ud504\ub85c\uc2dc\uc800\ub97c \uc120\ud0dd\ud558\uace0 txtSearchNum.SetFocus\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<br \/>\nActivate \ud504\ub85c\uc2dc\uc800\uc5d0\ub294 \ucc3d\uc774 \ud65c\uc131\ud654\ub420 \ub54c \uc2e4\ud589\ub418\ub294 \ucf54\ub4dc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<br \/>\n\ub530\ub77c\uc11c \uc704\uc640 \uac19\uc774 \ud558\uba74 frmDb1S \ucc3d\uc774 \ud65c\uc131\ud654\ub418\uba74 \uac80\uc0c9\uc744 \uc704\ud574 \uc0ac\ubc88\uc744 \uc785\ub825\ud558\ub294 txtSearchNum \ud14d\uc2a4\ud2b8 \ubc15\uc2a4\uc5d0 \ucee4\uc11c\uac00 \uae5c\ube61\uac70\ub9ac\uac8c \ub429\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/bar01.gif\"><br \/>\n<b><font face=arial color=red size=3>[2]<\/font><\/b><br \/>\n\ucc3d\uc774 \ub85c\ub4dc\ub420 \ub54c \uc2e4\ud589\ub418\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<br \/>\n\uc9c0\ub09c \uc2dc\uac04\uc758 \ucf54\ub4dc\uc640 \ube44\uc2b7\ud569\ub2c8\ub2e4.<br \/>\n\ud604\uc7ac \uacbd\ub85c\uc5d0\uc11c db1.mdb \ud30c\uc77c\uc744 \ub370\uc774\ud130\ucee8\ud2b8\ub864(datDb1)\uacfc \uc5f0\uacb0\uc2dc\ud0b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 db1.mdb\uc758 employee \ud14c\uc774\ube14\uc5d0\uc11c \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc0c8\ub85c\uace0\uce68\uc744 \ud569\ub2c8\ub2e4.<br \/>\n\uadf8 \uc678\uc758 \ucf54\ub4dc\ub294 \uac80\uc0c9\uc744 \uc704\ud55c \uc0ac\ubc88 \uc785\ub825\ub780\uc744 \uc81c\uc678\ud55c \ub2e4\ub978 \uc785\ub825 \ub780\uc744 \ubaa8\ub450 \ube44\ud65c\uc131\ud654\uc2dc\ud0a4\ub294 \uae30\ub2a5\uc744 \ud569\ub2c8\ub2e4. \uac80\uc0c9 \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc8fc\uae30\ub9cc \ud558\uba74 \ub418\ub2c8\uae4c \uc785\ub825\ud560 \uc218 \uc5c6\ub3c4\ub85d \ub9cc\ub4e0 \uac83\uc785\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/bar01.gif\"><br \/>\n<b><font face=arial color=red size=3>[3]<\/font><\/b><br \/>\n\ucc3e\uc544\ub78f! \ub2e8\ucd94\ub97c \ub204\ub97c \ub54c \uc2e4\ud589\ub418\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<br \/>\nFindFirst \uba54\uc18c\ub4dc\ub294 \ub808\ucf54\ub4dc\uc14b\uc5d0 \uc788\ub294 \ub808\ucf54\ub4dc\ub97c \ucc98\uc74c\ubd80\ud130 \uac80\uc0c9\ud558\uc5ec \ud574\ub2f9 \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ucc98\uc74c \ub808\ucf54\ub4dc\ub97c \ucc3e\uc544\uc90d\ub2c8\ub2e4.<br \/>\nFindFirst \uba54\uc18c\ub4dc \ub4a4\uc758 \uc870\uac74\uc2dd\uc740 \ud070 \ub530\uc634\ud45c\ub85c \ub458\ub7ec\uc2f8\uc57c \ud569\ub2c8\ub2e4.<br \/>\n\uc608\ub97c \ub4e4\uc5b4, Data1.RecordSet.FindFirst &#8220;\uc810\uc218 Between 90 And 100&#8243;\ub294 \uc810\uc218\uac00 90\uff5e100\uc778 \uc790\ub8cc \uac80\uc0c9\ud558\ub77c\ub294 \ub73b\uc774 \ub429\ub2c8\ub2e4.<br \/>\n\ub530\ub77c\uc11c \ub9cc\uc57d \uc0ac\ubc88 \uc785\ub825\ub780\uc5d0 0003\uc744 \uc785\ub825\ud558\uace0 [\ucc3e\uc544\ub78f!] \ub2e8\ucd94\ub97c \ub204\ub974\uba74<br \/>\n<b>datDb1.RecoredSet.FindFirst &#8220;[number]= &#8216;0003\u2018&#8221;<\/b> \uacfc \uac19\uc740 \uc2dd\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/bar01.gif\"><br \/>\n\uc9c0\ub09c \uc2dc\uac04\uc758 \uc2e4\uc2b5\uc744 \ubb34\ub09c\ud788 \ub9c8\ucce4\ub2e4\uba74 \uc774\ubc88 \uc2dc\uac04\uc740 \uadf8\ub9ac \uc5b4\ub835\uc9c0 \uc54a\uc558\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc0c1 \ub3d9\uc8fc \uc544\ube60 \uc190\ubcd1\ubaa9\uc774\uc5c8\uc2b5\ub2c8\ub2e4.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.itmembers.net\/images\/itmemberslogo3.gif\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc7a0\ub3c4 \uc124\uce58\uace0 \ud68c\uc0ac \uc77c\ub3c4 \ubc14\uc058\uace0&#8230; \uc9d1\uc5d0 \uc624\ub2c8 \ud55c\uc2dc\uac04 \uc549\uc544 \uc788\uae30\ub3c4 \ud798\ub4dc\ub124\uc694. \uc878\ub9b0 \ub208\uc744 \ubd80\ub985\ub728\uba70, \uadf8\ub798\ub3c4 7\uc6d4\uc774 \uac00\uae30 \uc804\uc5d0 \uac15\uc88c\ub97c \ub9c8\ubb34\ub9ac\ud558\uae30 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[90],"tags":[78,91,80,92,93,28,82],"class_list":["post-5496","post","type-post","status-publish","format-standard","hentry","category-vb6","tag-it","tag-vb","tag-80","tag-92","tag-93","tag-28","tag-82"],"_links":{"self":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts\/5496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/comments?post=5496"}],"version-history":[{"count":0,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts\/5496\/revisions"}],"wp:attachment":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/media?parent=5496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/categories?post=5496"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/tags?post=5496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}