Re: [users] setting primary key in Base

David Bowman wrote: I copied some tables from MS Access and tried to set the primary key and when saving get the following msg. SQL Status: 23000 Error code: -10 Attempt to insert null into a non-nullable column: column: LastName table: Student Information in statement [ALTER TABLE "Student I

Re: [users] setting primary key in Base

On Fri, 2008-04-18 at 09:53 -0700, David Bowman wrote: > I copied some tables from MS Access and tried to set the primary key and > when saving get the following msg. > > SQL Status: 23000 > > Error code: -10 > > > > Attempt to insert null into a non-nullable column: column: LastName > > table:

Re: [users] setting primary key in Base

There are no records in the table yet Craig White wrote: On Fri, 2008-04-18 at 09:53 -0700, David Bowman wrote: I copied some tables from MS Access and tried to set the primary key and when saving get the following msg. SQL Status: 23000 Error code: -10 Attempt to insert null into a n

[users] setting primary key in Base

I copied some tables from MS Access and tried to set the primary key and when saving get the following msg. SQL Status: 23000 Error code: -10 Attempt to insert null into a non-nullable column: column: LastName table: Student Information in statement [ALTER TABLE "Student Information" ALTER COL