All Questions
6,503 questions
-2
votes
0
answers
48
views
How can I make my Ordering System efficient with the use of Java and SQLite? [closed]
I am new to coding, specifically java and SQL. How can I make my Ordering System efficient, I am currently getting the ID and setting the variables one by one. The problem I will have in the future ...
0
votes
1
answer
34
views
Error in connection between SQLite class and SQL Server class in Android Java
I have managed to create a local SQLite database to insert data, read it and update it. The problem is in a class where I do the communication test with SQL Server, there I can't pull the data from ...
-1
votes
1
answer
74
views
How to make a column in a table with a float value in SQLite?
I'm making a table in a database, and one of the columns needs to store a float number. However, I keep getting an error under the name of the float value when I ask my SQLiteDatabase to create the ...
0
votes
1
answer
41
views
Main size file database SQLite doesn't update, but -wal file does
I'm getting a problem by exporting a SQLite Database.
I'm reading the main file database (database.db) but always when I export it, the data is equal to the before file.
Strangly, the database-wal ...
0
votes
1
answer
34
views
How to reload the database after copying it from RAW folder?
I'm currently building an app with databases and I'm struggling to find a solution with, what I think is, a simple problem.
I'm initializing the databases with:
// First database, no problems
...
- 23
-3
votes
1
answer
68
views
Why is my code not pre-populating the database?
My app collects data for experiments. I am trying to pre-populate the database. I create directories for each experiment and store the database in each of those.
Folder storedData holds the database ...
- 29
1
vote
0
answers
63
views
Fetch SQLite database Table Orderby condition in android java
How to conditionally retrieve the data of any table in the SQLite database?
I want to extract condition wise data from a table in the database which I have not been able to successfully for the last 2 ...
- 371
0
votes
0
answers
260
views
Cannot run invalidation tracker. Is the db closed? Android Room ORM
I am using a Room database. I start the database in onCreate and close it in onDestroy. However, when I enter the activity for the second time, I encounter the following error.
As can be seen in the ...
0
votes
0
answers
30
views
Android RecyclerView not displaying data from SQLite database using custom Adapter
Problem Description:
I'm developing an Android app using Android Studio and Java. The app is designed to display worker information using a RecyclerView within a fragment (constructorsFragment). I've ...
0
votes
1
answer
120
views
SQlite for Android not working with json_group_array/json_object
Hey all I am trying to get this SQlite query to work in my Android app but for some reason its giving me the error of:
no such function: json_object (code 1): , while compiling
But it works in my DB ...
- 10.6k
0
votes
1
answer
60
views
I dont understand why my SQL table is not being created
Im trying to create a new SQLite table, and I followed the instructions to the latter, but I keep reciving the error
no such table: USERS_TABLE (code 1 SQLITE_ERROR)
As you can see, I created a ...
user22821467
1
vote
1
answer
124
views
How to load Android.database.sqlite table data into spinner? (Table has data but not loading)
I am using the following code to load sqlite database table information into a spinner. I am saving the data in the table through saving data activity and trying to getting the saved data in a spinner ...
- 371
0
votes
1
answer
79
views
Android database files not being created
The file for the database is not being created I've checked under data->data->->(where the database I expect to be). I can't tell if there is an issue with the code or the application itself. ...
- 3
-1
votes
1
answer
42
views
How can I get this to return the last lines in a SQLite db controlled by how many players played the game?
Im trying to get this code to return the scores and names of each player in an SQLite database depending on the amount of players in the game so if there's 4 return the last 4 rows and if there's 2 ...
- 11
1
vote
1
answer
48
views
I tried to create a dictionary but the search button doesn't work. I don't know where I went wrong
I'm making a dictionary. but the search was unsuccessful. Here I use a SQLite database. When I run the application no error notification appears. I don't understand where I went wrong. Other menus ...
- 29