Questions tagged as 'sqlite'

1
answer

Insert into two tables in SQLite Android

How do I add data in two tables on Android in a single transaction? I have two Client and Address tables, the latter with a foreign key referencing the client table, and it must be registered in a single transaction. I know that MySQL has the...
asked by 29.06.2014 / 08:08
2
answers

Recover Spinner position to use in another Spinner of another Acitivity

I have a note registration activity that has 1 spinner. In this Spinner contains card registration with IDCartão, title and description (Except in a "Card" table in the database). When you save this record from Notes in the "Notes" table, only t...
asked by 20.12.2018 / 01:07
1
answer

Django: Reverse for '' not found. '' is not a valid view function or pattern name

I'm trying to put a url based on my views.py but it returns me the error: Reverse for 'create_student' not found. 'create_student' is not a valid view function or pattern name. project urls.py: from django.contrib import admin...
asked by 20.08.2018 / 21:43
2
answers

error: "table sales has 6 columns but 5 values were supplied"

I created the following table in sql CREATE TABLE vendas ( ID INTEGER IDENTITY(1,1), Empresa VARCHAR (20), Modelo TEXT, Preco REAL, Kilometragem REAL, Ano INTEGER, PRIMARY KEY(ID) ); I p...
asked by 18.05.2018 / 04:41
1
answer

How to get the result of two tables in sqlite

What I want to get is the Currencies that belong to a particular country ' name.Pais, code.Currencies, name.Currencies, symbol.Currencies SELECT * FROM moedapais where alpha2Codes = 'AL'; SELECT * FROM Currencies where code =code.moe...
asked by 09.12.2017 / 15:45
2
answers

Error in SQLite class

What am I doing wrong in this SQLite class? I'm getting this error: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.sqllitetest/com.example.sqllitetest.MainActivity}: android.database.sqlite.SQLiteException: n...
asked by 09.07.2017 / 16:23
1
answer

Which type to use to store values that are in an ArrayList in an SQLite table?

I have the following table in SQLite: db.execSQL("create table amc(_id integer primary key autoincrement, nome text not null, contratada text not null, tipo text not null, data text not null, respostas integer not null, resultado float);");...
asked by 21.07.2017 / 19:35
1
answer

How to make a query in SQLite?

In my project the user must make a registration to enter, when putting the data name, email and password and when clicking on the register I would like to check if the email already exists, how to do it? I have a search method in a dao class,...
asked by 06.04.2017 / 20:41
2
answers

Authentication screen with SQLite

I have to perform the authentication of the user, but when I inform the user and the correct password it enters the menu screen, so far so good. The problem is that when I type a bad password or user, I want it to display a user not found messag...
asked by 17.05.2017 / 01:07
1
answer

Fill list of objects with SQLite data

I have an object of type Status contains the following attributes. idEstado (String), siglaState (String) And I have a table already populated in the database with the same attributes as above. But I would like to return all this data to a...
asked by 22.05.2017 / 14:23