[Gambas-user] Gambas DB basic update record example

[Benoit Minisini]

On Wednesday 29 September 2004 03:53, Iwan Prasetyo wrote:
> To create a new record, I use this:
> 	rData=hConn.Create ("dataku")
>
> It works properly...
>
>
> To edit, should I type this:
> 	rData=hConn.Edit ("dataku","where id=" & textbox1.text)
>
> It doesn't work...no error but the record is still the same..no changes
> made...
>
>
> Regards,
>
> Iwan Prasetyo

You must not put "where", and you should not use '&' to create the query.

The good syntax is: rData = hConn.Edit("dataku", "id = &1", textBox1.Text)

Regards,

-- 
Benoit Minisini
mailto:gambas at ...1...