<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="pt-BR">
	<id>http://wiki.phsys.com.br/index.php?action=history&amp;feed=atom&amp;title=Procedimento_ParamByName</id>
	<title>Procedimento ParamByName - Histórico de revisão</title>
	<link rel="self" type="application/atom+xml" href="http://wiki.phsys.com.br/index.php?action=history&amp;feed=atom&amp;title=Procedimento_ParamByName"/>
	<link rel="alternate" type="text/html" href="http://wiki.phsys.com.br/index.php?title=Procedimento_ParamByName&amp;action=history"/>
	<updated>2026-09-20T14:05:26Z</updated>
	<subtitle>Histórico de revisões para esta página neste wiki</subtitle>
	<generator>MediaWiki 1.31.10</generator>
	<entry>
		<id>http://wiki.phsys.com.br/index.php?title=Procedimento_ParamByName&amp;diff=4993&amp;oldid=prev</id>
		<title>Endrio.korb em 17h14min de 29 de janeiro de 2025</title>
		<link rel="alternate" type="text/html" href="http://wiki.phsys.com.br/index.php?title=Procedimento_ParamByName&amp;diff=4993&amp;oldid=prev"/>
		<updated>2025-01-29T17:14:05Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;pt-BR&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;← Edição anterior&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #222; text-align: center;&quot;&gt;Edição das 17h14min de 29 de janeiro de 2025&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot; &gt;Linha 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Linha 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;−&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;A &lt;del class=&quot;diffchange diffchange-inline&quot;&gt;função &lt;/del&gt;&amp;#039;&amp;#039;&amp;#039;ParamByName&amp;#039;&amp;#039;&amp;#039; permite que seja incluído as informação dentro de um SQL de forma dinâmica.&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;+&lt;/td&gt;&lt;td style=&quot;color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;A &lt;ins class=&quot;diffchange diffchange-inline&quot;&gt;procedimento &lt;/ins&gt;&amp;#039;&amp;#039;&amp;#039;ParamByName&amp;#039;&amp;#039;&amp;#039; permite que seja incluído as informação dentro de um SQL de forma dinâmica.&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;===&amp;#039;&amp;#039;&amp;#039;Sintaxe&amp;#039;&amp;#039;&amp;#039;===&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;===&amp;#039;&amp;#039;&amp;#039;Sintaxe&amp;#039;&amp;#039;&amp;#039;===&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;procedure ParamByName(const:string);&lt;/div&gt;&lt;/td&gt;&lt;td class=&#039;diff-marker&#039;&gt;&amp;#160;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;procedure ParamByName(const:string);&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Endrio.korb</name></author>
		
	</entry>
	<entry>
		<id>http://wiki.phsys.com.br/index.php?title=Procedimento_ParamByName&amp;diff=4987&amp;oldid=prev</id>
		<title>Endrio.korb: Criou página com &#039;A função &#039;&#039;&#039;ParamByName&#039;&#039;&#039; permite que seja incluído as informação dentro de um SQL de forma dinâmica. ===&#039;&#039;&#039;Sintaxe&#039;&#039;&#039;=== procedure ParamByName(const:string);  ===&#039;&#039;&#039;Pa...&#039;</title>
		<link rel="alternate" type="text/html" href="http://wiki.phsys.com.br/index.php?title=Procedimento_ParamByName&amp;diff=4987&amp;oldid=prev"/>
		<updated>2025-01-29T16:33:54Z</updated>

		<summary type="html">&lt;p&gt;Criou página com &amp;#039;A função &amp;#039;&amp;#039;&amp;#039;ParamByName&amp;#039;&amp;#039;&amp;#039; permite que seja incluído as informação dentro de um SQL de forma dinâmica. ===&amp;#039;&amp;#039;&amp;#039;Sintaxe&amp;#039;&amp;#039;&amp;#039;=== procedure ParamByName(const:string);  ===&amp;#039;&amp;#039;&amp;#039;Pa...&amp;#039;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Página nova&lt;/b&gt;&lt;/p&gt;&lt;div&gt;A função &amp;#039;&amp;#039;&amp;#039;ParamByName&amp;#039;&amp;#039;&amp;#039; permite que seja incluído as informação dentro de um SQL de forma dinâmica.&lt;br /&gt;
===&amp;#039;&amp;#039;&amp;#039;Sintaxe&amp;#039;&amp;#039;&amp;#039;===&lt;br /&gt;
procedure ParamByName(const:string);&lt;br /&gt;
&lt;br /&gt;
===&amp;#039;&amp;#039;&amp;#039;Parâmetros&amp;#039;&amp;#039;&amp;#039;===&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;width: 100%&amp;quot;&lt;br /&gt;
! Nome &lt;br /&gt;
!Tipo&lt;br /&gt;
!Descrição&lt;br /&gt;
|-&lt;br /&gt;
|Q&lt;br /&gt;
|String&lt;br /&gt;
|Inclui o paramêtro no SQL&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===&amp;#039;&amp;#039;&amp;#039;Exemplos&amp;#039;&amp;#039;&amp;#039;===&lt;br /&gt;
&lt;br /&gt;
   Q.add(&amp;#039;SELECT * &amp;#039;+&lt;br /&gt;
         &amp;#039;FROM MUNICIPIOS &amp;#039;+&lt;br /&gt;
         &amp;#039;WHERE NOME = :MUNICIPIO &amp;#039;)&lt;br /&gt;
   Q.ParamByName(&amp;#039;MUNICIPIO&amp;#039;).AsString := &amp;#039;Blumenau&amp;#039;; // Irá trocar &amp;quot;:MUNICIPIO&amp;quot; por &amp;quot;Blumenau&amp;quot;&lt;br /&gt;
   Q.Open;&lt;/div&gt;</summary>
		<author><name>Endrio.korb</name></author>
		
	</entry>
</feed>