Loading

values (Id,RAI_id)can be inserting null

values (Id,RAI_id)can be inserting null

Mahesh Reddy

7y677Learn iOS Programming

I have 4 tables

Orders table with fields OrderId, OrderName,OrderDate,Description

Items table with fields Id,OrderId and Name

subitem2 table with fields aid,RAI_Id and text

subitem4 table with fields aid,RAI_Id and text

Orders can be updated succesfully if done any modifications

Right now my problem is that In Items Orderid can be dispaying null

in the same way in subitem2 and subitem4 RAI_Id is displaying null

Could you please help me

Look at my scrrenshots how data can be saved to database

Name can be saved to database

in the same way text also can be saved to database

Problem is that RAI-id and orderid can be inserting null

https://ibb.co/qY4DKRZ

https://ibb.co/9njQ75S

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreekanth Reddy7y ago
Accepted answer
var oldtaxes = db.subitem4.Where(x => x.RAI_Id == detail.Id && x.text == taxes.text).FirstOrDefault();

Here compare with only x=>x.RAI_ID

Try it once.

Thank you.
Sreekanth Reddy7y ago
Please place debugger at the followwing place :

foreach (subitem4 taxes in detail.subitem4)
{

And check Rai_ID value are getting null or any other ?
Mahesh Reddy7y ago
New order can be added to database properly
Problem is that
Update only
In that Orders table values can be updating properly
Problem is that only at Item,subitem2
In Item(Name) is inserting properly but for that row orderid =0
is was showing
Sreekanth Reddy7y ago
Hi Mahesh,

Firstly you needs to add NOT NULL constraint to your columns "orderid" ad "RAI-id".
As currently you are having null values, You cant add NOT NULL constraint directly.
So, First update your null values to some value(Ex : 1) as like below :
STEP : 1
-- Why I'm saying 0 ?
-- Means you can have any value but make sure that value to be matched to other not null values.
UPDATE Items SET [orderid]=0 WHERE [orderid] IS NULL
STEP : 2
-- Now add the "NOT NULL" Constraint to that column as like below :
ALTER TABLE Items ALTER COLUMN [orderid] INTEGER NOT NULL
In the same way apply for subitem2 & subitem4. So that, you are not allowed to provide null values.
If it helps mark as answer.
Thank you.