Ask Your Question

Solved - I Cannot add records in a form

asked 2019-02-24 00:57:10 +0100

timstearns2 gravatar image

updated 2020-07-09 18:33:42 +0100

Alex Kemp gravatar image

I'm using Base 6.2 with the firebird embedded database. The table has a primary key CharID. The primary key is on the form. The error is validation error for column "Characters"."CharID", value " null *".

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-24 03:42:03 +0100

Ratslinger gravatar image

updated 2019-02-24 03:49:52 +0100


It appears you are attempting to enter a new record without any value in the primary key field:

image description

If the key is to be system generated, the table field need to be set to auto increment:

image description

Then the record will insert properly:

image description


image description

Optionally, you could always enter your own ID in the key field instead of an auto increment field. Of course it needs to be unique int the table.

edit flag offensive delete link more


This is the problem. I've tried to set the field to auto increment but no go. I apparrently cannot change the primary key field after table creation with firebird. I'll recreate in hsqldb and see if I can get this to work.

timstearns2 gravatar imagetimstearns2 ( 2019-02-24 04:07:26 +0100 )edit

@timstearns2 Actually adding it is relatively easy - delete the old field & add a new one with the correct setting. Just ran test of same without a problem - without data in table.

Ratslinger gravatar imageRatslinger ( 2019-02-24 04:33:32 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-24 00:57:10 +0100

Seen: 294 times

Last updated: Feb 24 '19