Questions tagged as 'sqlite'

Tagged questions
3
answers

I do not get 2 decimals in the jTextField to pass it to a DB!

I'm going crazy and I do not know what to do, to see if someone can help me. I would like that in the jTextField9 I would only get 2 decimals ( 123.45 ), because like this I get many decimals (123.45322222). because then I want the result w...
asked by 24.05.2018 / 15:20
1
answer

Obtain values of a query prepared in sqlite

Trying to run the program generates the following error:    Query.val: 41.24-41.34: error: The name 'name' does not exist in the context of 'Sqlite.Statement?' The line where the error is generated is at the moment of obtaining the values...
asked by 26.02.2018 / 00:57
1
answer

Error trying to connect Yii2 with SQLite

I am trying to connect my application in Yii2 with a SQLite database but every time I try to access my application I get the following error: The configuration for the "db" component must contain a "class" element. This is how I have my datab...
asked by 24.02.2018 / 05:15
1
answer

SQLite get data from a table

Hello friends I am new working with SQLite and I have a question, I finally managed to make my table and even put data (wow), but what I would like to know is if someone knows how to confirm whether the table is empty or not? and if it is, you k...
asked by 16.02.2018 / 22:03
1
answer

Error sqlite FMDB in swift - Unknown error calling sqlite3_step (5: database is locked)

I have the following code: func downloadImagen() { print("Download Imagen") getOrders() { result, error in if error != nil { print("ERROR: \(error!)") } else { let imagenFondoBbDd: String...
asked by 25.01.2018 / 10:00
3
answers

Java, I have a problem creating a new instance of a class

Good first I have this class User package com.example.leaftime.rocketdefender; /** * Created by Leaftime on 04/11/2017. */ public class User { private Integer id; private String name; private Integer score; public User(Int...
asked by 06.11.2017 / 07:41
1
answer

Call database with (this) in fragment

I am trying to make a catalog by linking to a database that is in the folder assets, so that it is displayed in a recycleview. This activity already works on its own but now that I want to embed it in a fragment I can not (I'm new to this). Does...
asked by 17.10.2017 / 06:56
1
answer

Null value in database call (SQLite)

I'm doing an app that requires a database where when looking up / searching for a number in the first column of the database, the data that is in the second column corresponds to that data. The problem is that when I enter the number it retur...
asked by 24.10.2017 / 02:13
2
answers

Problem with update to SQLite database from Android

Good morning. I have a problem updating data in a SQLITE database. I put the necessary code: Variables: public static final String TABLE_INVENTARIO_NAME = "inventario"; public static final String INV_NOMBRE="inv_nombre"; public static final...
asked by 01.09.2017 / 17:48
1
answer

Query InnerJoin Xamarin Android with Sqlite net pcl

I have a query in sqlite where I do several inner join var query1 = db.Query<Color>("select ar.Estilo, co.Nombre as Color, ac.Nombre as Acabado, ma.Nombre as Marca,te.Nombre as Otoño, su.Nombre as SubLinea from Articulo as ar inner...
asked by 16.08.2017 / 00:24