How to avoid storing null values in sqlite using android

Question

If i click a add button the values has to be stored in sqLite database. My problem is it stored the null values also how to avoid that one? help me friends

//creating database and table

    public class Database extends SQLiteOpenHelper {
            static int dbversion=1;
            static String dbname="expense.db";

            public Database(Context context)
                     {
                super(context, dbname, null, dbversion);
                // TODO Auto-generated constructor stub
            }

            @Override
            public void onCreate(SQLiteDatabase db) {
                db.execSQL("create table addsource(source text)");


//inserting values in database

    add.setOnClickListener(new OnClickListener() {

                    @Override
                    public void onClick(View v) {
                        // TODO Auto-generated method stub

                        Database db=new Database(Sett.this);
                        SQLiteDatabase sb=db.getReadableDatabase(); 

                        sb.execSQL("insert into addsource(source)values('"+sources.getText()+"')");
                        Toast.makeText(getApplicationContext(), "Registered Successfully",Toast.LENGTH_SHORT).show();

                    }
                });

            }

This code never inserts a NULL value. It might insert an empty string. Is it that that you want to avoid? — CL.
– CL., Commented Aug 9, 2014 at 9:47
And what should happen when sources contains an empty string? — CL.
– CL., Commented Aug 10, 2014 at 7:28

FR073N · Accepted Answer · 2014-08-09 09:52:13Z

0

Why don't you test the value ?

if(sources != null){
    sb.execSQL("insert into addsource(source)values('"+sources.getText()+"')");
}
else{ 
    //insert what you want
}

Moreover, I don't think that you can insert null value, you might insert only an empty string with :

sources.getText()

So, instead of sources != null you can test sources.getText().length > 0 and insert what you want in case this is true.

answered Aug 9, 2014 at 9:52

FR073N

2,0914 gold badges30 silver badges42 bronze badges

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

1 Comment

Aravind Over a year ago

Thanks for the response it still have the same problem

Community · Accepted Answer · 2017-05-23 10:33:32Z

0

you can check values before inserting into database.Put values to strings and check the strings are not null on click of add button and then insert into table.

you can also use 'not null' in table creation

Creating table in sqlite android

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 9, 2014 at 10:02

Sar

5605 silver badges18 bronze badges

1 Comment

Aravind Over a year ago

Thanks for the response it still have the same problem

Peyman.H · Accepted Answer · 2014-08-10 18:45:45Z

0

You have 3 ways:

1- add NOT NULL in create table :

CREATE TABLE your_table ( column_name INT NOT NULL, ....)

2- select the values that aren't null while using SELECT :

SELECT column_name FROM your_table WHERE column_name IS NOT NULL

3- check the variable value to see whether it is null or not:

if ( String.ValueOf(source) != null){   // for string example
      // add the source to the database
}

answered Aug 10, 2014 at 18:45

Peyman.H

1,9521 gold badge17 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to avoid storing null values in sqlite using android

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related