<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8452509785134415631</id><updated>2024-09-06T11:44:57.256-07:00</updated><category term="C#"/><category term="VB.NET"/><category term="ORACLE"/><category term="ABAP"/><category term="SIEBEL"/><category term="CRM"/><category term="SQL SERVER"/><category term=".NET Framework 4"/><category term="ASP.NET"/><title type='text'>Códigos de varias linguagens de Programação</title><subtitle type='html'>C#, VB.NET, C++, Java, Oracle, Crystal Reports, RUP, PMO e muito mais…</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>925</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-3236356750918680830</id><published>2012-05-21T06:46:00.000-07:00</published><updated>2012-05-21T06:46:44.367-07:00</updated><title type='text'>CreateQueryDef in Microsoft Access VBA</title><content type='html'>&lt;br /&gt;
&lt;h1 style=&quot;font-size: 13pt; line-height: 24px;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;CreateQueryDef in Microsoft Access VBA&lt;/span&gt;&lt;/h1&gt;
&lt;div align=&quot;left&quot; style=&quot;font-size: 14px; line-height: 20px;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;If you are like me you hate working on large databases with dozens or 100&#39;s of queries. Access&#39;s CreateQueryDef statement is a visual basic function which will clean up that growing list of queries and allow you to use form field variables with an SQL Server database back end.&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot; style=&quot;font-size: 14px; line-height: 20px;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot; style=&quot;font-size: 14px; line-height: 20px;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 20px;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Note that SQL Server won&#39;t let you pass a form field variable through to the server via a dynamically created query using this function.&lt;br /&gt;&lt;br /&gt;Createquerydef example follows below:&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;In this example we have a report selection/parameter form.&amp;nbsp; The form has a dropdown combo box which includes a description field for the report and a hidden field containing the name of the stored report definition.&amp;nbsp; The report Combo is called &#39;Rpt_Cbo&#39;.&amp;nbsp; There are also two report parameter fields; Start_Date and End_Date (in this example we aren&#39;t using End_Date).&amp;nbsp; VBA for the DAO version of the Access createquerydef code follows (see the ADO createquerydef version in the 2nd example):&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;Rpt_Cbo_AfterUpdate()&lt;br /&gt;&lt;br /&gt;Dim sqltext As String&lt;br /&gt;Dim qdfNew As DAO.QueryDef&lt;br /&gt;&lt;br /&gt;Select Case Me.Rpt_Cbo.Column(1)&lt;br /&gt;&amp;nbsp;Case &quot;AgencyReport&quot;&lt;br /&gt;&lt;br /&gt;&lt;span style=&quot;color: green;&quot;&gt;&#39;&amp;nbsp; build the create querydef sql&amp;nbsp; string&lt;/span&gt;&lt;br /&gt;sqltext = &quot;SELECT &quot; &amp;amp; Chr(34) &amp;amp; &quot; Billing for &quot; &amp;amp; Chr(34) &amp;amp; &quot; &amp;amp; [dbo_APRsMonthly].[StartDate] &amp;amp; &quot; &amp;amp; _&lt;br /&gt;&lt;br /&gt;Chr(34) &amp;amp; Through &amp;amp; Chr(34) &amp;amp; &quot; &amp;amp; [dbo_APRsMonthly].[EndDate] AS Description &amp;amp; _&lt;br /&gt;&lt;br /&gt;&quot; FROM (dbo_APRsMonthly INNER JOIN dbo_Boards ON&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; [dbo_APRsMonthly].[BoardID]=[dbo_Boards].[BoardID]) INNER JOIN dbo_Customers ON&amp;nbsp;[dbo_APRsMonthly].[customerID]=[dbo_Customers].[CustomerID] &quot; &amp;amp; _&lt;br /&gt;&lt;br /&gt;&quot;WHERE (Month([startdate])=Month(&quot; &amp;amp; Me.Start_date &amp;amp; &quot;) AND Year([startdate]=Year(&quot; &amp;amp; Me.Start_date &amp;amp; &quot;)) &quot; &amp;amp; _&lt;br /&gt;&lt;br /&gt;&quot; ORDER BY [dbo_APRsMonthly].[InvoiceNumber];&quot;&amp;nbsp;&lt;span style=&quot;color: green;&quot;&gt;&lt;br /&gt;&#39;&amp;nbsp; now create a reusable stored query def&lt;/span&gt;&lt;br /&gt;On Error Resume Next&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: green;&quot;&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;&amp;nbsp; is&amp;nbsp;run for the first time&lt;/span&gt;&lt;br /&gt;With CurrentDb&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: green;&quot;&gt;&amp;nbsp; &#39;&amp;nbsp; it would be better to check to see if the&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &#39;&amp;nbsp; querydef exists and then delete it&lt;/span&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; .QueryDefs.Delete (&quot;My_Query&quot;)&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: green;&quot;&gt;&#39;&amp;nbsp; createquerydef command line follows&lt;/span&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Set qdfNew = .CreateQueryDef (&quot;My_Query&quot;, sqltext)&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; .Close&lt;br /&gt;End With&lt;br /&gt;&lt;span style=&quot;color: green;&quot;&gt;&#39;&amp;nbsp; the recordsource of the report is called My_Query.&lt;/span&gt;&lt;br /&gt;DoCmd.OpenReport &quot;agencyconsolidatedinv&quot;, acViewPreview&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;End Select&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Aside: Another cool technique is to create a query definition using a global variable.&amp;nbsp; This way the user can never see the code in a protected database.&lt;/span&gt;&lt;/div&gt;
&lt;h2 align=&quot;left&quot; style=&quot;font-size: 10.5pt; font-weight: bold; line-height: 20px; text-decoration: none;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;ADO Version of the CreateQueryDef Function&lt;/span&gt;&lt;/h2&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Below is the Access CreateQueryDef ADO version for creating a saved query using VBA:&amp;nbsp; Note: You&#39;ll need to add a reference to the&amp;nbsp;&lt;b&gt;Microsoft ADO Ext. 2.1 for DDL and Security&amp;nbsp;&lt;/b&gt;library.&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;Rpt_Cbo_AfterUpdate()&lt;br /&gt;Dim cat As New ADOX.Catalog&lt;br /&gt;Dim cmd As New ADODB.Command&lt;br /&gt;Dim sqltext As String&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: green;&quot;&gt;&#39; create the sqltext as in the example above&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Set cat.ActiveConnection = CurrentProject.Connection&lt;/b&gt;&lt;br /&gt;&lt;b&gt;cmd.CommandText&lt;/b&gt;&amp;nbsp;sqltext&lt;br /&gt;&lt;b&gt;Cat.Views.Append&lt;/b&gt;&amp;nbsp;&quot;My_Query&quot;,&amp;nbsp;&lt;b&gt;cmd&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: x-small;&quot;&gt;&lt;a href=&quot;http://acessoparadesenvolvedor.blogspot.com/2012/05/docmd-openreport-syntax-options.html&quot;&gt;DoCmd OpenReport&lt;/a&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;left&quot;&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;b&gt;&lt;a href=&quot;http://acessoparadesenvolvedor.blogspot.com/&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Voltar ao Blog&lt;/span&gt;&lt;/a&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/3236356750918680830/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2012/05/createquerydef-in-microsoft-access-vba.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/3236356750918680830'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/3236356750918680830'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2012/05/createquerydef-in-microsoft-access-vba.html' title='CreateQueryDef in Microsoft Access VBA'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-1645849067928250998</id><published>2012-05-21T06:40:00.000-07:00</published><updated>2012-05-21T06:49:30.349-07:00</updated><title type='text'>DoCmd OpenReport Syntax, Options &amp; Examples</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Verdana; font-size: 16px; font-weight: bold; line-height: 24px;&quot;&gt;DoCmd OpenReport Syntax, Options &amp;amp; Examples&lt;/span&gt;&lt;br /&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
You can use the Open Report action to open a report in Design view or Print Preview, or to print the report immediately in screen view (normal view). You can also restrict the records that are printed in the report using a criteria option. The example (below) shows the Docmd.openreport method when used to restrict the selection of records.&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
Here are the syntax and options for the open report command:&lt;br /&gt;
&lt;br /&gt;
expr.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;expr&lt;/b&gt;&amp;nbsp;is a required expression in this case DoCmd.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;ReportName&lt;/b&gt;&amp;nbsp;is a required string variable. A variant string expression which is the name of a report in your database. If you run VBA code containing the OpenReport method in a library database, MS Access looks for the report with this name first in the library database and secondly in the current database.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;View&lt;/b&gt;&amp;nbsp;Optional AcView is the mode in which the report opens.&amp;nbsp; Acview can be anyone of the following constants:&lt;/div&gt;
&lt;ul style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acViewDesign - shows the report in design mode ready for modification&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acViewNormal (default)&amp;nbsp; Send the report to the current default printer queue&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acViewPreview - shows the report on the screen&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
&lt;b&gt;FilterName&lt;/b&gt;&amp;nbsp;is optional. A string expression that is a name of a query in the database.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;WhereCondition&lt;/b&gt;&amp;nbsp;optional string expression that&#39;s a valid SQL WHERE clause without the keyword&amp;nbsp;&lt;i&gt;WHERE&lt;/i&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;WindowMode&lt;/b&gt;&amp;nbsp;Optional AcWindowMode. The mode in which the report opens.&amp;nbsp; The AcWindowMode can be any of these AcWindowMode constants.&lt;/div&gt;
&lt;ul style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acDialog The report&#39;s Modal and PopUp properties are set to Yes.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acHidden The report is hidden.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acIcon The report opens minimized in the Windows taskbar.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div align=&quot;left&quot;&gt;
acWindowNormal default The report is in the mode set by its current properties settings.&lt;br /&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
&lt;b&gt;OpenArgs&lt;/b&gt;&amp;nbsp;Optionally sets the OpenArgs property.&lt;/div&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
Below is a VB examples showing the use of the openreport method.&amp;nbsp; The beginning of the code demonstrates the creation of a criteria option statement for the open report method.&amp;nbsp; The specific openreport code lines are bolded towards the bottom of the subroutine:&lt;/div&gt;
&lt;div align=&quot;left&quot; style=&quot;font-family: Verdana; font-size: 14px; line-height: 20px;&quot;&gt;
&lt;span style=&quot;font-family: Courier; font-size: x-small;&quot;&gt;Private Sub Command5_Click()&lt;br /&gt;&lt;br /&gt;Dim crit As String&lt;br /&gt;&lt;br /&gt;crit = &quot;Flight_ID&quot; &amp;amp; Choose(get_global(&quot;flight_type&quot;), &quot;&amp;gt;-1&quot;, &quot;=0&quot;, &quot;&amp;lt;&amp;gt;0&quot;)&lt;br /&gt;&lt;br /&gt;output:&lt;br /&gt;On Error GoTo no_data&lt;br /&gt;&lt;b&gt;Select Case Me.Select_Report&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Case 1&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DoCmd.OpenReport &quot;R_Dispatch_Report&quot;, acViewPreview, , crit&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Case 2&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DoCmd.OpenReport &quot;R_Dispatch_Pilot_Report&quot;, acViewPreview, , crit&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Case 3&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DoCmd.OpenReport &quot;R_Dispatch_Aircraft_Report&quot;, acViewPreview, crit&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Case 4&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DoCmd.OpenReport &quot;R_EDT_Change_Report&quot;, acViewPreview, , crit&lt;br /&gt;End Select&lt;/b&gt;&lt;br /&gt;Exit Sub&lt;br /&gt;local_err:&lt;br /&gt;rst.Close&lt;br /&gt;&#39; no reservations found&lt;br /&gt;no_data:&lt;br /&gt;Resume exit_ok&lt;br /&gt;exit_ok:&lt;br /&gt;&lt;br /&gt;End Sub&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://acessoparadesenvolvedor.blogspot.com/2012/05/createquerydef-in-microsoft-access-vba.html&quot;&gt;CreateQueryDef in Microsoft Access VBA&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://acessoparadesenvolvedor.blogspot.com/&quot;&gt;Voltar ao Blog&amp;nbsp;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/1645849067928250998/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2012/05/docmd-openreport-syntax-options.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1645849067928250998'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1645849067928250998'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2012/05/docmd-openreport-syntax-options.html' title='DoCmd OpenReport Syntax, Options &amp; Examples'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-5587020652170708107</id><published>2011-09-27T10:10:00.000-07:00</published><updated>2011-09-27T10:10:32.080-07:00</updated><title type='text'>SQL SERVER - Tamanho real da tabela no banco MS-SQL</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Tamanho real da tabela no banco MS-SQL&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #333333;&quot;&gt;&lt;b&gt;sp_spaceused&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;A sintaxe sp_spaceused&amp;nbsp;&lt;tabela&gt;exibe, respectivamente, o nome da tabela (name), número de linhas (rows), espaço reservado para a tabela (reserved), espaço usado pelos dados na tabela (data), espaço usado pelos indexes da tabela (index_size) e espaço sem uso na tabela (unused).&lt;br /&gt;&lt;br /&gt;Se nenhuma tabela for especificada, serão exibidos dois resultados:&lt;br /&gt;- nome da base de dados (database_name), tamanho da base (database_size) e espaço não alocado (unallocated space).&lt;br /&gt;- espaço reservado (reserved), espaço usado por dados na base de dados (data), espaço usado por indexes na base de dados (index_size) e espaço sem uso na base (unused).&lt;/tabela&gt;&lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/5587020652170708107/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/sql-server-tamanho-real-da-tabela-no.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/5587020652170708107'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/5587020652170708107'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/sql-server-tamanho-real-da-tabela-no.html' title='SQL SERVER - Tamanho real da tabela no banco MS-SQL'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-3620500023548354673</id><published>2011-09-27T10:08:00.000-07:00</published><updated>2011-09-27T10:08:42.731-07:00</updated><title type='text'>SQL SERVER - Tamanho real do banco MS-SQL</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;-webkit-border-horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; color: #333333; font-family: &#39;Trebuchet MS&#39;, Verdana, Arial, Helvetica; font-size: 18px;&quot;&gt;Como verificar o tamanho real do banco MS-SQL&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;-webkit-border-horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; color: #333333; font-family: &#39;Trebuchet MS&#39;, Verdana, Arial, Helvetica; font-size: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;-webkit-border-horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; color: #333333;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;b&gt;sp_helpdb&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;Usar a stored procedure sp_helpdb para obter informações sobre sua base de dados. A sintaxe sp_helpdb&amp;nbsp;&lt;nome_da_base&gt;exibe, respectivamente:&lt;br /&gt;&lt;br /&gt;- Nome da base de dados (name), tamanho (db_size), proprietário (owner), número de identificação da base (dbid), data de criação (created), opções da base (Status) e compatibilidade (compatibility_level - 80 = MS SQL Server 2000).&lt;br /&gt;- Nome lógico do arquivo de armazenamento (name), seu número de identificação (fileid), nome do arquivo (filename), seu filegroup, tamanho (size), tamanho máximo que poderão chegar (maxsize - espaço contratado), taxa de crescimento (growth) e para qual uso é designado o arquivo (usage - dados ou logs).&lt;/nome_da_base&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/3620500023548354673/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/sql-server-tamanho-real-do-banco-ms-sql.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/3620500023548354673'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/3620500023548354673'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/sql-server-tamanho-real-do-banco-ms-sql.html' title='SQL SERVER - Tamanho real do banco MS-SQL'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2930101589421080203</id><published>2011-09-02T11:22:00.000-07:00</published><updated>2011-09-02T11:22:56.552-07:00</updated><title type='text'>C# - Concatenação de String</title><content type='html'>&lt;br /&gt;
&lt;h2 style=&quot;color: #4f81bd; line-height: 19px; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 10pt; page-break-after: avoid;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: small;&quot;&gt;Concatenação de String&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #365f91; font-family: Arial, Helvetica, sans-serif; line-height: 13px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif; line-height: normal;&quot;&gt;&lt;span style=&quot;color: #365f91;&quot;&gt;Não faça isso:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif; line-height: normal;&quot;&gt;&lt;span style=&quot;color: #365f91;&quot;&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: #365f91;&quot;&gt;string str = &quot;Marcio &quot;;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;str += &quot;Paulo&quot;;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Faça isto:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;StringBuilder sb = new StringBuilder();&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;sb.Append(&quot;Marcio &quot;);&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;sb.Append(&quot;Paulo&quot;);&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;string str = sb.ToString();&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2930101589421080203/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-concatenacao-de-string.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2930101589421080203'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2930101589421080203'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-concatenacao-de-string.html' title='C# - Concatenação de String'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-8465524385524396819</id><published>2011-09-02T11:16:00.000-07:00</published><updated>2011-09-02T11:16:37.918-07:00</updated><title type='text'>C# - Comparação de Strings</title><content type='html'>&lt;br /&gt;
&lt;h2 style=&quot;color: #4f81bd; font-family: Cambria, serif; font-size: 13pt; line-height: 19px; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 10pt; page-break-after: avoid;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Comparação de Strings&lt;/span&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Melhor forma para comparar se duas strings são iguais?&amp;nbsp; Alguns usam o comparador de igualdade (==), ou o método Equals, desta forma:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;bool resultado = a == b;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;ou&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt; line-height: 14px;&quot;&gt;bool resultado = a.Equals(b);&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: x-small;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;line-height: 13px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Existe um meio mais eficiente de comparar strings, inclusive verificando se o objeto é nulo, levando-se em conta (ou não) o casing (maiúsculas e minúsculas)! Basta utilizar o método&lt;b&gt;&amp;nbsp;String.Compare(string a, string b, bool ignoreCase)&lt;/b&gt;. Veja:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;bool resultado = String.Compare(a, b, true) == 0;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Na verdade, este método retorna o seguinte:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 0.0001pt; margin-left: 36pt; margin-right: 0cm; margin-top: 0cm; text-indent: -18pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Symbol; font-size: 10pt; line-height: 14px;&quot;&gt;·&lt;span style=&quot;font: normal normal normal 7pt/normal &#39;Times New Roman&#39;;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;-1, se&amp;nbsp;&lt;b&gt;a&lt;/b&gt;&amp;nbsp;maior que&amp;nbsp;&lt;b&gt;b&lt;/b&gt;;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 0.0001pt; margin-left: 36pt; margin-right: 0cm; margin-top: 0cm; text-indent: -18pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Symbol; font-size: 10pt; line-height: 14px;&quot;&gt;·&lt;span style=&quot;font: normal normal normal 7pt/normal &#39;Times New Roman&#39;;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;0 , se&amp;nbsp;&lt;b&gt;a&lt;/b&gt;&amp;nbsp;igual a&amp;nbsp;&lt;b&gt;b&lt;/b&gt;;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 36pt; margin-right: 0cm; margin-top: 0cm; text-indent: -18pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Symbol; font-size: 10pt; line-height: 14px;&quot;&gt;·&lt;span style=&quot;font: normal normal normal 7pt/normal &#39;Times New Roman&#39;;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;1, se&amp;nbsp;&lt;b&gt;a&amp;nbsp;&amp;nbsp;&lt;/b&gt;menor que&amp;nbsp;&lt;b&gt;b&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/8465524385524396819/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-comparacao-de-strings.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8465524385524396819'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8465524385524396819'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-comparacao-de-strings.html' title='C# - Comparação de Strings'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-4569587439400477048</id><published>2011-09-02T11:15:00.000-07:00</published><updated>2011-09-02T11:15:24.457-07:00</updated><title type='text'>C# - Verificação de Strings vazias</title><content type='html'>&lt;br /&gt;
&lt;h2 style=&quot;color: #4f81bd; line-height: 19px; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 10pt; page-break-after: avoid;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: small;&quot;&gt;Verificação de Strings vazias&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Erro grottesco , não faça isso:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;if (str == &quot;&quot; || str == null)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Para testar se uma string é nula ou vazia, use o método&lt;b&gt;String.IsNullOrEmpty(string a)&lt;/b&gt;.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Veja:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;if (String.IsNullOrEmpty(str))&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/4569587439400477048/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-verificacao-de-strings-vazias.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4569587439400477048'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4569587439400477048'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-verificacao-de-strings-vazias.html' title='C# - Verificação de Strings vazias'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-8863902459825047119</id><published>2011-09-02T11:14:00.000-07:00</published><updated>2011-09-02T11:14:02.184-07:00</updated><title type='text'>C# - Strings com elementos repetidos</title><content type='html'>&lt;br /&gt;
&lt;h2 style=&quot;color: #4f81bd; line-height: 19px; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 10pt; page-break-after: avoid;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif; font-size: small;&quot;&gt;Strings com elementos repetidos&lt;/span&gt;&lt;/span&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Strings com caracteres repetidos, mas queria apenas mostrar a que considero mais simples:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;string s = new string(&#39;*&#39;, 20);&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/8863902459825047119/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-strings-com-elementos-repetidos.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8863902459825047119'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8863902459825047119'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-strings-com-elementos-repetidos.html' title='C# - Strings com elementos repetidos'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-4986426607429149085</id><published>2011-09-02T11:12:00.001-07:00</published><updated>2011-09-02T11:12:39.331-07:00</updated><title type='text'>C# - String IndexOf com case insensitive</title><content type='html'>&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-size: 10pt; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;A&amp;nbsp; classe String possui várias implementações do método IndexOf, que localiza em uma string a posição de outra string dada. O problema é que todas as implementações são &quot;case sensitive&quot;, ou seja, levam em consideração caracteres maiúsculos e minúsculos.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-size: 10pt; line-height: 14px;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;O&amp;nbsp; que pouca gente sabe é que, para resolver este problema, existe a classe&lt;b&gt;CompareInfo&amp;nbsp;&lt;/b&gt;dentro do namespace&amp;nbsp;&lt;b&gt;Globalization&lt;/b&gt;.&amp;nbsp; Esta classe possui um método IndexOf que não leva em conta maiúsculas e minúsculas (case insensitive). Veja:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-size: 9.5pt;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;using System.Globalization;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-size: 9.5pt;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;string s1 = &quot;Trabalhar com C# é DEMAIS!&quot;; string s2 = &quot;demais&quot;;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-size: 9.5pt;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;CompareInfo Compare = CultureInfo.InvariantCulture.CompareInfo;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-size: 9.5pt;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;int i = Compare.IndexOf(s1, s2, CompareOptions.IgnoreCase);&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/4986426607429149085/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-string-indexof-com-case-insensitive.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4986426607429149085'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4986426607429149085'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-string-indexof-com-case-insensitive.html' title='C# - String IndexOf com case insensitive'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2436492823244419026</id><published>2011-09-02T11:11:00.000-07:00</published><updated>2011-09-02T11:11:27.655-07:00</updated><title type='text'>C# - Conversão de string para números</title><content type='html'>&lt;br /&gt;
&lt;h2 style=&quot;color: #4f81bd; font-family: Cambria, serif; font-size: 13pt; line-height: 19px; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 10pt; page-break-after: avoid;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Conversão de string para números&lt;/span&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Como converter uma string para um número?&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 17px; margin-bottom: 10pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Cada tipo numérico possui um método estático chamado&amp;nbsp;&lt;b&gt;TryParse&lt;/b&gt;. Para converter uma string num tipo numérico específico, basta criar uma variável do tipo desejado e passá-la como parâmetro de saída do método TryParse.&amp;nbsp;&lt;/span&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;&quot;&gt;Assim:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;string s = &quot;42&quot;;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;int i;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span lang=&quot;EN-US&quot; style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;if (int.TryParse(s, out i))&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;{&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; //Conversão OK&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;}&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;else&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;{&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; //Conversão Não OK&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;color: #5185bd; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin-bottom: 0.0001pt; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; text-indent: 35.45pt;&quot;&gt;
&lt;span style=&quot;color: #365f91; font-family: Consolas; font-size: 9.5pt;&quot;&gt;}&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2436492823244419026/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-conversao-de-string-para-numeros.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2436492823244419026'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2436492823244419026'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-conversao-de-string-para-numeros.html' title='C# - Conversão de string para números'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-8265721074499359251</id><published>2011-09-01T07:35:00.001-07:00</published><updated>2011-09-23T09:34:51.772-07:00</updated><title type='text'>C# - Formatar números com zeros a esquerda</title><content type='html'>&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;b&gt;Formatar números com zeros a esquerda&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;No exemplo abaixo, é mostrado como formatar com zeros á esquerda.&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;int X = 38002;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;String zeros = &quot;0000000000&quot;;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;String numero = zeros + x;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;System.out.println(numero.substring(numero.length() - 10));&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;ou use esta outra forma ( Obs.: Sugestão de um leitor, grato por participar deste blog) :&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;Faça assim que é melhor:&lt;br /&gt;01 int pos = 10;&lt;br /&gt;02 String.Format(&quot;{0:00000}&quot;, pos); //&quot;00010&quot;&amp;nbsp;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/8265721074499359251/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-formatar-numeros-com-zeros-esquerda.html#comment-form' title='3 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8265721074499359251'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8265721074499359251'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/09/c-formatar-numeros-com-zeros-esquerda.html' title='C# - Formatar números com zeros a esquerda'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>3</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-4589278632972968758</id><published>2011-08-04T16:44:00.001-07:00</published><updated>2011-08-04T16:44:00.996-07:00</updated><title type='text'>FoxPro - MESSAGEBOX( ) Function</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;MESSAGEBOX( ) Function&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;MESSAGEBOX(eMessageText [, nDialogBoxType ][, cTitleBarText][, nTimeout])&lt;/span&gt;&lt;/pre&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;MESSAGEBOX(&quot;HELLO&quot;,&quot;MyTitle&quot;,68,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,&quot;MyTitle&quot;,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,6000,&quot;MyTitle&quot;)&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;eMessageTitle = &#39;My Application&#39;
eMessageText = &#39;Record not found. Would you like to search again?&#39;
nDialogType = 4 + 16 + 256
*  4 = Yes and No buttons
*  16 = Stop sign icon
*  256 = Second button is default

nAnswer = MESSAGEBOX(eMessageText, nDialogType, eMessageTitle)

DO CASE
   CASE nAnswer = 6
      WAIT WINDOW &#39;You chose Yes&#39;
   CASE nAnswer = 7
      WAIT WINDOW &#39;You chose No&#39;
ENDCASE&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/4589278632972968758/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function_04.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4589278632972968758'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4589278632972968758'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function_04.html' title='FoxPro - MESSAGEBOX( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-1597255220645829497</id><published>2011-08-04T16:43:00.000-07:00</published><updated>2011-08-04T16:43:14.091-07:00</updated><title type='text'>FoxPro - MESSAGEBOX( ) Function</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;MESSAGEBOX( ) Function&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;MESSAGEBOX(eMessageText [, nDialogBoxType ][, cTitleBarText][, nTimeout])&lt;/pre&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;MESSAGEBOX(&quot;HELLO&quot;,&quot;MyTitle&quot;,68,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,&quot;MyTitle&quot;,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,6000)
MESSAGEBOX(&quot;HELLO&quot;,68,6000,&quot;MyTitle&quot;)&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;br /&gt;
&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;eMessageTitle = &#39;My Application&#39;
eMessageText = &#39;Record not found. Would you like to search again?&#39;
nDialogType = 4 + 16 + 256
*  4 = Yes and No buttons
*  16 = Stop sign icon
*  256 = Second button is default

nAnswer = MESSAGEBOX(eMessageText, nDialogType, eMessageTitle)

DO CASE
   CASE nAnswer = 6
      WAIT WINDOW &#39;You chose Yes&#39;
   CASE nAnswer = 7
      WAIT WINDOW &#39;You chose No&#39;
ENDCASE&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/1597255220645829497/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1597255220645829497'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1597255220645829497'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function.html' title='FoxPro - MESSAGEBOX( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-6494694607082797270</id><published>2011-08-04T16:41:00.001-07:00</published><updated>2012-05-21T09:44:06.926-07:00</updated><title type='text'>FoxPro - MESSAGEBOX( ) Function</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;MESSAGEBOX( ) Function&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;MESSAGEBOX(DATE())&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/6494694607082797270/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function_5925.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/6494694607082797270'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/6494694607082797270'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-messagebox-function_5925.html' title='FoxPro - MESSAGEBOX( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-7062793500675926532</id><published>2011-08-04T16:40:00.001-07:00</published><updated>2011-08-04T16:40:54.113-07:00</updated><title type='text'>FoxPro - PUTFILE( ) Function</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;PUTFILE( ) Function&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;PUTFILE([cCustomText] [, cFileName] [, cFileExtensions])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;gcTableName = GETFILE(&#39;DBF&#39;, &#39;Open Table:&#39;)
USE (gcTableName)
gcDelimName = ALIAS( ) + &#39;.DLM&#39;
gcDelimFile = PUTFILE(&#39;Delimited file:&#39;, gcDelimName, &#39;DLM&#39;)
IF EMPTY(gcDelimFile)  &amp;amp;&amp;amp; Esc pressed
   CANCEL
ENDIF
COPY TO (gcDelimFile) DELIMITED   &amp;amp;&amp;amp; Create delimited file
MODIFY FILE (gcDelimFile) NOEDIT&lt;/pre&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/7062793500675926532/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-putfile-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7062793500675926532'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7062793500675926532'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-putfile-function.html' title='FoxPro - PUTFILE( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2963899308206912581</id><published>2011-08-04T16:39:00.000-07:00</published><updated>2011-08-04T16:39:07.599-07:00</updated><title type='text'>FoxPro - INPUTBOX( ) Function</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;INPUTBOX( ) Function&lt;/h1&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;INPUTBOX(cInputPrompt [, cDialogCaption [, cDefaultValue [, nTimeout [,cTimeoutValue] [,cCancelValue]]]])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example1:&lt;/pre&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Y = &quot;Nothing at all&quot;
Y = INPUTBOX(&quot;TypeHere&quot;,&quot;Input &quot;,Y,5000)
         &amp;amp;&amp;amp; Displays dialog box for 5 seconds, &lt;/pre&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example2:&lt;/pre&gt;&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLEAR
Y = INPUTBOX(&quot;Type Here:&quot;, &quot;Input Title&quot;,  ;
&quot;Nothing at all&quot;, 5000, &#39;Timed Out&#39;, &#39;Canceled&#39;)
? Y&lt;/pre&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2963899308206912581/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-inputbox-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2963899308206912581'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2963899308206912581'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-inputbox-function.html' title='FoxPro - INPUTBOX( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-8649958922031802974</id><published>2011-08-04T11:13:00.001-07:00</published><updated>2011-08-04T11:13:46.826-07:00</updated><title type='text'>FoxPro - DATE( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;DATE( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;DATE([nYear, nMonth, nDay])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLEAR
SET CENTURY OFF
? DATE( )  &amp;amp;&amp;amp; Displays today&#39;s date without the century
SET CENTURY ON
? DATE( )  &amp;amp;&amp;amp; Displays today&#39;s date with the century
? DATE(1998, 02, 16)  &amp;amp;&amp;amp; Displays a year 2000-compliant Date value&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/8649958922031802974/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-date-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8649958922031802974'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/8649958922031802974'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-date-function.html' title='FoxPro - DATE( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2710639834467137623</id><published>2011-08-04T11:11:00.001-07:00</published><updated>2011-08-04T11:11:57.471-07:00</updated><title type='text'>FoxPro - SET ORDER Command</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;SET ORDER Command&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;SET ORDER TO [nIndexNumber | IDXIndexFileName | [TAG] TagName 
   [OF CDXFileName] [IN nWorkArea | cTableAlias]
   [ASCENDING | DESCENDING]]&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;USE video INDEX title.idx, costs.cdx, rating.idx IN 1&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;SET ORDER TO 1
Controlling index: C:\FOX30\TITLE.IDX 
SET ORDER TO 2
Controlling index: C:\FOX30\RATING.IDX &lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;SET ORDER TO 3
Controlling index: C:\FOX30\VIDEO.CDX  Tag: NUMBERSOLD 
SET ORDER TO 4
Controlling index: C:\FOX30\VIDEO.CDX  Tag: YEARSOLD &lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;SET ORDER TO 5
Controlling index: C:\FOX30\COSTS.CDX  Tag: RENTALCOST
SET ORDER TO 6
Controlling index: C:\FOX30\COSTS.CDX  Tag: BUYCOST&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2710639834467137623/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-set-order-command.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2710639834467137623'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2710639834467137623'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-set-order-command.html' title='FoxPro - SET ORDER Command'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-1115245972917650093</id><published>2011-08-04T11:10:00.000-07:00</published><updated>2011-08-04T11:10:28.309-07:00</updated><title type='text'>FoxPro - INDEXSEEK( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;INDEXSEEK( ) Function&lt;/h1&gt;&lt;div&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-size: 13px; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;INDEXSEEK(eExpression [, lMovePointer [, nWorkArea | cTableAlias
   [, nIndexNumber | cIDXIndexFileName | cTagName]]])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-size: 13px; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-size: 13px; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Consolas, Courier, monospace;&quot;&gt;INDEXSEEK( ) returns true (.T.) if a match is found; otherwise false (.F.) is returned. You can use INDEXSEEK( ) only with a table with an index order set, and you can search only for an index key. The match must be exact unless SET EXACT is set to OFF.

INDEXSEEK( ) provides a fast way to search for records without moving the record pointer. Because the record pointer isn&#39;t moved, rules and triggers aren&#39;t executed. If INDEXSEEK( ) returns true (.T.) indicating that a matching record is found, you can execute INDEXSEEK( ) again with the second parameter lMovePointer set to true (.T.) to move to the matching record.

INDEXSEEK( ) returns false (.F.) when you are attempting to find a value in the most recently created record (created with INSERT INTO or APPEND BLANK) until the record pointer is moved. You can execute a GO BOTTOM command to cause INDEXSEEK( ) to find the most recently created record.
Função Turbo e Slow
Conector USB ( não possui conector USB e entrada para PC)

&lt;/span&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: Consolas, Courier, monospace; font-size: 13px; font-style: normal; font-weight: normal;&quot;&gt;
&lt;/span&gt;&lt;/pre&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/1115245972917650093/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-indexseek-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1115245972917650093'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/1115245972917650093'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-indexseek-function.html' title='FoxPro - INDEXSEEK( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2516433984266413431</id><published>2011-08-04T11:08:00.002-07:00</published><updated>2011-08-04T11:08:50.203-07:00</updated><title type='text'>FoxPro - FOUND( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;FOUND( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;FOUND([nWorkArea | cTableAlias])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLOSE DATABASES
OPEN DATABASE (HOME(2) + &#39;Data\TestData&#39;)
USE Customer
STORE 0 TO gnCount
LOCATE FOR UPPER(Country)=&#39;GERMANY&#39;
DO WHILE FOUND()
   gnCount = gnCount + 1
   CONTINUE
ENDDO
? &quot;Total customers from Germany: &quot;+LTRIM(STR(gnCount))&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2516433984266413431/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-found-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2516433984266413431'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2516433984266413431'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-found-function.html' title='FoxPro - FOUND( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-9182383403550115507</id><published>2011-08-04T11:08:00.000-07:00</published><updated>2011-08-04T11:08:01.224-07:00</updated><title type='text'>FoxPro - EOF( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;EOF( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;EOF([nWorkArea | cTableAlias])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLOSE DATABASES
CLEAR
OPEN DATABASE (HOME() + &quot;samples\data\testdata&quot;)
USE customer
GO TOP
local recCtr, btnValue
recCtr = 0
btnValue = 1
DO WHILE btnValue = 1 AND NOT EOF()
  ? &quot;Company : &quot; + company
  recCtr = recCtr + 1
  if (recCtr % 20) = 0 then
    btnValue =MESSAGEBOX (&quot;Click OK to continue, ;
     Cancel to quit.&quot;,33)
    clear
  endif
  Skip 1    &amp;amp;&amp;amp; Move down one record
ENDDO
=MESSAGEBOX(&quot;Listing complete.&quot;,48)&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/9182383403550115507/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-eof-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/9182383403550115507'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/9182383403550115507'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-eof-function.html' title='FoxPro - EOF( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-7409081488340848923</id><published>2011-08-04T11:07:00.000-07:00</published><updated>2011-08-04T11:07:02.034-07:00</updated><title type='text'>FoxPro - SEEK( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;SEEK( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;SEEK(eExpression [, nWorkArea | cTableAlias
   [, nIndexNumber | cIDXIndexFileName | cTagName]])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLOSE DATABASES
OPEN DATABASE (HOME(2) + &#39;Data\testdata&#39;)
USE customer ORDER cust_id  &amp;amp;&amp;amp; Opens Customer table
? SEEK(&#39;CHOPS&#39;)  &amp;amp;&amp;amp; Returns .T., record found&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/7409081488340848923/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-seek-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7409081488340848923'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7409081488340848923'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-seek-function.html' title='FoxPro - SEEK( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-4494182476994872737</id><published>2011-08-04T11:03:00.000-07:00</published><updated>2011-08-04T11:03:35.881-07:00</updated><title type='text'>FoxPro - ICASE( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;ICASE( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;ICASE( lCondition1, eResult1 [, lCondition2, eResult2] ... 
   [, eOtherwiseResult])&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;? ICASE(1+1=2,&quot;First is true&quot;,1+1=3,&quot;Second is false&quot;,&quot;None are true&quot;)&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;? ICASE(1+2=2,&quot;First is false&quot;,1+1=3,&quot;Second is false&quot;,&quot;None are true&quot;)&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/4494182476994872737/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-icase-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4494182476994872737'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/4494182476994872737'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-icase-function.html' title='FoxPro - ICASE( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-7893073309155694030</id><published>2011-08-04T11:01:00.001-07:00</published><updated>2011-08-04T11:01:46.234-07:00</updated><title type='text'>FoxPro - #IF ... #ENDIF Preprocessor Directive</title><content type='html'>&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;#IF ... #ENDIF Preprocessor Directive&lt;/h1&gt;&lt;div&gt;
&lt;/div&gt;&lt;/span&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;#IF nExpression1 | lExpression1 
      Commands
[#ELIF nExpression2 | #ELIF lExpression2
      Commands...
#ELIF nExpressionN | #ELIF lExpressionN
      Commands] 
[#ELSE 
      Commands]
#ENDIF&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;#If SYS(3004) = &quot;1033&quot;
? &quot;Locale ID is English&quot;
#Elif SYS(3004) = &quot;1034&quot;
? &quot;Locale ID is Spanish&quot;
#Elif SYS(3004) = &quot;1031&quot;
? &quot;Locale ID is German&quot;
#Elif SYS(3004) = &quot;1036&quot;
? &quot;Locale ID is French&quot;
#Endif &lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/7893073309155694030/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-if-endif-preprocessor-directive.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7893073309155694030'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/7893073309155694030'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-if-endif-preprocessor-directive.html' title='FoxPro - #IF ... #ENDIF Preprocessor Directive'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8452509785134415631.post-2433591142942704917</id><published>2011-08-04T07:32:00.002-07:00</published><updated>2011-08-04T07:32:56.963-07:00</updated><title type='text'>FoxPro - IIF( ) Function</title><content type='html'>&lt;h1 class=&quot;title&quot; style=&quot;color: #3f529c; font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 1.769em; font-style: normal; font-variant: normal; font-weight: bold; line-height: normal; margin-bottom: 10px; margin-left: 0px; margin-right: 0px; margin-top: 0px;&quot;&gt;IIF( ) Function&lt;/h1&gt;&lt;div&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; font-size: 13px;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;IIF(lExpression, eExpression1, eExpression2)&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;Example:&lt;/pre&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;&lt;span class=&quot;Apple-style-span&quot; style=&quot;font-family: &#39;Segoe UI&#39;, Verdana, Arial; white-space: normal;&quot;&gt;&lt;pre style=&quot;font-family: Consolas, Courier, monospace; font-style: normal; font-weight: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; word-break: break-all; word-wrap: break-word;&quot;&gt;CLOSE DATABASES
OPEN DATABASE (HOME(2) + &#39;Data\testdata&#39;)
USE employee  &amp;amp;&amp;amp; Open Employee table
CLEAR

SCAN
   ? IIF(EMPTY(notes), &#39;No notes&#39;, notes)    &amp;amp;&amp;amp; Empty memo field?
ENDSCAN&lt;/pre&gt;&lt;/span&gt;&lt;/pre&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://acessoparadesenvolvedor.blogspot.com/feeds/2433591142942704917/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-iif-function.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2433591142942704917'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8452509785134415631/posts/default/2433591142942704917'/><link rel='alternate' type='text/html' href='http://acessoparadesenvolvedor.blogspot.com/2011/08/foxpro-iif-function.html' title='FoxPro - IIF( ) Function'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>