# Help with local DB Blank Row

**URL:** https://community.thunkable.com/t/help-with-local-db-blank-row/2672051
**Category:** Questions about Thunkable X
**Tags:** beginner, help
**Created:** [October 30, 2023, 4:31pm UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051 "2023-10-30T16:31:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![casey.vigus3](https://avatars.discourse-cdn.com/v4/letter/c/4af34b/32.png) [@casey.vigus3](https://community.thunkable.com/u/casey.vigus3)
#### Post date: [October 30, 2023, 4:31pm UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/1 "2023-10-30T16:31:50Z")

</div>

I am randomly pulling data from a local db, but local db always has a blank row, so sometime when i get random row i get that blank row, is there a way to exclude that blank row from being selected?

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 30, 2023, 9:04pm UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/2 "2023-10-30T21:04:40Z")

</div>

Why does it have a blank row? Can you just remove the blank row?

---

<div class="post-metadata">

### Author: ![casey.vigus3](https://avatars.discourse-cdn.com/v4/letter/c/4af34b/32.png) [@casey.vigus3](https://community.thunkable.com/u/casey.vigus3)
#### Post date: [October 30, 2023, 9:19pm UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/3 "2023-10-30T21:19:42Z")

</div>

![empty row](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/c/6c189ce77794c547ef78a875c65c98c95a468293.png)  
Local db always has this empty row for typing more data in, but when i have something pull randomly from the db it will sometime pull this empty row and return Null.

trying to figure out a way if it pulls this empty row it just does the randomization again or similar solution.

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [October 31, 2023, 12:03am UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/4 "2023-10-31T00:03:19Z")

</div>

Right click on the last row and choose delete row. It’s there by default but that doesn’t mean you have to keep it in your data source. By the way, when you delete it, it will still look like it’s there. I believe that’s a display bug but it _does_ delete the row.

---

<div class="post-metadata">

### Author: ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)
#### Post date: [November 1, 2023, 11:33am UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/6 "2023-11-01T11:33:49Z")

</div>

You can do this

```auto
maxrow = LentghOf(LocalDB_Table1(get_all_rows)))-1

rowID = random(maxrow)
row= LocalDB_Table1_get(rowid=rowID)

```

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [January 30, 2024, 11:34am UTC](https://community.thunkable.com/t/help-with-local-db-blank-row/2672051/7 "2024-01-30T11:34:23Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.