Questions tagged as 'sqlite'

1
answer

Xamarin - SQLite Join

I'm creating an app on xamarin, which generates a sales order, and stores it on my phone. I'm using SQLite to store the data, but I'm having trouble joining between my Order Items table and the Products table. I have both models below: [...
asked by 16.06.2016 / 16:34
1
answer

Capture the data corresponding to the index in the bank

I was able to feed my listview with SQLite data, however, I now want to capture the data (in the database) that each row in the listview matches. For example: Line 10 displays Code 1 and Name: Philip Line 13 displays Code 4 and Name: Giov...
asked by 13.01.2017 / 20:28
1
answer

Including in the APK an SQLite database

Is it possible to include the application database in the APK installation? I already have all the necessary records for the operation of the application and would like to include it during the installation.     
asked by 24.11.2014 / 22:39
1
answer

Best way to model the database of a chat [closed]

I have an application that works with webServices and the mysql database, I'm putting a chat on it, the part about how to get messages, view notifications and search for users I already have, my question is: How should I store my messages in...
asked by 15.08.2014 / 19:58
2
answers

How to execute the INSERT only if the record does not exist?

I would like to use something like this in SQlite insert into table (column) values ('')if not exist;     
asked by 10.12.2017 / 13:35
4
answers

How to list all tables in a SQLite database?

In MySQL, when I run the command SHOW TABLES I can see all the tables present in a particular database. What about SQLite? How can I do this?     
asked by 15.12.2016 / 15:52
1
answer

How do I save an image in the database in SQLite?

How do I save an image in SQLite? I ask to be as specific as possible because I do not have much experience. In case I want to include a table row to save the image. import br.gestaoBd.Login; public class EstruturaBanco { public static...
asked by 11.01.2016 / 04:38
2
answers

System modulation

I'm developing a C # system with WinForms of Livestock Control for a farm, and will communicate with a scale to improve the weighing process. Some of the features are (Invoice entry, vaccination, casualties, transfers, purchases, stock). I...
asked by 26.10.2016 / 16:09
1
answer

Redeem all nodes in a SQLite database tree

I have a serialized tree in my database in the arvore table. Like every good tree, every node can have at most one single parent node. Your data is in this format: id | id_pai | valor ---+--------+------ 1 | | 'pai de todos' 2...
asked by 22.06.2017 / 13:29
1
answer

Error retrieving SQLite data

I'm starting to work with database and I'm already in trouble. Ask for a hand! Well, I have a database, apparently there is no error adding data to it. I have a DBHelper class that inherits from SQLiteOpenHelper and I have another...
asked by 04.02.2017 / 10:30