1 (edited by reteinformatica 2019-03-19 19:37:55)

Topic: Error: NOT NULL constraint failed: A.id_B.

Hi everyone,
in a database I created two tables of which one is a dictionary. In the first, the one that is not a dictionary, I created the relationship with that dictionary. I associated a combobox to the relationship, when I go to save I get this error: NOT NULL constraint failed: A.id_B.
I can not understand. I enclose a mini project that explains the question. Thank you all

Re: Error: NOT NULL constraint failed: A.id_B.

Hi Again,
Can you attach the project example please.
Thanks,
Derek.

Re: Error: NOT NULL constraint failed: A.id_B.

Hello.


Attach your project.


Also you can see video lesson
https://www.youtube.com/watch?v=bG30pqCrw8k


Or book:
http://myvisualdatabase.com/forum/viewtopic.php?id=2694

Dmitry.

Re: Error: NOT NULL constraint failed: A.id_B.

Sorry I thought I had attached it. I just found out that the problem is with the latest free version but not with 5.2

Post's attachments

Attachment icon Prova.zip 322.6 kb, 289 downloads since 2019-03-19 

Re: Error: NOT NULL constraint failed: A.id_B.

When you have created Relationship A.id_B you have used option "Cascade delete", just recreate this relationship without this option.

Dmitry.

Re: Error: NOT NULL constraint failed: A.id_B.

Portrait, in the real project the problem also occurs with version 5.2
Look, the combobox is in the 'frmInserimentopc' form.
You can get there from the "Computer" tab by clicking on "Insert" in the attached project.

Post's attachments

Attachment icon Progetto.zip 328.13 kb, 291 downloads since 2019-03-19 

Re: Error: NOT NULL constraint failed: A.id_B.

Excuse me so much, I had forgotten to put the combobox in the save button configuration.
I take this opportunity to ask if it is possible to upload more than one file for the same person referring to the phone book example.

Re: Error: NOT NULL constraint failed: A.id_B.

reteinformatica wrote:

Excuse me so much, I had forgotten to put the combobox in the save button configuration.
I take this opportunity to ask if it is possible to upload more than one file for the same person referring to the phone book example.

Example:
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.