Questions tagged as 'sqlite'

Tagged questions
1
answer

How to save and retrieve a date field in SQLite3?

The issue is that in the SQLite site itself says that for date fields is to use numeric type or string , fine with numeric I write in the database the date without special characters, however in the string , is there any way to make a sele...
asked by 14.01.2016 / 18:04
1
answer

SQLite native functions X SugarRecord

What are the advantages and disadvantages of using SugarRecord when compared to native functions SQLite , Example on creating a table with SQLite Native Functions DatabaseHelper.java public class DatabaseHelper extends SQLite...
asked by 26.11.2015 / 17:06
2
answers

Add all records prior to a specific date - SQLite

I want to add multiple row values from my table (add up expense values) earlier than a specific date (for example, add all values that are smaller than the 2015-26-06 date). I am using the following code, but it is not functional. SELECT SUM (...
asked by 26.06.2015 / 16:38
1
answer

How to use SCOPE_IDENTITY in sqlite

I have a mobile application that inserts a database in the DB and needs to return the ID of this register, but I do not know how to use it and I do not know if SCOPE_IDENTITY works in sqlite, my code looks like this: var idSolicitacao = tx.exe...
asked by 08.06.2015 / 15:03
1
answer

Check if you have Data in SQLite table

How to check if an Android SQLite table contains data?     
asked by 13.09.2014 / 01:23
1
answer

How to delete a record without affecting the query?

I have two PRODUCT tables and CUSTOMERS. I am using inner join to link them in my queries. I call the product and it displays the product, takes the customer from the CLIENTS table and displays it together in the query. After deleting th...
asked by 20.11.2014 / 03:19
1
answer

Use Core Data or another API to interact with sqlite?

I was researching on how to save data on iPhone and iPads and came across many options, each with its complexity and purpose. Apple recommends that whatever app, which uses Core Data, is nothing more than a layer to interact with a SQLite databa...
asked by 30.07.2014 / 22:01
1
answer

Error - no such column

03-21 07:25:47.740: E/SQLiteLog(796): (1) no such column: name1 03-21 07:25:47.750: E/data(796): Error while searching contacts: android.database.sqlite.SQLiteException: no such column: name1 (code 1): while compiling: SELECT _id, name1, name...
asked by 21.03.2014 / 17:42
1
answer

PROBLEM WITH SQLITE - View with multiple selects

I have three tables that I have to take a die in each to make an algorithm in the app, but I would like to know if I have a view that brings me the three data that are in the tables. I would like to know if I have to do this because none of the...
asked by 17.04.2014 / 14:27
1
answer

Ruby on rails does not write to the database

Good evening, guys! I created a small form with two fields and in the future I intend to expand this form with one or two fields. It happens that the insertion of the data in sqlite is not being done, but it does not give any error. The ap...
asked by 02.08.2014 / 01:21