[Gambas-user] Delete record in DB

[Peter]

Hallo Benoit,

Am Montag, 14. März 2005 13:07 schrieb Benoit Minisini:
> On Saturday 12 March 2005 18:13, Peter wrote:
> > Hallo all,
> >
> > a short while ago I work with MySQL in Gambas. It's all ok, but I have 2
> > problblems:
> > 1.
> > $hConnect is open ...
> >
> > PUBLIC SUB ktoloeBUT_Click()
> > DIM ktoRes AS Result
> >     $hConnect.Begin
> >     ktoRes = $hConnect.Edit("Konten")
> >     FOR EACH ktoRes
> >       IF ktoRes!konto = ktoCBX.Text THEN
> >         ktoRes.Delete
> >         BREAK
> >       ENDIF
> >     NEXT
> >     $hConnect.Commit
> > END
> >
> > The found konto - record is not deleted! What I make false?
>
> Record is deleted, but it does not disappear from the Result object. This
> will change in the future.
>
> > 2.  It's possible to define a autoincrement field for a Table in Gambas?
>
> They are not supported yet.
>
Thanks. I make now both with $hConnect.Exec("...mysql-command...")

Regards,

Peter