[Gambas-user] Delete record in DB

[Peter]

Hallo Benoit,

Am Dienstag, 15. März 2005 09:59 schrieb 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.
Then it is a bug (Gambas 1.0.1), is work definitely not.
>
> > ktoRes = $hconnect.Exec("DELETE FROM Konten WHERE konto = '"
> >  & ktoCBX.Text & "'")
>
> And this command is buggy!
I am sory, but its work. I know this notation from another SQL-Systems and 
have it testing here.
> You don't quote the quote characters. You MUST 
> write:
>
> ktoRes = $hconnect.Exec("DELETE FROM Konten WHERE konto = &1", ktoCBX.Text)
>
Regards

Peter