We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

Base+Firebird: Why can't created table be appended manually?

asked 2020-12-05 05:58:31 +0200

lonk gravatar image

LibreOffice Base 7.0.3.1 + Embeded Firebird

CREATE TABLE "studentsa" (
"student_id" INT,
"first_name" VARCHAR(255),
"last_name" VARCHAR(255),
"subject" VARCHAR(255),
"marks" INT
);

image description

Why can't table studentsa be appended manually ?

CREATE TABLE "studentsb" (
"student_id" INT NOT NULL PRIMARY KEY,
"first_name" VARCHAR(255),
"last_name" VARCHAR(255),
"subject" VARCHAR(255),
"marks" INT
);

image description

But table studentsb can be inserted manually.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-12-05 18:00:33 +0200

Ratslinger gravatar image

updated 2020-12-05 19:29:31 +0200

Hello,

This situation is not unique to Firebird. The problem with studentsa is the lack of a primary key assigned. It is essential in doing anything with data in a table.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-05 05:58:31 +0200

Seen: 35 times

Last updated: Dec 05 '20