Choose only NOT NULL strings in SQLite

Question

I want to choose only NON NULL String from String[] groupFrom = new String[]{Database.DATABASE_GROUP_1};

to pass to the adpater:

  SimpleCursorTreeAdapter simplecursortreeAdapter = new ExpandableListViewAdapter(
                this,
                cursor,
                R.layout.list_group,
                groupFrom,
                groupTo,
                R.layout.list_child,
                childFrom,
                childTo
        );

Possible duplicate of Android SQLite query where column is not null and not empty — Michael Dodd
– Michael Dodd, Commented Jul 30, 2018 at 12:56
It is not .i've tried what was suggested but it doesnt work for me, i have different design , i have edited the text so you can see my design structure . do you think i can apply what was suggested in the link for me? and how with code please — Errahbi Zouhair
– Errahbi Zouhair, Commented Jul 30, 2018 at 13:03
i m new to android so i have based on this to create what i want which is expendable listview with prepopulated Sqlite database : github.com/JorgeAmVF/android-prepopulated-sqlite-database/blob/… My design structure is exactly like this — Errahbi Zouhair
– Errahbi Zouhair, Commented Jul 30, 2018 at 13:09

Jonah Mann · Accepted Answer · 2018-07-30 12:56:17Z

0

Loop through with something similar to:

if (groupform[i] != null)
// Do stuff

I'm adapting this from here:

How can I check whether an array is null / empty?

answered Jul 30, 2018 at 12:56

Jonah Mann

255 bronze badges

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

2 Comments

Michael Dodd Over a year ago

This is pretty inefficient when those rows can be excluded as part of the initial query

Errahbi Zouhair Over a year ago

Could you give me a code to execute , i m new to android. i dont have experience in this

Collectives™ on Stack Overflow

Choose only NOT NULL strings in SQLite

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related