{"id":2115,"date":"2024-10-28T15:26:32","date_gmt":"2024-10-28T15:26:32","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=2115"},"modified":"2026-09-13T17:03:11","modified_gmt":"2026-09-13T17:03:11","slug":"fpw-como-criar-uma-consulta-sql-no-fpw","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/fpw-como-criar-uma-consulta-sql-no-fpw\/","title":{"rendered":"FPw | Como criar uma consulta SQL no FPw"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2115\" class=\"elementor elementor-2115\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-086770d e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"086770d\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7f66c1 elementor-widget elementor-widget-heading\" data-id=\"a7f66c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Como criar uma consulta SQL no FPw<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fbbe7 elementor-widget elementor-widget-text-editor\" data-id=\"b6fbbe7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6>Est\u00e1 p\u00e1gina cont\u00e9m links patrocinados!<\/h6><p data-sourcepos=\"3:1-3:14\"><strong>Introdu\u00e7\u00e3o<\/strong><\/p><p data-sourcepos=\"5:1-5:400\">O FileMaker Pro (FPw) \u00e9 um poderoso software de gerenciamento de banco de dados que permite criar solu\u00e7\u00f5es personalizadas para diversas necessidades. Uma das ferramentas mais importantes do FPw \u00e9 a capacidade de criar consultas SQL (Structured Query Language). Atrav\u00e9s das consultas SQL, voc\u00ea pode extrair dados espec\u00edficos de seus bancos de dados, realizar an\u00e1lises complexas e automatizar tarefas.<\/p><p data-sourcepos=\"7:1-7:156\">Este guia completo ir\u00e1 te conduzir passo a passo no processo de cria\u00e7\u00e3o de consultas SQL no FPw, desde os conceitos b\u00e1sicos at\u00e9 as t\u00e9cnicas mais avan\u00e7adas.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-269f1cc elementor-widget elementor-widget-video\" data-id=\"269f1cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=7kY7zckCBXU&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-621913e elementor-widget elementor-widget-text-editor\" data-id=\"621913e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-sourcepos=\"9:1-9:40\"><strong>O que \u00e9 SQL e por que us\u00e1-lo no FPw?<\/strong><\/p><p data-sourcepos=\"11:1-11:137\">SQL \u00e9 uma linguagem padr\u00e3o para gerenciar e manipular bancos de dados relacionais. Ela permite que voc\u00ea execute diversas opera\u00e7\u00f5es, como:<\/p><ul data-sourcepos=\"13:1-20:0\"><li data-sourcepos=\"13:1-13:79\"><strong>Selecionar dados:<\/strong> Extrair informa\u00e7\u00f5es espec\u00edficas de uma ou mais tabelas.<\/li><li data-sourcepos=\"14:1-14:60\"><strong>Inserir dados:<\/strong> Adicionar novos registros a uma tabela.<\/li><li data-sourcepos=\"15:1-15:64\"><strong>Atualizar dados:<\/strong> Modificar dados existentes em uma tabela.<\/li><li data-sourcepos=\"16:1-16:53\"><strong>Excluir dados:<\/strong> Remover registros de uma tabela.<\/li><li data-sourcepos=\"17:1-17:58\"><strong>Criar tabelas:<\/strong> Definir a estrutura de novas tabelas.<\/li><li data-sourcepos=\"18:1-18:67\"><strong>Alterar tabelas:<\/strong> Modificar a estrutura de tabelas existentes.<\/li><li data-sourcepos=\"19:1-20:0\"><strong>Criar \u00edndices:<\/strong> Otimizar a performance de consultas.<\/li><\/ul><p data-sourcepos=\"21:1-21:199\">Ao utilizar SQL no FPw, voc\u00ea ganha maior flexibilidade e controle sobre seus dados, podendo realizar consultas mais complexas e personalizadas do que as oferecidas pela interface gr\u00e1fica do programa.<\/p><p data-sourcepos=\"23:1-23:28\"><strong>Conceitos B\u00e1sicos de SQL<\/strong><\/p><p data-sourcepos=\"25:1-25:90\">Antes de come\u00e7ar a criar consultas, \u00e9 importante entender alguns conceitos b\u00e1sicos de SQL:<\/p><ul data-sourcepos=\"27:1-33:0\"><li data-sourcepos=\"27:1-27:103\"><strong>Tabelas:<\/strong> S\u00e3o estruturas que armazenam dados organizados em linhas (registros) e colunas (campos).<\/li><li data-sourcepos=\"28:1-28:78\"><strong>Campos:<\/strong> Representam as diferentes informa\u00e7\u00f5es armazenadas em uma tabela.<\/li><li data-sourcepos=\"29:1-29:82\"><strong>Registros:<\/strong> S\u00e3o as linhas de uma tabela, contendo os valores para cada campo.<\/li><li data-sourcepos=\"30:1-30:81\"><strong>Cla\u00fasula SELECT:<\/strong> Utilizada para selecionar os dados que voc\u00ea deseja exibir.<\/li><li data-sourcepos=\"31:1-31:88\"><strong>Cla\u00fasula FROM:<\/strong> Especifica a tabela ou tabelas de onde os dados ser\u00e3o selecionados.<\/li><li data-sourcepos=\"32:1-33:0\"><strong>Cla\u00fasula WHERE:<\/strong> Permite filtrar os resultados da consulta com base em determinadas condi\u00e7\u00f5es.<\/li><\/ul><p data-sourcepos=\"34:1-34:44\"><strong>Criando sua Primeira Consulta SQL no FPw<\/strong><\/p><ol data-sourcepos=\"36:1-41:0\"><li data-sourcepos=\"36:1-36:115\"><strong>Abra o seu banco de dados:<\/strong> Inicie o FileMaker Pro e abra o banco de dados onde voc\u00ea deseja criar a consulta.<\/li><li data-sourcepos=\"37:1-37:111\"><strong>Acesse o modo de layout:<\/strong> Clique no modo de layout para visualizar a estrutura das suas tabelas e campos.<\/li><li data-sourcepos=\"38:1-38:73\"><strong>Crie um novo script:<\/strong> V\u00e1 ao menu Scripts e selecione &#8220;Novo Script&#8221;.<\/li><li data-sourcepos=\"39:1-39:105\"><strong>Adicione uma etapa &#8220;Executar SQL&#8221; ao script:<\/strong> Arraste a etapa &#8220;Executar SQL&#8221; para a \u00e1rea de script.<\/li><li data-sourcepos=\"40:1-41:0\"><strong>Digite a sua consulta SQL:<\/strong> Na caixa de di\u00e1logo da etapa &#8220;Executar SQL&#8221;, digite a sua consulta. Por exemplo, para selecionar todos os registros da tabela &#8220;Clientes&#8221;, voc\u00ea pode usar a seguinte consulta:<\/li><\/ol><div class=\"code-block ng-tns-c855887729-52 ng-trigger ng-trigger-codeBlockRevealAnimation\"><div class=\"code-block-decoration header gmat-subtitle-1 ng-tns-c855887729-52 ng-star-inserted\"><span class=\"ng-tns-c855887729-52\">SQL<\/span><\/div><div class=\"code-block-internal-container ng-tns-c855887729-52\"><div class=\"animated-opacity ng-tns-c855887729-52\"><pre class=\"ng-tns-c855887729-52\"><code class=\"code-container ng-tns-c855887729-52\" role=\"text\" data-test-id=\"code-content\" data-sourcepos=\"42:1-44:22\"><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> Clientes\n<\/code><\/pre><\/div><\/div><div class=\"code-block-decoration footer gmat-overline ng-tns-c855887729-52 hide-from-message-actions ng-star-inserted\"><div class=\"ng-tns-c855887729-52\"><span class=\"ng-tns-c855887729-52\">Use o c\u00f3digo <a class=\"disclaimer-suffix ng-tns-c855887729-52\" href=\"\/faq#coding\" target=\"_blank\" rel=\"noopener\" aria-label=\"com cuidado (abre em uma nova janela)\">com cuidado<\/a>.<\/span><\/div><div class=\"buttons ng-tns-c855887729-52\">\u00a0<\/div><\/div><\/div><ol start=\"6\" data-sourcepos=\"46:1-47:0\"><li data-sourcepos=\"46:1-47:0\"><strong>Execute o script:<\/strong> Clique no bot\u00e3o &#8220;Executar&#8221; para executar o script e visualizar os resultados da consulta.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be147cd elementor-widget elementor-widget-text-editor\" data-id=\"be147cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-sourcepos=\"48:1-48:37\"><strong>Exemplo de Consulta Mais Complexa<\/strong><\/p><p data-sourcepos=\"50:1-50:232\">Imagine que voc\u00ea tenha uma tabela chamada &#8220;Pedidos&#8221; com os campos &#8220;ID&#8221;, &#8220;Cliente&#8221;, &#8220;Data&#8221; e &#8220;Valor&#8221;. Para encontrar todos os pedidos realizados por um determinado cliente em um determinado m\u00eas, voc\u00ea poderia usar a seguinte consulta:<\/p><div class=\"code-block ng-tns-c855887729-53 ng-trigger ng-trigger-codeBlockRevealAnimation\"><div class=\"code-block-decoration header gmat-subtitle-1 ng-tns-c855887729-53 ng-star-inserted\"><span class=\"ng-tns-c855887729-53\">SQL<\/span><\/div><div class=\"code-block-internal-container ng-tns-c855887729-53\"><div class=\"animated-opacity ng-tns-c855887729-53\"><pre class=\"ng-tns-c855887729-53\"><code class=\"code-container ng-tns-c855887729-53\" role=\"text\" data-test-id=\"code-content\" data-sourcepos=\"52:1-55:75\"><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> Pedidos\n<span class=\"hljs-keyword\">WHERE<\/span> Cliente <span class=\"hljs-operator\">=<\/span> \"Jo\u00e3o Silva\" <span class=\"hljs-keyword\">AND<\/span> Data <span class=\"hljs-keyword\">BETWEEN<\/span> <span class=\"hljs-string\">'2023-01-01'<\/span> <span class=\"hljs-keyword\">AND<\/span> <span class=\"hljs-string\">'2023-01-31'<\/span>\n<\/code><\/pre><\/div><\/div><div class=\"code-block-decoration footer gmat-overline ng-tns-c855887729-53 hide-from-message-actions ng-star-inserted\"><div class=\"ng-tns-c855887729-53\"><span class=\"ng-tns-c855887729-53\">Use o c\u00f3digo <a class=\"disclaimer-suffix ng-tns-c855887729-53\" href=\"\/faq#coding\" target=\"_blank\" rel=\"noopener\" aria-label=\"com cuidado (abre em uma nova janela)\">com cuidado<\/a>.<\/span><\/div><div class=\"buttons ng-tns-c855887729-53\">\u00a0<\/div><\/div><\/div><p data-sourcepos=\"57:1-57:15\"><strong>Fun\u00e7\u00f5es SQL<\/strong><\/p><p data-sourcepos=\"59:1-59:134\">O SQL oferece diversas fun\u00e7\u00f5es que podem ser utilizadas para manipular dados e realizar c\u00e1lculos. Algumas das fun\u00e7\u00f5es mais comuns s\u00e3o:<\/p><ul data-sourcepos=\"61:1-64:0\"><li data-sourcepos=\"61:1-61:53\"><strong>Fun\u00e7\u00f5es matem\u00e1ticas:<\/strong> SUM, AVG, COUNT, MIN, MAX.<\/li><li data-sourcepos=\"62:1-62:56\"><strong>Fun\u00e7\u00f5es de texto:<\/strong> UPPER, LOWER, CONCAT, SUBSTRING.<\/li><li data-sourcepos=\"63:1-64:0\"><strong>Fun\u00e7\u00f5es de data:<\/strong> YEAR, MONTH, DAY, NOW.<\/li><\/ul><p data-sourcepos=\"65:1-65:22\"><strong>Join entre Tabelas<\/strong><\/p><p data-sourcepos=\"67:1-67:201\">Muitas vezes, voc\u00ea precisar\u00e1 combinar dados de duas ou mais tabelas. Para isso, voc\u00ea utiliza a cl\u00e1usula JOIN. Existem diferentes tipos de JOIN, como INNER JOIN, LEFT JOIN, RIGHT JOIN e FULL OUTER JOIN.<\/p><p data-sourcepos=\"69:1-69:16\"><strong>Subconsultas<\/strong><\/p><p data-sourcepos=\"71:1-71:151\">Subconsultas s\u00e3o consultas aninhadas dentro de outras consultas. Elas permitem realizar consultas mais complexas e filtrar dados de forma mais precisa.<\/p><p data-sourcepos=\"73:1-73:27\"><strong>Agrupamento e Ordena\u00e7\u00e3o<\/strong><\/p><p data-sourcepos=\"75:1-75:90\">As cl\u00e1usulas GROUP BY e ORDER BY permitem agrupar e ordenar os resultados de uma consulta.<\/p><p data-sourcepos=\"77:1-77:37\"><strong>Criando Relat\u00f3rios Personalizados<\/strong><\/p><p data-sourcepos=\"79:1-79:205\">As consultas SQL podem ser utilizadas para criar relat\u00f3rios personalizados no FileMaker Pro. Voc\u00ea pode criar layouts personalizados para exibir os resultados das suas consultas de forma clara e organizada.<\/p><p data-sourcepos=\"81:1-81:45\"><strong>Dicas para Criar Consultas SQL Eficientes<\/strong><\/p><ul data-sourcepos=\"83:1-87:0\"><li data-sourcepos=\"83:1-83:97\"><strong>Seja espec\u00edfico:<\/strong> Quanto mais espec\u00edfica for a sua consulta, mais r\u00e1pido ela ser\u00e1 executada.<\/li><li data-sourcepos=\"84:1-84:115\"><strong>Utilize \u00edndices:<\/strong> Crie \u00edndices para os campos que s\u00e3o frequentemente utilizados em cl\u00e1usulas WHERE e ORDER BY.<\/li><li data-sourcepos=\"85:1-85:89\"><strong>Evite usar fun\u00e7\u00f5es nas cl\u00e1usulas WHERE:<\/strong> Fun\u00e7\u00f5es podem tornar a consulta mais lenta.<\/li><li data-sourcepos=\"86:1-87:0\"><strong>Otimize as suas consultas:<\/strong> Utilize ferramentas de an\u00e1lise de desempenho para identificar gargalos e otimizar suas consultas.<\/li><\/ul><p data-sourcepos=\"88:1-88:13\"><strong>Conclus\u00e3o<\/strong><\/p><p data-sourcepos=\"90:1-90:219\">As consultas SQL s\u00e3o uma ferramenta poderosa para trabalhar com dados no FileMaker Pro. Com este guia, voc\u00ea aprendeu os conceitos b\u00e1sicos e as t\u00e9cnicas mais importantes para criar consultas eficientes e personalizadas.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"680\" height=\"544\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/consulta-sql.jpg\" class=\"attachment-large size-large wp-image-2116\" alt=\"Como criar uma consulta SQL no FPw\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/consulta-sql.jpg 680w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/consulta-sql-300x240.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/consulta-sql-600x480.jpg 600w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8308cc3 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"8308cc3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9104777 wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"9104777\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:113,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-9253 post type-post status-publish format-standard has-post-thumbnail hentry category-excel\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" alt=\"Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9168 post type-post status-publish format-standard has-post-thumbnail hentry category-excel tag-aprenda-como-usar-no-excel-avancado tag-aprenda-todas-as-possibilidades-de-formatacoes-no-excel tag-como-desproteger-um-arquivo-do-excel-protegido-por-senha tag-crie-um-sistema-de-sorteio-no-excel-de-forma-simples tag-dashboard tag-dashboard-financeiro tag-dashboard-financeiro-pessoal tag-dashboard-para-controle-financeiro tag-dashboard-rh-controle-de-desligamentos tag-dashboard-seguranca-do-trabalho tag-excel tag-formula-se-com-procv tag-funcao-arrumar-com-alguns-truques tag-funcoes-basicas-do-excel tag-funcoes-basicas-operadores tag-grafico-medidor-de-bateria tag-menu-dados-completo tag-montando-um-resumo-de-diversas-planilhas-com-somase tag-planilha-de-controle-financeiro-tudo-o-que-voce-precisa-saber tag-planilhas tag-procv-junto-com-o-corresp tag-protegendo-celulas tag-saiba-tudo-da-parte-de-dados tag-software-de-planilha-online-gratuito-excel-microsoft-365 tag-tudo-sobre-formatacao-de-celulas tag-tudo-sobre-lista-suspensa-no-excel tag-tudo-sobre-tabela-e-graficos-dinamicos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.jpg\" alt=\"Como corrigir o erro #N\/D no Excel?\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\">Excel | Como corrigir o erro #N\/D no Excel?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9018 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-o-que-e-fpw-on-prime tag-o-que-significa-fpw tag-porque-o-fpw-trocou-de-nome tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.jpg\" alt=\"Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\">FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ecca24c elementor-widget elementor-widget-image\" data-id=\"ecca24c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/v2\/checkout\/Np76f1h2\/L8i882t3\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"440\" height=\"529\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw-curso1.png\" class=\"attachment-large size-large wp-image-8815\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw-curso1.png 440w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw-curso1-250x300.png 250w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ab7380 elementor-widget elementor-widget-image\" data-id=\"9ab7380\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/v2\/checkout\/Fr8vdtu3\/Mrfgzyu5\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"256\" height=\"256\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw2-1.png\" class=\"attachment-large size-large wp-image-8816\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw2-1.png 256w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw2-1-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/07\/fpw2-1-230x230.png 230w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3722802 elementor-widget elementor-widget-link-in-bio\" data-id=\"3722802\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"link-in-bio.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio e-link-in-bio\">\n\t\t\t<div class=\"e-link-in-bio__content\">\n\n\t\t\t\t\t\t<div class=\"e-link-in-bio__identity\">\n\t\t\t\t\t\t\t\t\t<div class=\"e-link-in-bio__identity-image e-link-in-bio__identity-image-profile has-style-circle\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"291\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png\" class=\"e-link-in-bio__identity-image-element\" alt=\"Marco Antonio Chinarelli\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli.png 386w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__bio\">\n\t\t\t\t<h3 class=\"e-link-in-bio__heading\">Marco Chinarelli<\/h3>\t\t\t\t<h3 class=\"e-link-in-bio__title\">Especialista e FPw, LG Nuvem e Sistemas de Folha  de Pagamento<\/h3>\t\t\t\t\t\t\t\t<p class=\"e-link-in-bio__description\">Sua empresa precisa mudar de sistema, n\u00f3s preparamos odos os dados para entrar no novo sistema, prestamos servi\u00e7os de suporte, parametriza\u00e7\u00e3o e treinamentos.<\/p>\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__icons has-size-small\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/chinarelliti\/\" target=\"_blank\" rel=\"noopener \" aria-label=\"LinkedIn\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin-in\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.instagram.com\/marco_chinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"Instagram\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-instagram\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M224.1 141c-63.6 0-114.9 51.3-114.9 114.9s51.3 114.9 114.9 114.9S339 319.5 339 255.9 287.7 141 224.1 141zm0 189.6c-41.1 0-74.7-33.5-74.7-74.7s33.5-74.7 74.7-74.7 74.7 33.5 74.7 74.7-33.6 74.7-74.7 74.7zm146.4-194.3c0 14.9-12 26.8-26.8 26.8-14.9 0-26.8-12-26.8-26.8s12-26.8 26.8-26.8 26.8 12 26.8 26.8zm76.1 27.2c-1.7-35.9-9.9-67.7-36.2-93.9-26.2-26.2-58-34.4-93.9-36.2-37-2.1-147.9-2.1-184.9 0-35.8 1.7-67.6 9.9-93.9 36.1s-34.4 58-36.2 93.9c-2.1 37-2.1 147.9 0 184.9 1.7 35.9 9.9 67.7 36.2 93.9s58 34.4 93.9 36.2c37 2.1 147.9 2.1 184.9 0 35.9-1.7 67.7-9.9 93.9-36.2 26.2-26.2 34.4-58 36.2-93.9 2.1-37 2.1-147.8 0-184.8zM398.8 388c-7.8 19.6-22.9 34.7-42.6 42.6-29.5 11.7-99.5 9-132.1 9s-102.7 2.6-132.1-9c-19.6-7.8-34.7-22.9-42.6-42.6-11.7-29.5-9-99.5-9-132.1s-2.6-102.7 9-132.1c7.8-19.6 22.9-34.7 42.6-42.6 29.5-11.7 99.5-9 132.1-9s102.7-2.6 132.1 9c19.6 7.8 34.7 22.9 42.6 42.6 11.7 29.5 9 99.5 9 132.1s2.7 102.7-9 132.1z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/@dashimpressionador\" target=\"_blank\" rel=\"noopener \" aria-label=\"YouTube\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-youtube\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/twitter.com\/mchinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"X (Twitter)\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-x-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t<div class=\"e-link-in-bio__ctas has-type-button\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/wa.link\/olj5an\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tSolicite um or\u00e7amento para Migra\u00e7\u00e3o de Dados\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a href=\"https:\/\/wa.link\/ggcd34\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tSolicite um or\u00e7amento para Consultoria\/Suporte\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t\t<\/div>\n\t\t\t<div class=\"e-link-in-bio__bg\">\n\t\t\t\t<div class=\"e-link-in-bio__bg-overlay\"><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a9e882 elementor-widget elementor-widget-image\" data-id=\"8a9e882\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"#preco\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"480\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/CAIXAS.png\" class=\"attachment-large size-large wp-image-6280\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/CAIXAS.png 320w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/CAIXAS-200x300.png 200w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Como criar uma consulta SQL no FPw Est\u00e1 p\u00e1gina cont\u00e9m links patrocinados! Introdu\u00e7\u00e3o O FileMaker Pro (FPw) \u00e9 um poderoso software de gerenciamento de banco de dados que permite criar solu\u00e7\u00f5es personalizadas para diversas necessidades. Uma das ferramentas mais importantes do FPw \u00e9 a capacidade de criar consultas SQL (Structured Query Language). Atrav\u00e9s das consultas SQL, voc\u00ea pode extrair dados espec\u00edficos de seus bancos de dados, realizar an\u00e1lises complexas e automatizar tarefas. Este guia completo ir\u00e1 te conduzir passo a passo no processo de cria\u00e7\u00e3o de consultas SQL no FPw, desde os conceitos b\u00e1sicos at\u00e9 as t\u00e9cnicas mais avan\u00e7adas. https:\/\/www.youtube.com\/watch?v=7kY7zckCBXU O que \u00e9 SQL e por que us\u00e1-lo no FPw? SQL \u00e9 uma linguagem padr\u00e3o para gerenciar e manipular bancos de dados relacionais. Ela permite que voc\u00ea execute diversas opera\u00e7\u00f5es, como: Selecionar dados: Extrair informa\u00e7\u00f5es espec\u00edficas de uma ou mais tabelas. Inserir dados: Adicionar novos registros a uma tabela. Atualizar dados: Modificar dados existentes em uma tabela. Excluir dados: Remover registros de uma tabela. Criar tabelas: Definir a estrutura de novas tabelas. Alterar tabelas: Modificar a estrutura de tabelas existentes. Criar \u00edndices: Otimizar a performance de consultas. Ao utilizar SQL no FPw, voc\u00ea ganha maior flexibilidade e controle sobre seus dados, podendo realizar consultas mais complexas e personalizadas do que as oferecidas pela interface gr\u00e1fica do programa. Conceitos B\u00e1sicos de SQL Antes de come\u00e7ar a criar consultas, \u00e9 importante entender alguns conceitos b\u00e1sicos de SQL: Tabelas: S\u00e3o estruturas que armazenam dados organizados em linhas (registros) e colunas (campos). Campos: Representam as diferentes informa\u00e7\u00f5es armazenadas em uma tabela. Registros: S\u00e3o as linhas de uma tabela, contendo os valores para cada campo. Cla\u00fasula SELECT: Utilizada para selecionar os dados que voc\u00ea deseja exibir. Cla\u00fasula FROM: Especifica a tabela ou tabelas de onde os dados ser\u00e3o selecionados. Cla\u00fasula WHERE: Permite filtrar os resultados da consulta com base em determinadas condi\u00e7\u00f5es. Criando sua Primeira Consulta SQL no FPw Abra o seu banco de dados: Inicie o FileMaker Pro e abra o banco de dados onde voc\u00ea deseja criar a consulta. Acesse o modo de layout: Clique no modo de layout para visualizar a estrutura das suas tabelas e campos. Crie um novo script: V\u00e1 ao menu Scripts e selecione &#8220;Novo Script&#8221;. Adicione uma etapa &#8220;Executar SQL&#8221; ao script: Arraste a etapa &#8220;Executar SQL&#8221; para a \u00e1rea de script. Digite a sua consulta SQL: Na caixa de di\u00e1logo da etapa &#8220;Executar SQL&#8221;, digite a sua consulta. Por exemplo, para selecionar todos os registros da tabela &#8220;Clientes&#8221;, voc\u00ea pode usar a seguinte consulta: SQL SELECT * FROM Clientes Use o c\u00f3digo com cuidado.\u00a0 Execute o script: Clique no bot\u00e3o &#8220;Executar&#8221; para executar o script e visualizar os resultados da consulta. Exemplo de Consulta Mais Complexa Imagine que voc\u00ea tenha uma tabela chamada &#8220;Pedidos&#8221; com os campos &#8220;ID&#8221;, &#8220;Cliente&#8221;, &#8220;Data&#8221; e &#8220;Valor&#8221;. Para encontrar todos os pedidos realizados por um determinado cliente em um determinado m\u00eas, voc\u00ea poderia usar a seguinte consulta: SQL SELECT * FROM Pedidos WHERE Cliente = &#8220;Jo\u00e3o Silva&#8221; AND Data BETWEEN &#8216;2023-01-01&#8217; AND &#8216;2023-01-31&#8217; Use o c\u00f3digo com cuidado.\u00a0 Fun\u00e7\u00f5es SQL O SQL oferece diversas fun\u00e7\u00f5es que podem ser utilizadas para manipular dados e realizar c\u00e1lculos. Algumas das fun\u00e7\u00f5es mais comuns s\u00e3o: Fun\u00e7\u00f5es matem\u00e1ticas: SUM, AVG, COUNT, MIN, MAX. Fun\u00e7\u00f5es de texto: UPPER, LOWER, CONCAT, SUBSTRING. Fun\u00e7\u00f5es de data: YEAR, MONTH, DAY, NOW. Join entre Tabelas Muitas vezes, voc\u00ea precisar\u00e1 combinar dados de duas ou mais tabelas. Para isso, voc\u00ea utiliza a cl\u00e1usula JOIN. Existem diferentes tipos de JOIN, como INNER JOIN, LEFT JOIN, RIGHT JOIN e FULL OUTER JOIN. Subconsultas Subconsultas s\u00e3o consultas aninhadas dentro de outras consultas. Elas permitem realizar consultas mais complexas e filtrar dados de forma mais precisa. Agrupamento e Ordena\u00e7\u00e3o As cl\u00e1usulas GROUP BY e ORDER BY permitem agrupar e ordenar os resultados de uma consulta. Criando Relat\u00f3rios Personalizados As consultas SQL podem ser utilizadas para criar relat\u00f3rios personalizados no FileMaker Pro. Voc\u00ea pode criar layouts personalizados para exibir os resultados das suas consultas de forma clara e organizada. Dicas para Criar Consultas SQL Eficientes Seja espec\u00edfico: Quanto mais espec\u00edfica for a sua consulta, mais r\u00e1pido ela ser\u00e1 executada. Utilize \u00edndices: Crie \u00edndices para os campos que s\u00e3o frequentemente utilizados em cl\u00e1usulas WHERE e ORDER BY. Evite usar fun\u00e7\u00f5es nas cl\u00e1usulas WHERE: Fun\u00e7\u00f5es podem tornar a consulta mais lenta. Otimize as suas consultas: Utilize ferramentas de an\u00e1lise de desempenho para identificar gargalos e otimizar suas consultas. Conclus\u00e3o As consultas SQL s\u00e3o uma ferramenta poderosa para trabalhar com dados no FileMaker Pro. Com este guia, voc\u00ea aprendeu os conceitos b\u00e1sicos e as t\u00e9cnicas mais importantes para criar consultas eficientes e personalizadas. All Posts Blog Certificados Diversos Excel FPw Membros Not\u00edcias Planilhas Produtos SQL Tecnologia WordPress Planilhas | Controle Financeiro 2.6 Leia mais Excel | Bot\u00f5es interativos no Excel Leia mais Excel | Automa\u00e7\u00e3o no Excel Leia mais Marco Chinarelli Especialista e FPw, LG Nuvem e Sistemas de Folha de Pagamento Sua empresa precisa mudar de sistema, n\u00f3s preparamos odos os dados para entrar no novo sistema, prestamos servi\u00e7os de suporte, parametriza\u00e7\u00e3o e treinamentos. Solicite um or\u00e7amento para Migra\u00e7\u00e3o de Dados Solicite um or\u00e7amento para Consultoria\/Suporte<\/p>\n","protected":false},"author":2000,"featured_media":2116,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[106,107,21,18,20,19,54,24,8,22,45,23,42,17],"class_list":["post-2115","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fpw","tag-como-cadastrar-grupo-hierarquico-no-fpw","tag-como-emitir-a-folha-de-pagamento-no-sistema-fpw","tag-curso-fpw","tag-fpw","tag-fpw-nuvem","tag-fpw-on-prime","tag-lg-nuvem-e-gen-te-nuvem-sao-os-mesmos-sistemas","tag-o-fpw-e-destaque-entre-os-sistemas-de-folha-de-pagamento","tag-o-que-e-fpw-on-prime","tag-o-que-significa-fpw","tag-onde-encontrar-um-curso-de-sistema-fpw","tag-porque-o-fpw-trocou-de-nome","tag-qual-o-significado-de-fpw-onprime","tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/consulta-sql.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/2115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=2115"}],"version-history":[{"count":3,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/2115\/revisions"}],"predecessor-version":[{"id":8861,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/2115\/revisions\/8861"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/2116"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=2115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=2115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=2115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}