Ask Your Question
0

Solved - I Cannot add records in a form

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

timstearns2 gravatar image

updated 2019-02-24 04:07:51 +0200

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
0

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

Ratslinger gravatar image

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

Hello,

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

Allowing:

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

Comments

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 45 times

Last updated: Feb 24