Questions tagged as 'sqlite'

0
answers

Sqlite android.database.sqlite.SQLiteException

I have the following error:    android.database.sqlite.SQLiteException: near "@teste": syntax error (code 1):, while compiling: SELECT [email protected], test FROM user WHERE email = '[email protected]' AND password = 'test'; @Override public...
asked by 16.10.2015 / 04:18
0
answers

Problems using FK, SQLITE3 and C

I'm having trouble writing records to my log table that has an FK from the client table. The error is in the insert_log () function SQL to create tables sql_create_client = "CREATE TABLE cliente (id INTEGER NOT NULL PRIMARY KEY AUTOINCR...
asked by 02.11.2015 / 01:42
1
answer

How do I open the image in the gallery by clicking on it for my application?

My application has a button that when pressed is opened the camera, as soon as I take the photo, it is placed in an ImageView on the screen and the image path is saved in my database. I would like to know how it does for when I click the image o...
asked by 14.09.2015 / 06:35
1
answer

Script for first charge sqlite Xamarin Android

I need to create a first load script for our application, the problem and that we have two BLOB fields in our table, it is very large with this would like to see the best way to implement this first load?     
asked by 06.07.2015 / 22:20
1
answer

View the database in SQLite

Is there any way I can view the SQLite Database without typing the command in the application? I would like to see the records inserted in a table but I do not know if in Android it just gives by typing the select command in the application or i...
asked by 27.06.2015 / 04:21
1
answer

Object Product Saves on the first screen but on the second screen

Hello, I'm having a problem with a study project. I have 2 activitys, First Product and Second Product. The first instance is the Product1 object and saves it to the SQLite database, when it calls the second activity it passes the id of the p...
asked by 16.07.2015 / 02:40
0
answers

List data in a List View

I'm studying programming for Android, I'm doing a query in the SQLite database, but I can not play the data obtained in a listview, it always returns my string in full instead of the bank's value. This is my function that makes select priva...
asked by 28.05.2015 / 21:13
0
answers

Enter checkbox value in the bank and then use it on the screen

I have a recipe registration screen that contains a checkbox called "received", I would like to know how to insert a tinyint in sqlite and then redeem it when I want to consult this recipe. Ex: I create a recipe and I leave the check received em...
asked by 03.02.2015 / 13:45
2
answers

How to pass data from an SQLite table to several EditText fields

How do I get the data from a table and display it in a EditText ? I'm developing on Android. Here I make List of the data that I need: public List<ConfiguracoesSistema> listarConfiguracoes() { // List que recebe os da...
asked by 10.04.2014 / 20:02
1
answer

Get item data in ListView

I'm developing a college project that consists of a schedule that works with SQLite database. It may sound trivial, but the way I'm doing it makes things a bit more complex. When I click on a list item, the user is directed to another activit...
asked by 10.06.2014 / 01:12