[Gambas-user] Delete record in DB

Benoit Minisini gambas at ...1...
Mon Mar 14 13:07:27 CET 2005


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.

> Regards
> Peter
>

Regards,

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




More information about the User mailing list