How do I fix not null constraints error on flutter?

Question

I have an db which has two table: note and category. There is a schema below for my tables. I want to insert a record to the note table but I'm getting this error below. Can anyone please help?

Here is the method I create for insert a record to note table and the error which I'm getting from this process.

Emin Ayar · Accepted Answer · 2020-09-04 14:29:40Z

1

It clearly states that you declared your category_id as NOT NULL but you are passing a null value while trying to insert a note.

There may be 2 approach here,

You can simply remove NOT NULL constraint from your table definition by modifiying "category_id" INTEGER NOT NULL DEFAULT 1 to "category_id" INTEGER DEFAULT 1
You should really be sure that you are passing a non-null value to category_id in insert operation

As I see from your logs, it clearly says that one of the argument you are passing is null and it causes this crash.

Hope these helps you to detect your problem and fix it.

answered Sep 4, 2020 at 14:29

Emin Ayar

1,1069 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I fix not null constraints error on flutter?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related