<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><<</p>
<pre class="moz-quote-pre" wrap="">Le 30/05/2019 ? 10:54, David Silverwood via User a ?crit?:
</pre>
<blockquote type="cite" style="color: #000000;">
<pre class="moz-quote-pre" wrap="">Hi. Me again
So this is my code...
/Public Sub btnUpdate_Click()/
//
/? ? $Sql = "UPDATE cashup SET ("/
/? ? $Sql = $Sql & "date = '" & edtDate.Text & "', "/
/? ? $Sql = $Sql & "ref = '" & edtTransNo.Text & "', "/
/? ? $Sql = $Sql & "amount = " & ValueBox1.Text & ", "/
/? ? $Sql = $Sql & "comment = '" & edtDescription.Text & "', "/
/? ? $Sql = $Sql & "WHERE date = '" & edtDate.Text & "';"/
//
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">You MUST NOT make your SQL request like that.
NEVER.</pre>
<p>>></p>
<p>Ouch</p>
<p>K.<br>
</p>
</body>
</html>