[Gambas-user] Database manager problem

[Fabien Bodard]

Le Mardi 27 Décembre 2005 23:23, Jacky a écrit :
> Le Samedi 24 Décembre 2005 15:11, Fabien Bodard a écrit :
> > > With database manager, when i save a table with auto_increment
> > > attribut, i lose this attribut. Is it normal ?
> > > Gambas 1.9.20 or Gambas 1.0.11
> > > Suse 9.3
> >
> > yes, Gambas db not support auto_increment attribute... but i hope Benoit
> > add this, because it's really usefull...
> >
> > Before that i use this :
> >
> > hres = hCon.Exec("Select Max(id) From Client")
> > newid = hRes["Max(id)"] + 1
>
> Salut,
> no, no Fabien, with an unique key the auto_increment works fine. It's with
> the database manager that we lose the auto_increment attribut. Simply
> saving table lose this attribut.
>  ~° Jack °~
>

I just repeat what i've saying... In fact gb.db dont support the 
autoincrement !

When you are saving a single entry, you don't change the table structure you 
have create with an sql statement.

But when you save a table structure in the manager, it use the gb.db interface 
and not sql command... And gb.db layer have not autoincrement option ... so 
it is lose during this opération !.

Benoit ?

Is it possible to add this ?

Regards,
Fabien Bodard