<div>
Thanks for closing the question.<br />
<br />
Not sure why you graded as 'B' though, as you never responded to seek clarification or ask for further information.<br />
<br />
If the above responses were not clear, all you had to do was ask for additional assistance.<br />
<br />
BFN,<br />
<br />
fp.
</div>


Thanks for closing the question.

Not sure why you graded as 'B' though, as you never responded to seek clarification or ask for further information.

If the above responses were not clear, all you had to do was ask for additional assistance.

BFN,

fp.

<div>
<div class="content wysiwyg-content">
Can someone explain to me the usage of quotes and double quotes in this statement:<br />
<br />
cmdcustomers.commandtext=&quot;<wbr />Update Customers set&quot; _<br />
&amp;&nbsp;&quot;LastName= ' &quot;&nbsp;&amp; Customer.Lastname &amp;&nbsp;&quot; ' ,Fisrtname= ' &quot;_<br />
&amp;&nbsp;Customer.Firstanem &amp;&nbsp;&quot; '<br />
<br />
I know that sql statement needs to be between double quotes, &nbsp;but I don't know why in some cases they use single quotes and double quotes together.<br />
<br />
Thanks
</div>
</div>


Can someone explain to me the usage of quotes and double quotes in this statement:

cmdcustomers.commandtext="Update Customers set" _
& "LastName= ' " & Customer.Lastname & " ' ,Fisrtname= ' "_
& Customer.Firstanem & " '

I know that sql statement needs to be between double quotes,  but I don't know why in some cases they use single quotes and double quotes together.

Thanks

Quotes and double quotes in SQL Statement

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.