Questions tagged as 'sqlite'

Tagged questions
1
answer

Java Android How to assemble a random database?

In the Android application, using Java, I get a string in Json that looks like this: String teste = "{\n" + " \"nometabela\":{\n" + " \"id\":\"f83d6101cc\",\n" + " \"coluna1\":\"codigo\",\n" + " \"coluna2\":\"descricao\",\"coluna...
asked by 23.11.2018 / 12:03
1
answer

Attempt to invoke virtual method on a null object reference [closed]

Error: 09-12 17:13:09.088 26022-26022/costamilam.guilherme.contatosempresariais E/AndroidRuntime: FATAL EXCEPTION: main Process: costamilam.guilherme.contatosempresariais, PID: 26022 java.lang.NullPointerException: Attempt to invoke vir...
asked by 12.09.2017 / 22:26
1
answer

Delete database information

public void excluir (int codigo){ String[] parametros = new String[1]; parametros[0] = String.valueOf(codigo); conexao.delete("CLIENTE", "CODIGO = ? ", parametros);} This is the method to delete a data from my table This is th...
asked by 02.04.2018 / 03:47
1
answer

Selecting gaps in database

I am trying to mount a select that finds missing items in a database. This is super unusual, 'select' items that do not exist. rsrs Let's say I have a table called TBL795 with the NRBEM column that should, in theory, not have gaps in the sequenc...
asked by 27.12.2016 / 16:39
1
answer

Advantages and disadvantages of SQLite [closed]

   SQLite is a powerful API for working with structured data, but it requires a lot of effort from the programmer to use it. According to Developer (2018), the programmer faces the famous "boilerplate code", that is, the programmer must implemen...
asked by 14.10.2018 / 04:11
1
answer

How to insert data (cadastre) in SQLite?

Hello, my connection to SQLite is as follows: Connection connection = null; try { // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:database.db"); S...
asked by 30.05.2018 / 05:36
1
answer

SQlite database in android project [closed]

Good afternoon, I'm having a doubt, I'm doing a project in Android Stúdio and my application has a notepad idea, and I was wondering if I can show the annotations when I start the page, for example: the user clicks on the " + "there opens a wind...
asked by 05.07.2016 / 22:20
1
answer

SQLite DUVIDA BASIC A

I'm learning sqlite and I learned how to do crud, having doubts if when I finish doing the apk and put it on the phone it will create the bank file alone and it will create and search or I have to manually create the file ?     
asked by 26.05.2018 / 19:17
1
answer

CRUD: List Method

Good evening, I'm learning about CRUD in my mobile programming course, we're programming in a SQLite database, as the project is not yet ready for the teacher's own reasons, to check if the Database works, we're putting the data in the first scr...
asked by 17.09.2018 / 06:06
1
answer

DBSQLite Android Studio Problem

Good afternoon, I am having syntax problem in my SQLite code in Android Studio. Could someone help me? package studio.com.projetofinal; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDat...
asked by 24.06.2018 / 18:46