FileMaker Pro ActiveX ÀÚµ¿È­ »ç¿ëÇϱâ(Windows)
FileMaker Pro Çü½Ä ¶óÀ̺귯¸®
Çü½Ä ¶óÀ̺귯¸®´Â FileMaker Pro¿¡¼­ Ç¥½ÃµÈ ´ë»óü, ¼Ó¼º ¹× ¸Þ¼Òµå¸¦ ¼³¸íÇÏ¿© ´Ù¸¥ ActiveX Ŭ¶óÀÌ¾ðÆ®°¡ FileMaker Pro¿¡ Á¢±ÙÇÒ ¼ö ÀÖ½À´Ï´Ù.
FileMaker Pro Çü½Ä ¶óÀ̺귯¸®´Â FileMaker Pro ½ÇÇà ÆÄÀÏ¿¡ Æ÷ÇԵ˴ϴÙ. À̰ÍÀº °³º° ÆÄÀÏÀÌ ¾Æ´Õ´Ï´Ù. FileMaker Pro Çü½Ä ¶óÀ̺귯¸®´Â FileMaker Pro¸¦ ¼³Ä¡ÇßÀ» ¶§ ÄÄÇ»ÅÍ¿¡ µî·ÏµË´Ï´Ù.
Visual Basic¿¡¼­ "FileMaker Pro Çü½Ä ¶óÀ̺귯¸®"¸¦ ÇÁ·ÎÁ§Æ®ÀÇ »ç¿ë °¡´ÉÇÑ ÂüÁ¶ ¸ñ·Ï¿¡ Ãß°¡ÇÕ´Ï´Ù.
Áß¿ä»çÇ×  FileMaker Pro Çü½Ä ¶óÀ̺귯¸®¸¦ ActiveX ÀÚµ¿È­ ¹®¼­¸¦ ±¸ÇöÇÏ´Â µ¥ »ç¿ë ÁßÀÎ ÀÀ¿ë ÇÁ·Î±×·¥ÀÇ »ç¿ë °¡´ÉÇÑ Çü½Ä ¶óÀ̺귯¸® ¸ñ·Ï¿¡ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù. Çü½Ä ¶óÀ̺귯¸®¸¦ Ãß°¡ÇÏÁö ¾Ê´Â °æ¿ì ActiveX ÀÚµ¿È­¸¦ ÅëÇØ FileMaker Pro¸¦ ´Ù·ê ¼ö ¾ø½À´Ï´Ù.
ÀÌ ¶óÀ̺귯¸®¸¦ Ãß°¡ÇÏ´Â ¹æ½ÄÀº ´Ù¸¥ ActiveX ÀÚµ¿È­ ÆíÁý Áö¿ø ÇÁ·Î±×·¥¸¶´Ù ´Ù¸¨´Ï´Ù. Ãß°¡ ¹æ¹ýÀÌ È®½ÇÇÏÁö ¾ÊÀº °æ¿ì ActiveX ÀÚµ¿È­ ÆíÁý Áö¿ø ÇÁ·Î±×·¥°ú ÇÔ²² Á¦°øµÈ ¼³¸í¼­¸¦ Âü°íÇϽʽÿÀ. ´ÙÀ½ ÇÁ·Î½ÃÀú´Â Microsoft Visual BasicÀÇ Ãß°¡ ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
FileMaker Pro Çü½Ä ¶óÀ̺귯¸®¸¦ Microsoft Visual Basic¿¡ Ãß°¡Çϱâ:
1.
Microsoft Visual Basic¿¡¼­ ÇÁ·ÎÁ§Æ® ¸Þ´º > ÂüÁ¶ > Çü½Ä ¶óÀ̺귯¸® Ãß°¡¸¦ ¼±ÅÃÇÕ´Ï´Ù.
2.
FileMaker Pro Çü½Ä ¶óÀ̺귯¸® ¿ÞÂÊ¿¡¼­ üũ»óÀÚ¸¦ Ȱ¼ºÈ­½Ãŵ´Ï´Ù.
3.
È®ÀÎÀ» Ŭ¸¯ÇÕ´Ï´Ù.
ÇÁ·ÎÁ§Æ® ÂüÁ¶°¡ FileMaker Pro Çü½Ä ¶óÀ̺귯¸®¸¦ Æ÷ÇÔÇϸé Visual Basic °³Ã¼ ºê¶ó¿ìÀú¿¡ FMPro70Lib°¡ ³ªÅ¸³³´Ï´Ù. FileMaker Pro°¡ ÀÚµ¿È­ Á¦¾î·Î Ç¥½ÃÇÏ´Â ¸ðµç ´ë»óü, ¸Þ¼Òµå ¹× ¼Ó¼ºÀÌ ÀÌÁ¦ »ç¿ë °¡´ÉÇÕ´Ï´Ù.
FileMaker Pro¸¦ ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü·Î ¼±¾ðÇϱâ
FileMaker Pro¸¦ Á¦¾îÇϵµ·Ï ActiveX ÀÚµ¿È­ ½ºÅ©¸³Æ® ¶Ç´Â ÀÀ¿ë ÇÁ·Î±×·¥À» »ý¼ºÇÒ ¶§¸¶´Ù FileMaker Pro¸¦ ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü·Î ¼±¾ðÇÕ´Ï´Ù. À̰ÍÀº ´Ù¸¥ Á¤ÀÇ¿Í ÇÔ²² ³ªÅ¸³ª´Â ÀÚµ¿È­ ¹®¼­ÀÇ »ó´Ü¿¡ ÄÚµå ÇÑ ÁÙ·Î ½ÇÇàµÉ ¼ö ÀÖ½À´Ï´Ù.
¿¹¸¦ µé¾î ´ÙÀ½°ú °°½À´Ï´Ù.
Dim FMProApp As FMPro70Lib.Application
ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü ¾ò±â
FileMaker·Î ÀÚµ¿È­ È£ÃâÀ» ÇÏ·Á¸é ¿ì¼± FileMaker ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü¿¡ ´ëÇÑ Á¢±ÙÀ» ¾ò¾î¾ß ÇÕ´Ï´Ù. CreateObject¸¦ È£ÃâÇϰųª GetObject¸¦ È£ÃâÇÏ´Â µÎ °¡Áö ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù.
µÑ Áß ÇϳªÀÇ È£ÃâÀ» »ç¿ëÇÏ·Á¸é ¿ì¼± ´ÙÀ½ÀÇ ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü¸¦ ¼±¾ðÇϽʽÿÀ.
Dim FMProApp As FMPro70Lib.Application
CreateObject Àü¿ë:
Set FMProApp = CreateObject("FMPRO.Application")
ÀÌ¹Ì ½ÇÇà ÁßÀÌÁö ¾ÊÀº °æ¿ì CreateObject°¡ FileMaker¸¦ ½ÇÇàÇÕ´Ï´Ù.
GetObject ÇÔ¼ö´Â FileMaker°¡ ÀÌ¹Ì ½ÇÇà ÁßÀÎ °æ¿ì¿¡¸¸ ÀÀ¿ë ÇÁ·Î±×·¥ ´ë»óü¸¦ °Ë»öÇÕ´Ï´Ù.
GetObject Àü¿ë:
Set FMProApp = GetObject(, "FMPRO.Application")
GetObject¿¡¼­ µð½ºÅ© ÆÄÀÏ °æ·ÎÀÎ »ý·«µÈ ù ¹øÂ° Àμö¸¦ ³ªÅ¸³»´Â ½°Ç¥¿¡ ÁÖÀÇÇÕ´Ï´Ù. °æ¿ì¿¡ µû¶ó¼­ GetObject°¡ ÆÄÀÏ À̸§À» ù ¹øÂ° Àμö·Î ÃëÇϱ⠶§¹®¿¡ ½°Ç¥°¡ ÇÊ¿äÇÕ´Ï´Ù. ÇÏÁö¸¸ FileMakerÀÇ ÀνºÅϽº¸¦ °Ë»öÇÏ·Á¸é ÆÄÀÏ À̸§ Àμö¸¦ Á¦¿ÜÇØ¾ß ÇÕ´Ï´Ù. ±×·¸Áö ¾ÊÀ¸¸é ¿À·ù°¡ ¹ß»ýÇÕ´Ï´Ù.
FileMaker Pro ½ºÅ©¸³Æ® È£ÃâÇϱâ
ActiveX ÀÚµ¿È­¸¦ ÅëÇØ FileMaker Pro ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ·Á¸é ½ºÅ©¸³Æ®ÀÇ À̸§°ú ÇÔ²² DoFMScript ÇÔ¼ö¸¦ º¯¼ö·Î È£ÃâÇϽʽÿÀ.
¿¹¸¦ µé¾î ´ÙÀ½°ú °°½À´Ï´Ù.
Dim FMProApp As FMPro70Lib.Application
CreateObject("FMPRO.application")
Dim FMProDocs, FMProDocs.Open("c:\MyFile.fmp12","","")
Dim FMProDoc
FMProDoc.DoFMScript ("MyScript")
Set FMProDoc = nothing
FileMaker Pro ÀÀ¿ë ÇÁ·Î±×·¥ÀÇ °¡½Ã¼º Åä±ÛÇϱâ
FileMaker Pro°¡ ÀÚµ¿È­·Î ½ÇÇàµÉ ¶§ ±âº»ÀûÀ¸·Î °¡·ÁÁø Ç׸ñÀ» ½ÇÇàÇÕ´Ï´Ù. Visible ¼Ó¼ºÀ» »ç¿ëÇÏ¿© FileMaker Pro¸¦ °¡¸®°Å³ª Ç¥½ÃÇÒ ¼ö ÀÖ½À´Ï´Ù.
¿¹¸¦ µé¾î ÀÀ¿ë ÇÁ·Î±×·¥À» °¡¸®·Á¸é,
FMProApp.Visible = False
ÀÀ¿ë ÇÁ·Î±×·¥À» Ç¥½ÃÇÏ·Á¸é,
FMProApp.Visible = True
ÂüÁ¶ °è¼ö ¹× ´ë»óü ÇØÁ¦Çϱâ
ÀÚµ¿È­ ´ë»óü°¡ ÂüÁ¶µÉ ¶§ ÇÁ·Î¼¼½º°¡ ÇØ´ç ´ë»óü¸¦ »ç¿ë ÁßÀÓÀ» FileMaker¿¡¼­ ¾Ë ¼ö ÀÖµµ·Ï ÂüÁ¶ °è¼ö°¡ Áõ°¡ÇÕ´Ï´Ù. Visual Basic¿¡¼­ ´ÙÀ½ÀÇ ¿¹Á¦¿Í °°ÀÌ ¼±¾ðµÈ º¯¼ö¸¦ FileMaker ´ë»óü·Î ¼³Á¤ÇÒ ¶§¸¶´Ù ´ë»óü´Â ÂüÁ¶ °è¼ö°¡ µË´Ï´Ù.
' ¼±¾ðÀÏ »Ó, ¾ÆÁ÷ ÂüÁ¶ ¾øÀ½
Dim FMDocs as FMPro70Lib.Documents
' ÀÌ ÁÙÀº FileMakerÀÇ "Documents" ´ë»óüÀÇ ÂüÁ¶¸¦ ¸¸µì´Ï´Ù.
Set FMDocs = FMApp.Documents
' À̰ÍÀº µ¿ÀÏÇÑ FileMaker "Documents" ´ë»óüÀÇ µÎ ¹øÂ° ÂüÁ¶¸¦ ¸¸µì´Ï´Ù.
Set FMDocs2 = FMApp.Documents
¸ðµç ÂüÁ¶ °è¼ö°¡ ÇØÁ¦µÉ ¶§±îÁö FileMaker°¡ Á¾·áµÇÁö ¾ÊÀ» ¼öµµ ÀÖ½À´Ï´Ù. Visual Basic¿¡¼­ ´ÙÀ½ ¿¹Á¦¿Í °°ÀÌ ´ë»óü º¯¼ö¸¦ "Nothing"À¸·Î ¼³Á¤ÇÏ¿© ÂüÁ¶ °è¼ö¸¦ ÇØÁ¦ÇÒ ¼ö ÀÖ½À´Ï´Ù.
' FileMaker "Documents" ´ë»óü¿¡ ´ëÇÑ ÂüÁ¶¸¦ ÇØÁ¦ÇÕ´Ï´Ù
Set FMDocs = Nothing
' FileMaker "Documents" ´ë»óü¿¡ ´ëÇÑ µÎ ¹øÂ° ÂüÁ¶¸¦ ÇØÁ¦ÇÕ´Ï´Ù
Set FMDocs2 = Nothing
' FileMaker Application ´ë»óü¿¡ ´ëÇÑ ÂüÁ¶¸¦ ÇØÁ¦ÇÕ´Ï´Ù
Set FMApp = Nothing
º¯¼ö¸¦ »ç¿ëÇÏ¿© ³¡³¯ ¶§ Ç×»ó ´ë»óü º¯¼ö¸¦ "Nothing"À¸·Î ¼³Á¤ÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
Á¢±Ù ±ÇÇÑ
FileMaker Pro´Â Documents.Open(filename As String, accountName As String, password As String) ¸Þ¼Òµå¸¦ »ç¿ëÇÕ´Ï´Ù. accountName ¹× password Àμö°¡ ºó ¹®ÀÚ¿­ÀÎ °æ¿ì ÆÄÀÏÀÌ Å¬¶óÀÌ¾ðÆ® »ç¿ëÀÚ·Î ¿­¸³´Ï´Ù.
½ºÅ©¸³Æ®
ÀÚµ¿È­·Î Á÷Á¢ È£ÃâµÈ FileMaker Pro ½ºÅ©¸³Æ®°¡ ¼­·Î Ãæµ¹ÇÒ ¼ö ÀÖ½À´Ï´Ù.
´Ù¸¥ FileMaker Pro ½ºÅ©¸³Æ® ³»¿¡¼­ È£ÃâµÈ FileMaker Pro ½ºÅ©¸³Æ®´Â ¿¹»ó ¼ø¼­´ë·Î ½ÇÇàµË´Ï´Ù.
¿ø°ÝÀ¸·Î È£½ºÆ®µÈ ÆÄÀÏ
ActiveX ÀÚµ¿È­¸¸ »ç¿ëÇÏ¿© È£½ºÆ®µÈ ÆÄÀÏÀº ¿­±â°¡ ºÒ°¡´ÉÇÕ´Ï´Ù. ÀÚµ¿È­¸¦ »ç¿ëÇÏ¿© È£½ºÆ®µÈ ÆÄÀÏÀ» ¿­·Á¸é FileMaker ¿­±â ´ëÈ­»óÀÚ¸¦ »ç¿ëÇÏ¿© Á÷Á¢ È£½ºÆ®µÈ ÆÄÀÏÀ» ¿­°í ÀÚµ¿È­¸¦ »ç¿ëÇÏ¿© ÆÄÀÏ¿¡ Á¢±ÙÇϰųª, È£½ºÆ®µÈ ÆÄÀÏÀ» ¿©´Â FileMaker Pro ½ºÅ©¸³Æ®¸¦ ÀÛ¼ºÇÑ ´ÙÀ½ ÀÚµ¿È­¸¦ ÅëÇØ ÇØ´ç ½ºÅ©¸³Æ®¸¦ È£ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù.
°ü·Ã ÁÖÁ¦ 
FileMaker Pro ActiveX ÀÚµ¿È­ »ç¿ëÇϱâ(Windows)
ActiveX ÀÚµ¿È­ ¿¹Á¦(Windows)