Questions tagged as 'sqlite'

Tagged questions
1
answer

Predicate with CAST

Accessing the database .sqlite via sql normally, I can use the CAST('coluna' as decimal) function. Via NSPredicate using CoreData , how do I do the same thing? I have a column of type String and I need...
asked by 28.11.2014 / 17:21
1
answer

Problem when inserting into a SQLITE table using RAD STUDIO XE6

Good afternoon, I am having a problem in my code, I use Rad Studio XE6 connected to an SQLITE base, when I insert values with point in the table the following error occurs for example = 'near' 6.75 ": syntax error 'being 6.75 the value, when I p...
asked by 09.09.2014 / 20:43
0
answers

Using External Sqlite in the Assets folder with Fragment

I'm using an external sqlite database, in the assets folder. Follow this template ( uploading-a-created-bank -externally ) and got access to the bank. How much testing worked normally on my MainActivity, the problem I had was when I tried...
asked by 24.11.2014 / 17:21
1
answer

List data from two tables in tableView

What do I do to list data from two tables in tableView? Database (Example) Sqlite: tb_venda tb_produto tb_valor tb_cliente_id (Id do cliente "tb_cliente") tb_cliente tb_cliente_id (id primary key) tb_nome tb_estado With...
asked by 04.07.2014 / 16:08
2
answers

Android - How to export the database into a csv file?

I have an application that collects and stores information in a database, and the user can query that data within the application itself. However, I would like to insert a button to export the database to a .csv file. Has anyone done o...
asked by 13.04.2015 / 21:02
1
answer

Problem with android UPDATE

I'm having an issue giving update to a table in Android/SqLite : I tried two ways I found: String query = "UPDATE MY_TABLE SET VALUE1='VALUE1'... WHERE KEY_ID = KEY_ID" SQLiteDatabase db = dbHelper.getWritableDatabase(); db.exe...
asked by 14.09.2016 / 21:48
2
answers

SQLite can be considered a relational database?

According to Wikipedia , A relational database is a database that models the data in a way that they are perceived by the user as tables, or more formally relationships. In my understanding SQLite fits this definition (and others I've...
asked by 12.01.2017 / 04:25
1
answer

Database or disk is full?

Is this a disk drive error? If so how to fix it? I have been suffering for some time with this I sincerely hope that you will respond to me     
asked by 16.06.2015 / 18:20
2
answers

JavaScript and Language C accessing the same database

I'm using a Facebook APP (and JavaScript SDK) to use the login on a website, plus I should store some basic information about the user. By requirement of the teacher, this site was all built "using language C" (Mongoose). The problem is: I...
asked by 14.10.2015 / 15:29
1
answer

SQLITE INSERT problem when app starts

I'm doing Insert in my SQLite, however, I'm getting it! NSLog returns: 2014-06-01 23: 15: 35.664 goTask [25379: 60b] open Bank: open bank successfully 2014-06-01 23: 15: 35.666 goTask [25379: 60b] createTable: Table created successful...
asked by 01.06.2014 / 21:33