Cannot Insert the value Null into column "Attachment"

Edit Subject

Dear All,

I want to attach some files as details grid of parent grid without using blob adapter settings, files should be stored as binary format in database.

while attaching I am getting a error like this, "Cannot Insert the value Null into column "Attachment"

Herewith, I am attaching my all working screen-shot.

Please suggest me what need to be change for fix this issue.

Here I have composite key for details grid.

Regards,

Dhirendra Kumar Nayak.

1 person has
this question +1

0

Edit

Delete

Remove

Official

Fork

John Willems July 30, 2019 15:05

Have you tried 'Allow Null Values' below the Byte[] array data type?

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

Have you tried 'Allow Null Values' below the Byte[] array data type?

How does this make you feel? Add Image

I'm
e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited
Cancel
0

Edit

Delete

Remove

Official

Fork

Dhirendra Kumar Nayak July 30, 2019 15:39

Hi john,

Yes I have tried with allowing null in database side too.

If I make as null, record is saving without varbinary data field data.

It's working perfectly if table is only one primary key and attachment coloumn is allow null in DB.

If a table is having composite key it's not working, my concern is how to save the attachment file, if a table is having composite key.

Please suggest me how to make this workable if a table is having composite key.

Thank you.

Regards,

Dhirendra Kumar Nayak.

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

Hi john, Yes I have tried with allowing null in database side too. If I make as null, record is saving without varbinary data field data. It's working perfectly if table is only one primary key and attachment coloumn is allow null in DB. If a table is having composite key it's not working, my concern is how to save the attachment file, if a table is having composite key. Please suggest me how to make this workable if a table is having composite key. Thank you. Regards, Dhirendra Kumar Nayak.

How does this make you feel? Add Image

I'm
e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited
Cancel
0

Edit

Delete

Remove

Official

Fork

John Willems July 30, 2019 15:47

I do not use composite keys so I cannot help with that. My blob uploads are done using the adapter settings.

I would guess you are in the realm of custom code. Perhaps someone else here codes out the upload process and can be of assistance.

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

I do not use composite keys so I cannot help with that. My blob uploads are done using the adapter settings. I would guess you are in the realm of custom code. Perhaps someone else here codes out the upload process and can be of assistance.

How does this make you feel? Add Image

I'm
e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited
Cancel

Reply to This Topic (some HTML allowed)
What's the status of this question?

How does this make you feel? Add Image

I'm
e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited

About this Question

Products & Services

Tagged

Cannot Insert the value Null into column "Attachment"

Edit Subject

About this Question

Products & Services

Tagged

Cannot Insert the value Null into column "Attachment" Edit Subject

Cannot Insert the value Null into column "Attachment"

Edit Subject