# How do i delete specific row in local database?

**URL:** <https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [March 18, 2022, 1:29pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499 "2022-03-18T13:29:25Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![ray-anyk](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@ray-anyk](https://community.thunkable.com/u/ray-anyk)\
**Post date:** [March 18, 2022, 1:29pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/1 "2022-03-18T13:29:25Z")

</div>

Hello. I want to know how to delete specific row (/record) off my database. My teacher is a lazy \*\*\* who just makes me do stuff without explaining anything to me. As part of my task i need to delete one row. But i can’t really figure out how the whole rowid thing works. So appreciate some help.  
Also. I did look at previous results. But every result i found was outdated. I appreciate some help with this.

---

<div class="post-metadata">

**Author:** ![ray-anyk](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@ray-anyk](https://community.thunkable.com/u/ray-anyk)\
**Post date:** [March 18, 2022, 1:30pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/2 "2022-03-18T13:30:36Z")

</div>

I used the local database for this. It’s part of my task so i can’t use something else.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [March 18, 2022, 1:46pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/3 "2022-03-18T13:46:30Z")

</div>

Have you considered this

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/c/5cbc6d0e908a6388f5e09b4b2fb4cf2f0b17f728.png)

You will need to supply the `row id` which is as simple as a sequence number, so to delete the first row enter **1** as the `row id`.

---

<div class="post-metadata">

**Author:** ![ray-anyk](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@ray-anyk](https://community.thunkable.com/u/ray-anyk)\
**Post date:** [March 18, 2022, 1:54pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/4 "2022-03-18T13:54:39Z")

</div>

I tried this. But it seems not be working.

![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/0/70104ae57e3d3b0c73bcc038c15467ad02a43809.png)

Is there an issue with how i did it?

---

<div class="post-metadata">

**Author:** ![ray-anyk](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@ray-anyk](https://community.thunkable.com/u/ray-anyk)\
**Post date:** [March 18, 2022, 1:57pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/5 "2022-03-18T13:57:25Z")

</div>

A Reply to this

---

<div class="post-metadata">

**Author:** ![shrey](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/shrey/32/105637_2.png) [@shrey](https://community.thunkable.com/u/shrey)\
**Post date:** [March 18, 2022, 3:09pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/6 "2022-03-18T15:09:39Z")

</div>

Hi ray, try putting this block instead of directly putting it in the text block.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/88affd4c4d2699d87373d5f1efce8b6c8efa308f.png)

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [March 18, 2022, 8:33pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/7 "2022-03-18T20:33:17Z")

</div>

> [@ray-anyk](#):
>
> it seems not be working.

How do you know that it is not working?  
Please explain how you are verifying that the row has not been deleted.

---

<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:** [March 19, 2022, 3:22pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/8 "2022-03-19T15:22:03Z")

</div>

Can you share the project link?

---

<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:** [June 17, 2022, 3:22pm UTC](https://community.thunkable.com/t/how-do-i-delete-specific-row-in-local-database/1790499/9 "2022-06-17T15:22:45Z")

</div>

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