[Gambas-user] Using dates in Gambas

[KKing]

<<

Le 30/05/2019 ? 10:54, David Silverwood via User a ?crit?:

> 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 & "';"/
> //

You MUST NOT make your SQL request like that.

NEVER.

 >>

Ouch

K.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190531/b624e5d3/attachment.html>