Questions tagged as 'sqlite'

2
answers

When I create two tables in SQLite Android, only one works [closed]

I'm trying to develop a test application that requires two tables ( aluno and disciplina ) in class DataHelper . I create two tables, but at the time of testing, only the Aluno table works. In summary: the application h...
asked by 21.02.2017 / 07:25
2
answers

Query between two sqlite tables

My question is how to query between two tables. It would be a Pedidos table with the Idprod , idCliente field. The other would be the Produtos table with the Idprod , Descricao fields. I wanted to...
asked by 17.03.2017 / 17:20
1
answer

How to compile the database to install together with a C # application?

I'm developing a C # application, and I need to know if I can build the database to install with the application, I've already seen something here about SQLite, but I do not know the tool and I do not know if it stores images, my case will have...
asked by 18.12.2015 / 06:25
1
answer

Calculate sql table in android

I have the following sqlite database and it works fine: db=openOrCreateDatabase("BaseDadosDB", Context.MODE_PRIVATE, null); db.execSQL("CREATE TABLE IF NOT EXISTS tabeladados(data date,total real,descricao VARCHAR);"); I want to return the...
asked by 12.01.2017 / 16:36
1
answer

Error while viewing or adding data in SQL

Good afternoon people, I was trying to make a sql to put the score obtained in a game I'm developing, but when I put it to save the score, or even see the score it gives error, I'll put an asterisk on the line where Android Studio points out the...
asked by 10.02.2017 / 16:10
0
answers

Mapping problems in Microsoft.EntityFrameworkCore

I'm trying to create two Mappings in ManyToOne using annotation of Entity Framework , however I'm not getting it, if I take either of the two mappings and leave the other, it works however if I leave both of the error. The project is being...
asked by 07.01.2017 / 10:34
0
answers

SQLite: unable to open database

Application using ionic / cordova (SQLite). I'm using the $ cordovaSQLite plugin inside the app. When I give a save, I modify something in the project, the simulation in the brownser (GoogleChrome) is extremely slow to load and when it loads...
asked by 09.12.2016 / 17:20
1
answer

Error in getWritableDatabase ()? [closed]

I'm doing a job for college. My project until a few minutes ago was working normally, inserting User and Book, but out of nowhere it started to give error in getWritableDatabase() and I have no idea what is causing it. BANK connection...
asked by 19.11.2016 / 06:19
0
answers

Saving an image on the bank

I want to get the imageview image saved in the database and make the last saved image come back when I open the app code to transform the image into a byte ByteArrayOutputStream saida = new ByteArrayOutputStream(); bitmap.compress(B...
asked by 16.10.2016 / 03:01
1
answer

Pass CSV content to an SQLite table

I have a CSV file with student records. I would like to upload these records to a aluno table in SQLite. How can I perform this operation?     
asked by 16.11.2016 / 21:37