Questions tagged as 'sqlite'

Tagged questions
1
answer

JSON or SQLite?

I'm developing a simple app in PhoneGap and I'm going to need to basically have 2 tables. One to store the names of the series and another to store the exercises of each specific series. But I'm not sure how JSON and SQLite...
asked by 07.06.2014 / 04:15
1
answer

Android - What is the difference between getReadableDatabase () and getWritableDatabase ()?

I was able to enter information into the database by using the getReadableDatabase() method. Should not that be a mistake then? Should not be the getWritableDatabase() method? private void savePet() { petDbHelper = new P...
asked by 24.02.2018 / 20:43
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

Format date in Android and SQLite

I am having difficulty setting the current date of my SQLite database in the% type attribute of my object. The SQLite date comes in the format "yyyy-MM-dd". I'm trying to convert to the format accepted in type java.util.Date and that a...
asked by 15.11.2015 / 06:27
2
answers

How to hide column of DataGridView?

I have the void PopulaGrid(DataGridView grid, SQLiteDataReader dados) function that feeds my dataGridViewAlunos data, I would like to know how to hide the first column of dataGridViewAlunos which is the column correspondin...
asked by 13.12.2015 / 02:23
1
answer

How do I save read-only data? Should I use SQLite in this case?

I'm developing an application (a widget actually) that shows some phrases in the user's home . I have about 1000 phrases of approximately 150 characters , how will I store it? In that case is DB worthwhile?     
asked by 20.02.2015 / 19:39
2
answers

Error performing insert in an Android application: "Empty bindArgs"

Explanation: I have an android application that was made using ADT (Android Developer Tools) I use the bank sqlite in it and eventually I perform some operations as insert or update and also some select 's. Pr...
asked by 18.02.2014 / 00:23
2
answers

How to do a table search with SQLite?

Well, how do I make a select in a table using SQLite on Android? So far I have the table created and the insert. For example: search for the user's login and password, to be able to compare. Follow the code: BankData: public class Ban...
asked by 05.11.2017 / 00:21
2
answers

I can not enter user-defined values in SQLite

I have a problem where I can not add anything to the table and the error always appears:    sqlite3.InterfaceError: Error binding parameter 0 - probably   unsupported type. The code I'm trying to add values to and this: p_name=input("...
asked by 30.01.2016 / 14:58
2
answers

Error saving data from an sqlite registry

I'm having trouble saving data from a people record in sqlite JavaNullPointerException: invalid int: (51) 3452-2470. This error started to occur after I applied a mask. Here are the codes below. import android.text.Editable; import android.tex...
asked by 28.12.2015 / 06:19