<div>
is Combo11 a field on your form, of a field in a table in the Database?
</div>


is Combo11 a field on your form, of a field in a table in the Database?

<div>
Thanks<br />
<br />
Will this statement also execute it?<br />
<br />

<pre><code id="code-20-39625089-1">conn.Execute (esql)</code></pre>
</div>


Thanks

Will this statement also execute it?



conn.Execute (esql)

<div>
<div class="content wysiwyg-content">
I would like to execute the following statement in vb6. &nbsp;Will this code work?<br />
<br />
esql = &quot;update tblRegistration set NewPart = 1 Where ID in (SELECT tblRegistration.ID FROM AttendanceGrid INNER JOIN tblRegistration ON AttendanceGrid.[ID]=tblReg<wbr />istration.<wbr />[ID]Where &nbsp;AttendanceGrid.Fiscal = '&quot; &amp;&nbsp;Fiscal &amp;&nbsp;&quot;' And AttendanceGrid.[CSW/TitleX<wbr />X] = 'C' And AttendanceGrid.Month = '&quot; &amp;&nbsp;Com(z) &amp;&nbsp;&quot;' And NewPart = 0 And &nbsp;Total &gt;&nbsp;0 And Combo11 like '&quot; &amp;&nbsp;rec1.Fields(0) &amp;&nbsp;&quot;')&quot;<br />
<br />
conn.Execute (esql)
</div>
</div>


I would like to execute the following statement in vb6.  Will this code work?

esql = "update tblRegistration set NewPart = 1 Where ID in (SELECT tblRegistration.ID FROM AttendanceGrid INNER JOIN tblRegistration ON AttendanceGrid.[ID]=tblRegistration.[ID]Where  AttendanceGrid.Fiscal = '" & Fiscal & "' And AttendanceGrid.[CSW/TitleXX] = 'C' And AttendanceGrid.Month = '" & Com(z) & "' And NewPart = 0 And  Total > 0 And Combo11 like '" & rec1.Fields(0) & "')"

conn.Execute (esql)

execute sql statement in vb6

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.