Anita Jones´Â Á÷¿ø Å×ÀÌºí¿¡¼ ÀÚ½ÅÀÇ »çÁøÀ» ÃֽŠ»çÁøÀ¸·Î ¹Ù²ß´Ï´Ù. ´õ¿í »õ·Î¿î »çÁø ³»¿ëÀº ¼¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.
»ç¿ëÀÚ ¼öÇà ÀÛ¾÷: »ç¿ëÀÚ´Â ´ÙÀ½ ¿¹½Ã¿¡ Ç¥½ÃµÈ SQL¹®À» Æ÷ÇÔÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Á÷¿ø Å×À̺íÀÇ »çÁøÀ» ´ëüÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; char hvComment [16385]; long hvStorageType; EXEC SQL END DECLARE SECTION; strcpy(hvComment, "Picture taken at Anita's promotion"); hvStorageType=MMDB_STORAGE_TYPE_INTERNAL; EXEC SQL UPDATE EMPLOYEE SET PICTURE=REPLACE( PICTURE, /*image handle*/ '/myimages/newone.bmp', /*source image content*/ 'BMP', /*source format*/ :hvStorageType, /*store image in table as BLOB*/ :hvComment) /*replace comment*/ WHERE NAME='Anita Jones'; |
°á°ú: UPDATE¹®ÀÇ Replace UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender°¡ »õ·Î¿î À̹ÌÁöÀÇ ¼Ó¼ºÀ» ÀнÀ´Ï´Ù. Image Extender´Â »õ·Î¿î À̹ÌÁöÀÇ ¼Ó¼ºÀ» »ç¿ëÇÏ¿© ±âÁ¸ À̹ÌÁö¿¡ ´ëÇÑ °ü¸® Áö¿ø Å×ÀÌºí¿¡ ÀúÀåµÈ ¼Ó¼ºÀ» °»½ÅÇÕ´Ï´Ù. À̹ÌÁö ¼Ò½º´Â newone.bmp¶ó´Â ¼¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. ÆÄÀÏ ³»¿ëÀº ÀÌÀü À̹ÌÁöÀÇ BLOB ³»¿ëÀ» ´ëüÇϸç BLOBÀ¸·Î¼ °ü¸® Áö¿ø Å×ÀÌºí ·¹Äڵ忡 »ðÀԵ˴ϴÙ.
Æ®¸®°Å´Â ´Ù¾çÇÑ °ü¸® Áö¿ø Å×ÀÌºí¿¡ ÀÖ´Â À̹ÌÁö ¼Ó¼º µ¥ÀÌÅ͸¦ ´ëüÇÕ´Ï´Ù.