Questions tagged as 'sqlite'

1
answer

How to know which is the last item selected from a listView?

Hello, I have a ListView using simple_list_item_multiple_choice , filled with ArrayString of all Brazilian states. I need to fill in the following SQL command with all the states selected by the user through the ufSelected...
asked by 18.05.2018 / 20:40
1
answer

Android - How do I create and combine two tables within a list of SQLite tables on Android?

I'm creating an application to monitor the aquarium settings using the following scheme: The user can monitor as many tanks as he wants, but every time he adds a new aquarium, these two tables should be created and always linked. And...
asked by 03.05.2018 / 11:05
0
answers

Error in single query in Sqlite bank using content provider

I'm having a problem that when trying to query the database of my application through the Content Provider. When I start the database query the application crashes. I did tests using any integer as id for the query, The application works normall...
asked by 18.04.2018 / 17:35
0
answers

Difficulty in listing SQLite result in ListView Android

I'm creating an application to train mobile development, I'm doing for Android in Visual Studio, using Xamarin. I'm having trouble listing an SQLite result. I created two activities, one to do the registration and already list, and the other...
asked by 08.02.2018 / 22:23
1
answer

Error connecting to sqlite in laravel

Internally everyone is working, migrations , tinker , sqlite3 , but in the server application it always queries mysql instead of sqlite for all operations, ie it is using Connector.php instead of% with%...
asked by 01.03.2018 / 00:58
0
answers

Different results of the same application with SQLite [closed]

The attached screens are the result of the same query on a tablet with Android 4.1.2 and a Galaxy S3 with Android 4.3 (which has Brazil only once, which is correct) and another with Moto X2 with Android 6.0 (with the data from Brazil divided) in...
asked by 02.02.2018 / 19:36
1
answer

Ruby on Rails SQLite3 :: BusyException: database is locked: INSERT INTO

Hello, I'm facing a problem with SQLite3. When I run the code: user = SystemUser.new(email: "[email protected]", password: "marcos123") user.profile = Profile.new(first_name: "Marcos") user.save Rails runs in SQLite: (0.1ms) begin trans...
asked by 13.11.2017 / 00:33
1
answer

Error executing delete on Sqlite bank

I have a problem with my Android project. When I run a delete on the sqlite database, I get the following log message as a return: W/FileUtils: Failed to chmod(/storage/sdcard/Cardapio Digital/Database/dbcardapio.sqlite):...
asked by 01.11.2017 / 15:42
1
answer

Error while changing table SQLITE - no such column

Include a new column in a table. I reinstalled the application and at the time of saving the data there is a message saying that there is no path picture column, in my case, in the clients table. I read some things about it and was advised to in...
asked by 26.01.2016 / 03:57
0
answers

Error creating sqlite database from installed apk

I used a populated .sqlite database in a project. I imported the bd into the assets folder and implemented the code for creating and accessing the database. I ran the project and everything worked ok in the emulator and on the phone directly. Th...
asked by 20.09.2017 / 08:15