{"id":3147,"date":"2019-03-25T17:42:55","date_gmt":"2019-03-25T20:42:55","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb56808-creating-a-new-storage-table-at-run-time\/"},"modified":"2020-01-23T10:05:48","modified_gmt":"2020-01-23T13:05:48","slug":"kb56808-creating-a-new-storage-table-at-run-time","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/","title":{"rendered":"KB-56808: Creating a new Storage table at run time."},"content":{"rendered":"<div align=\"justify\"><b>Question:<\/b><\/p>\n<p>Can a new Storage table be created at run time?<\/p>\n<p><b>Solution:<\/b><\/p>\n<p>Yes; to do so, there are two possibilities.<\/p>\n<p>The first one is to use <i>Activate <\/i>and <i>Deactivate <\/i>methods, which respectively activate and deactivate an object when a previous setup must be performed (initializing properties, for example), or when you need to perform tests where the object cannot be present and active.<\/p>\n<p>The second possibility is to use <i>StartAcquisition <\/i>and <i>StopAcquisition <\/i>methods, which respectively start and stop the generation of data going to the Database. The Storage receives notifications on which registered tags underwent changes, and when this happens it checks whether these changes will be recorded or not. When this method is called, both change notification and record generation are stopped.<\/p>\n<p>From these two events, you can create a new table via Storage&#8217;s <i>TableName <\/i>property, which must be changed after the execution of the method that deactivates communication with the database.<\/p>\n<p>Examples:<\/p>\n<p><span style=\"font-family: Courier New;\">Application.GetObject(&#8220;Storage1&#8221;).Deactivate()<br \/>\nApplication.GetObject(&#8220;Storage1&#8221;).TableName = &#8220;Tabela&#8221;&#038; Minute(now)<br \/>\nApplication.GetObject(&#8220;Storage1&#8221;).Activate()<\/span><\/p>\n<p>OR<\/p>\n<p><span style=\"font-family: Courier New;\">Application.GetObject(&#8220;Storage1&#8221;).StopAcquisition()<br \/>\nApplication.GetObject(&#8220;Storage1&#8221;).TableName = &#8220;Tabela&#8221;&#038; Minute(now)<br \/>\nApplication.GetObject(&#8220;Storage1&#8221;).StartAcquisition()<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: Can a new Storage table be created at run time? Solution: Yes; to do so, there are two possibilities. The first one is to use Activate and Deactivate methods,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[744],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-56808: Creating a new Storage table at run time. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-56808: Creating a new Storage table at run time.\" \/>\n<meta property=\"og:description\" content=\"Question: Can a new Storage table be created at run time? Solution: Yes; to do so, there are two possibilities. The first one is to use Activate and Deactivate methods,&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T13:05:48+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-56808: Creating a new Storage table at run time.\",\"datePublished\":\"2019-03-25T20:42:55+00:00\",\"dateModified\":\"2020-01-23T13:05:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\"},\"wordCount\":198,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"E3Storage\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\",\"name\":\"[:pt]KB-56808: Creating a new Storage table at run time.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:55+00:00\",\"dateModified\":\"2020-01-23T13:05:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-56808: Creating a new Storage table at run time.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-56808: Creating a new Storage table at run time. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-56808: Creating a new Storage table at run time.[:] - Elipse Knowledgebase","og_description":"Question: Can a new Storage table be created at run time? Solution: Yes; to do so, there are two possibilities. The first one is to use Activate and Deactivate methods,&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:55+00:00","article_modified_time":"2020-01-23T13:05:48+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-56808: Creating a new Storage table at run time.","datePublished":"2019-03-25T20:42:55+00:00","dateModified":"2020-01-23T13:05:48+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/"},"wordCount":198,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["E3Storage"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/","url":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/","name":"[:pt]KB-56808: Creating a new Storage table at run time.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:55+00:00","dateModified":"2020-01-23T13:05:48+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb56808-creating-a-new-storage-table-at-run-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-56808: Creating a new Storage table at run time."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3147"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3147"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3147\/revisions"}],"predecessor-version":[{"id":9948,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3147\/revisions\/9948"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}