[Gambas-user] Delete record in DB

[Benoit Minisini]

On Tuesday 15 March 2005 00:00, Peter wrote:
> Hallo Maurice,
>
> in place of
> ktoRes.Delete works:

But the Delete must work, otherwise this is a bug.

> ktoRes = $hconnect.Exec("DELETE FROM Konten WHERE konto = '"
>  & ktoCBX.Text & "'")

And this command is buggy! You don't quote the quote characters. You MUST 
write: 

ktoRes = $hconnect.Exec("DELETE FROM Konten WHERE konto = &1", ktoCBX.Text)

Regards,

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