SQL Record deletion

B

BrutalSnyper

Member
Licensed User
Longtime User
Hi there,

In my app, I have a part that deletes a record in my SQL database, but it also deletes records with the same value.

Example:

Names
Sam
John
Sam
Neil

If I delete one of the records containing the value "Neil", both of the records containing the value Neil are deleted.

How could I stop this from happening?
I thought about having a second field in my table and giving each field an ID, but this would cause bigger problems later.
 
Sort by date Sort by votes

klaus

Expert
Licensed User
Longtime User
What are the other fields ?
How do you select the record to delete ?
I thought about having a second field in my table and giving each field an ID,
Click to expand...
Thats the best way.
but this would cause bigger problems later.
Click to expand...
What problem ?

Best regards.
 
Upvote 0
B

BrutalSnyper

Member
Licensed User
Longtime User
klaus said:
What problem ?
Click to expand...

The problem I see appearing is that say I have 4 records in my database, each with an ID from 1-4:

1. This
2. Is
3. My
4. Example

And I delete record 3, then the records will be 1,2,4 which will cause me more trouble if I decide to do something such as restrict the amount of records that can be entered.
 
Upvote 0

klaus

Expert
Licensed User
Longtime User
The advantage of the ID is that it's UNIQUE !
In SQLite you can get the number of records.
In my DB applications when I read a database and show it in a table I define in parralel a List with the ID indexes to have a relationship between the rows and the IDs. This is valid for the whole database and also if it's filtered.

Best regards.
 
Upvote 0

ValDog

Active Member
Licensed User
Longtime User
So, once I initialize a database table how do I go about getting the number of records in the table?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Example [B4X] PocketBase - Deleting files
Replies
0
Views
1K
Alexander Stolte
P
  • Question
Android Question Deleted SQL records are not Actually Deleted
Replies
12
Views
2K
Pelky
P
  • Article
Android Code Snippet [B4X] SQL - setting the journal mode
Replies
0
Views
3K
Erel
  • Article
Android Code Snippet [B4X] B4XTable - Delete Row
Replies
2
Views
9K
Erel
  • Article
Share My Creation Record Call
Replies
6
Views
6K
MarcoRome
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…