{"id":419,"date":"2009-10-17T05:17:52","date_gmt":"2009-10-16T21:17:52","guid":{"rendered":"http:\/\/www.andreanolanusse.com\/pt\/?p=419"},"modified":"2013-05-01T22:02:24","modified_gmt":"2013-05-02T05:02:24","slug":"utilizando-o-dbexpress-dbx-framework-em-delphi-2010","status":"publish","type":"post","link":"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/","title":{"rendered":"Utilizando o dbExpress (DBX) Framework em Delphi 2010"},"content":{"rendered":"<p>Tenho recebido muitas perguntas sobre como utilizar do dbExpress Framework para efetuar opera\u00e7\u00f5es no banco de dados, ent\u00e3o resolvi postar este exemplo de uma aplica\u00e7\u00e3o console, o exemplo \u00e9 bem f\u00e1cil de entender e mostra as op\u00e7\u00f5es b\u00e1sicas de conex\u00e3o, transa\u00e7\u00e3o e query.<\/p>\n<p>Pretende em futuros posts, explicar mais sobre o framework.<\/p>\n<pre class=\"brush: pascal\">program DBX4Example;\r\n{$APPTYPE CONSOLE}\r\n\r\nuses SysUtils, DBXDynalink, Dialogs, DbxInterBaseReadOnlyMetadata, DBXCommon;\r\n\r\nvar\r\n\r\n  aConnName: string;\r\n  aDBXConn: TDBXConnection;\r\n  aDBXTrans: TDBXTransaction;\r\n  aCmnd: TDBXCommand;\r\n  aReader: TDBXReader;\r\n  aColCount: integer;\r\n\r\nbegin\r\n\r\n  aDBXConn := TDBXConnectionFactory.GetConnectionFactory.GetConnection\r\n    ('EMPLOYEE IB', 'sysdba', 'masterkey');\r\n\r\n  if aDBXConn &lt;&gt; nil then\r\n  begin\r\n\r\n    \/\/ Write the all connection parameters\r\n    Writeln('================= Connection Properties ============');\r\n    Writeln(aDBXConn.ConnectionProperties.Properties.Text);\r\n    Writeln('====================================================');\r\n    Writeln('');\r\n\r\n    aCmnd := aDBXConn.CreateCommand;\r\n\r\n    \/\/ Start transaction\r\n    aDBXTrans := aDBXConn.BeginTransaction(TDBXIsolations.ReadCommitted);\r\n\r\n    \/\/ Prepare and execute the SQL Statement\r\n    aCmnd.Text := 'SELECT * FROM Country';\r\n    aCmnd.Prepare;\r\n    aReader := aCmnd.ExecuteQuery;\r\n\r\n    aColCount := aReader.ColumnCount;\r\n    Writeln('Results from Query: ' + aCmnd.Text);\r\n    Writeln('Number of Columns:  ' + IntToStr(aColCount));\r\n\r\n    while aReader.Next do\r\n    begin\r\n      Writeln(aReader.Value['Country'].GetAnsiString);\r\n    end;\r\n\r\n    Writeln('====================================================');\r\n    Writeln('');\r\n\r\n    \/\/ Commit transaction\r\n    aDBXConn.CommitFreeAndNil(aDBXTrans);\r\n\r\n    Readln;\r\n    aReader.Free;\r\n    aCmnd.Free;\r\n    aDBXConn.Free;\r\n\r\n  end;\r\n\r\nend.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Tenho recebido muitas perguntas sobre como utilizar do dbExpress Framework para efetuar opera\u00e7\u00f5es no banco de dados, ent\u00e3o resolvi postar este exemplo de uma aplica\u00e7\u00e3o console, o exemplo \u00e9 bem f\u00e1cil de entender e mostra as op\u00e7\u00f5es b\u00e1sicas de conex\u00e3o, transa\u00e7\u00e3o e query. Pretende em futuros posts, explicar mais sobre o framework. program DBX4Example; {$APPTYPE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4202,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_s2mail":"yes","footnotes":""},"categories":[102],"tags":[33,181],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Utilizando o dbExpress (DBX) Framework em Delphi 2010 | Andreano Lanusse | Tecnologia e Desenvolvimento de Software<\/title>\n<meta name=\"description\" content=\"Tenho recebido muitas perguntas sobre como utilizar do dbExpress Framework para efetuar opera\u00e7\u00f5es no banco de dados, ent\u00e3o resolvi postar este exemplo de\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Utilizando o dbExpress (DBX) Framework em Delphi 2010 | Andreano Lanusse | Tecnologia e Desenvolvimento de Software\" \/>\n<meta property=\"og:description\" content=\"Tenho recebido muitas perguntas sobre como utilizar do dbExpress Framework para efetuar opera\u00e7\u00f5es no banco de dados, ent\u00e3o resolvi postar este exemplo de\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Andreano Lanusse | Tecnologia e Desenvolvimento de Software\" \/>\n<meta property=\"article:published_time\" content=\"2009-10-16T21:17:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-05-02T05:02:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/09\/Icon_Delphi.png\" \/>\n\t<meta property=\"og:image:width\" content=\"170\" \/>\n\t<meta property=\"og:image:height\" content=\"170\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@andreanolanusse\" \/>\n<meta name=\"twitter:site\" content=\"@andreanolanusse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\">\n\t<meta name=\"twitter:data1\" content=\"1 minuto\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#website\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"name\":\"Andreano Lanusse | Tecnologia e Desenvolvimento de Software\",\"description\":\"Andreano Lanusse blog - artigos, tutoriais e v&iacute;deos sobre tecnologia, desenvolvimento de software (Delphi XE4, C#, PHP, .NET) e t&eacute;cnicas de programa&ccedil;&atilde;o\",\"publisher\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"http:\/\/www.andreanolanusse.com\/pt\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/09\/Icon_Delphi.png\",\"contentUrl\":\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/09\/Icon_Delphi.png\",\"width\":170,\"height\":170},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#webpage\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/\",\"name\":\"Utilizando o dbExpress (DBX) Framework em Delphi 2010 | Andreano Lanusse | Tecnologia e Desenvolvimento de Software\",\"isPartOf\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#primaryimage\"},\"datePublished\":\"2009-10-16T21:17:52+00:00\",\"dateModified\":\"2013-05-02T05:02:24+00:00\",\"description\":\"Tenho recebido muitas perguntas sobre como utilizar do dbExpress Framework para efetuar opera\\u00e7\\u00f5es no banco de dados, ent\\u00e3o resolvi postar este exemplo de\",\"breadcrumb\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"name\":\"In\\u00edcio\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#webpage\"},\"author\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"headline\":\"Utilizando o dbExpress (DBX) Framework em Delphi 2010\",\"datePublished\":\"2009-10-16T21:17:52+00:00\",\"dateModified\":\"2013-05-02T05:02:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#webpage\"},\"commentCount\":35,\"publisher\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"image\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#primaryimage\"},\"keywords\":[\"dbExpress\",\"Delphi\"],\"articleSection\":[\"Delphi\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.andreanolanusse.com\/pt\/utilizando-o-dbexpress-dbx-framework-em-delphi-2010\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\",\"name\":\"Andreano Lanusse\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#personlogo\",\"inLanguage\":\"pt-BR\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/6a9c6f73c7c480fb826c7303288abfd3?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/6a9c6f73c7c480fb826c7303288abfd3?s=96&d=mm&r=g\",\"caption\":\"Andreano Lanusse\"},\"logo\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#personlogo\"},\"sameAs\":[\"https:\/\/twitter.com\/andreanolanusse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts\/419"}],"collection":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":0,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/media\/4202"}],"wp:attachment":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}