[Gambas-user] Database problem

[juanra]

OK Benoit,

I execute the example of Data base of Gambas2.

I create the tables “test” and “color” and fill the tables.    

When I want to insert an element new filling the fields:    

.- Id: 5000  
.- First Name: Juan  
.- Name: Santi    

And the rest in target.

Pressing the icon “to keep” to insert it in the table leaves the error:
“Cannot create record: Duplicate entry “5000” for key 1”.

Acceptance error in the end if inserts in the table and if not insert
field 'Id:' The error is: "You must fill all mandatory fields".


If I make a small example with an empty table, 

.- Id: 5000  
.- First Name: Juan  
.- Name: Santi    

the first registry that inserted already leaves the error: “Cannot
create record: Duplicate entry “5000” for key 1”.

Please es very important resolve this problem.

Thanks,

> On Thursday 17 August 2006 13:41, juanra wrote:
> > - Id: 500
> > - First Name: PEPE
> > - Name: SASA
> >
> > The rest of fields in target.
> >
> > Pressing the icon “new” of the control of the Datasource and writing all
> > the Datacontrol and when pressing the icon “to keep” to insert it in the
> > table leaves the error: “Cannot create record: Duplicate entry “xxx” for
> > key 1”.
> >
> > I am sure that I number of “Id:” not this duplicate in the table.
> >
> > It leaves the error and later it puts it in the table.
> >
> 
> Are you *really* sure? Because the example creates by default 1000 records in 
> the database, with ID from 0 to 999. The error message comes from the 
> database, and the database is rarely wrong!
>