{"id":2568,"date":"2019-03-25T17:40:11","date_gmt":"2019-03-25T20:40:11","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/using-databases-in-e3-chapter-4-getadorecordset\/"},"modified":"2020-01-21T11:31:03","modified_gmt":"2020-01-21T14:31:03","slug":"using-databases-in-e3-chapter-4-getadorecordset","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/","title":{"rendered":"Using Databases in E3: Chapter 4 &#8211; GetADORecordset."},"content":{"rendered":"<p align=\"justify\">The Query&#8217;s <b>GetADORecordSet<\/b> method returns a Recordset object of type <b>ADO<\/b> (<i>ActiveX Data Object<\/i>), the result of executing the configured query.<\/p>\n<p align=\"justify\">The ADO RecordSet object is used to access records from a database table. It has the following properties and methods:<\/p>\n<p align=\"justify\"><b>Properties<\/b><\/p>\n<p align=\"justify\">Properties are important to check the existence of values in a table. They can be used as security scripts. As an example, we will use the following table:<\/p>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_001.png\" alt=\"\" width=\"212\" height=\"145\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 1<\/b>: Table used<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>BOF<\/b>: Returns true if the pointer position is before the first record. In the following example, the script checks if the pointer is before the first record. If this condition is true, returns a message informing that there is no records before.<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_002.png\" alt=\"\" width=\"382\" height=\"112\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 2<\/b>: Protection script using the <b>BOF<\/b> method<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>EOF<\/b>: Returns true if the pointer position is after the last record. In the following example, the script checks if the pointer is after the last record. If this condition is true, returns a message informing that there is no records after.<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_003.png\" alt=\"\" width=\"343\" height=\"101\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 3<\/b>: Protection script using the <b>EOF<\/b> method<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>RecordCount<\/b>: Returns the number of records in the table. Example:<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_004.png\" alt=\"\" width=\"584\" height=\"87\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 4<\/b>: Script using the <b>RecordCount<\/b> method<\/span><\/p>\n<p align=\"justify\"><b>Methods<\/b><\/p>\n<p align=\"justify\">Methods are used to perform samplings on records, thus getting values from all records precisely.<\/p>\n<div align=\"justify\">\n<ul>\n<li><b>MoveFirst<\/b>: Moves the pointer to the first record. Example:<\/li>\n<\/ul>\n<\/div>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_005.png\" alt=\"\" width=\"608\" height=\"182\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 5:<\/b> Script showing how to use the <b>MoveFirst<\/b> method<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>MoveLast<\/b>: Moves the pointer to the last record. Example:<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_006.png\" alt=\"\" width=\"579\" height=\"174\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 6<\/b>: Script showing how to use the <b>MoveLast<\/b> method<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>MoveNext<\/b>: Moves the pointer to the next record. Example:<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_007.png\" alt=\"\" width=\"588\" height=\"238\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 7:<\/b> Script showing how to use the <b>MoveNext<\/b> method<\/span><\/p>\n<ul>\n<li>\n<div align=\"justify\"><b>MovePrevious<\/b>: Moves the pointer to the previous record. Example:<\/div>\n<\/li>\n<\/ul>\n<p align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_008.png\" alt=\"\" width=\"580\" height=\"243\" align=\"bottom\" border=\"0\" \/><\/p>\n<p align=\"center\"><span style=\"font-size: xx-small;\"><b>Figure 8<\/b>: Script showing how to use the <b>MovePrevious<\/b> method<\/span><\/p>\n<p align=\"justify\"><b>Exercise<\/b><\/p>\n<ol>\n<li>\n<div align=\"justify\">Create a button which counts the number of existing records in the Historic and returns a message with this value.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Create a button which informs the value of the first record.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Create a button which informs the value of the last record.<\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The Query&#8217;s GetADORecordSet method returns a Recordset object of type ADO (ActiveX Data Object), the result of executing the configured query. The ADO RecordSet object is used to access records&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":[735],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Databases in E3: Chapter 4 - GetADORecordset.[:] - 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\/using-databases-in-e3-chapter-4-getadorecordset\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Databases in E3: Chapter 4 - GetADORecordset.\" \/>\n<meta property=\"og:description\" content=\"The Query&#8217;s GetADORecordSet method returns a Recordset object of type ADO (ActiveX Data Object), the result of executing the configured query. The ADO RecordSet object is used to access records&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\" \/>\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:40:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-21T14:31:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_001.png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Using Databases in E3: Chapter 4 &#8211; GetADORecordset.\",\"datePublished\":\"2019-03-25T20:40:11+00:00\",\"dateModified\":\"2020-01-21T14:31:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\"},\"wordCount\":327,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\",\"name\":\"[:pt]Using Databases in E3: Chapter 4 - GetADORecordset.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:40:11+00:00\",\"dateModified\":\"2020-01-21T14:31:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Databases in E3: Chapter 4 &#8211; GetADORecordset.\"}]},{\"@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":"Using Databases in E3: Chapter 4 - GetADORecordset.[:] - 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\/using-databases-in-e3-chapter-4-getadorecordset\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Using Databases in E3: Chapter 4 - GetADORecordset.[:] - Elipse Knowledgebase","og_description":"The Query&#8217;s GetADORecordSet method returns a Recordset object of type ADO (ActiveX Data Object), the result of executing the configured query. The ADO RecordSet object is used to access records&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:40:11+00:00","article_modified_time":"2020-01-21T14:31:03+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4210\/kb_4210_fig_001.png"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Using Databases in E3: Chapter 4 &#8211; GetADORecordset.","datePublished":"2019-03-25T20:40:11+00:00","dateModified":"2020-01-21T14:31:03+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/"},"wordCount":327,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/","url":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/","name":"[:pt]Using Databases in E3: Chapter 4 - GetADORecordset.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:40:11+00:00","dateModified":"2020-01-21T14:31:03+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/using-databases-in-e3-chapter-4-getadorecordset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Using Databases in E3: Chapter 4 &#8211; GetADORecordset."}]},{"@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\/2568"}],"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=2568"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2568\/revisions"}],"predecessor-version":[{"id":9808,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2568\/revisions\/9808"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}