799 questions
0
votes
0
answers
24
views
SQLite ALTER TABLE RENAME COLUMN not working on Android 10 device using SQLiteOpenHelper [duplicate]
I am trying to rename a column in an SQLite database (SQLiteOpenHelper) in my Android app. The code I am using is:
db.execSQL(
"ALTER TABLE $MY_TABLE_NAME RENAME COLUMN $OLD_COLUMN TO $...
1
vote
0
answers
210
views
How to resolve getWritableDatabase() SELinux audit error: denied { ioctl }? (Android 14)
I encountered an issue where getWritableDatabase() from SQLiteOpenHelper in my Android app throws an SELinux audit error. It still works but in logcat I can see that error. The specific log entry ...
0
votes
1
answer
40
views
how to insert data from edit text to sqlite db in android application
I am currently working on an android application where i have to register new users into sqlite db and users enter their details into editText and we need to fectch entered data and store it in db
the ...
0
votes
2
answers
60
views
Random values are not getting inserted in SQLite Table
I have made a database in SQLite, and a Table. Schema is like this:
CREATE TABLE Students (
StudentID INTEGER PRIMARY KEY,
FirstName TEXT NOT NULL,
LastName TEXT NOT NULL,
Gender TEXT ...
0
votes
1
answer
61
views
Clubbing multiple sqlite statements in a single query
I have a following table:
folderId
folderPath
1
"C:\Users\obama"
2
"C:\Users\biden"
Here, folderId is an autoincrement key.
Now, insertion into the table has following steps:
a)...
- 29
-1
votes
1
answer
31
views
Kotlin SQLiteOpenHelper failing to insert data into table
class SQLiteHelper(context: Context?) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION){
companion object{
private const val DATABASE_VERSION = 1
private const val ...
- 11
-1
votes
1
answer
233
views
facing issue in login and registration in android studio using SQLite + kotlin
I try to login. after registration had done.
When I try to login it shows invalid password and username.
But, I mention the correct password and username
github file
package com.example.app
import ...
0
votes
1
answer
311
views
Flutter app size increased due to too many audios
I am working on a Flutter application and I have more than 100 sounds that users can play for educational purposes.
I am not using any server or Firebase. Every audio is almost 1 MB. With that assets ...
- 816
0
votes
0
answers
84
views
After calling update function in SQLite db, the data is not updated and returns 0 value
I'm trying to create a function which will update the password in the database. The function itself returns true value, however the data is not updated and remains the same. Also I changed the result ...
- 1
-1
votes
1
answer
363
views
Data Registration to database and validation from database Sqlite won't work
I've got this Sqlite database named DatabaseHelper and i need to register the data (username, pass, email, and phone) i need to check if username already exists when button register pushed and check ...
- 17
-1
votes
1
answer
94
views
How can I view the details of the user who is currently logged in
Am developing an android application in java android studio. I need to collect the details of the user who is currently logged in. I don't seem to find any help online. I have tried using the code ...
- 1
0
votes
1
answer
305
views
Android Studio SQLITE Database is read only if I add drop database function in sqlhelper class
adding drop database function in my dbhelper class gives me error of database read only , I might try deleting the required tables but I would like to know what I am doing wrong here, I tried removing ...
0
votes
1
answer
250
views
Android: How can I search data in sqlite database
I making project that user can scanning a barcode. My problem is, if the scanning results are the same as the kode_obat column, then the nama_obat, and harga_jual columns will be displayed or setText ...
- 3
0
votes
0
answers
1k
views
Why android can't open sqlite db from external storage on android 30 upwards
I'm updating the target sdk version on an android app and in the process, I picked up the sqlite db importer is broken. Previously on android version >= 29, the importer worked fine.
So Basically, ...
- 11
1
vote
0
answers
356
views
How do I insert initial data in a SQLite database table?
I'm currently trying to create an Flashcard application, in which the user can either create his own cards/notes or use pre-defined cards. The idea is to have around 500 to 1000 cards to be inserted ...
- 11