Questions tagged as 'sqlite'

Tagged questions
0
answers

problems with sqlite syntax

hello everyone I have a question about sqlite syntax, so I'm aware it works similar to mysql, but when I try to modify two tables in sqlite it gives me an error in the comma where you are 'users',' score 'to modify the two tables and mysql works...
asked by 03.09.2017 / 22:39
2
answers

c # class to manage different BD providers

I have the following code, this class where I define the interface namespace classBD.clases.connexiones { public interface IConexion { void OpenConection(); void CloseConnection(); void ExecuteQueries(string Qu...
asked by 18.05.2017 / 10:03
1
answer

Manage listview and sqlite instance

I come with a small problem in my application, I use android studio for development, what happens is that I have 3 activities: In SELECT I choose an option by means of a spinner and by checkbox , I generate a query that I kee...
asked by 31.05.2017 / 08:02
1
answer

Insert in SQLite with C ++

With the "users" table created, I am ready to enter data in it. These data are entered by the user, and then inserted in the table. I have the following function: int registrarUsuario(string name, string second){ sqlite3 *db;...
asked by 31.05.2017 / 15:20
1
answer

Duda SQLITE query

I have a table that stores me that stores three numbers and an ID. NUMERO1 NUMERO2 NUMERO3 ID 14070 4641 24155 1 14070 4780 24155 2 14070 4333 24155 3 15000 4303 24000...
asked by 21.03.2017 / 13:35
1
answer

Problem when updating a SQLite VarChar in Java

My problem is this, I have a basic stock program. The stock manages items, these have id (int), name (string), price (float), category (string) the dilemma is at the time of updating because I update the price, the category but not the name! It'...
asked by 19.03.2017 / 19:38
1
answer

One of the SQLite columns is not generated in Android Studio

In one of the tables I have in my database does not generate a column and I do not understand the reason because I created it exactly like the other and the other does not give failures. When I call the cursor that reads the entire table, it...
asked by 06.02.2017 / 17:33
1
answer

Delete repeated elements from a table

The method takes some elements of a table and places them in another table, what I want is that if the same elements are added again they are eliminated or they can not be added if they already exist. public void añadirErrores(int[] pregMalas)...
asked by 22.01.2017 / 14:25
1
answer

From Sqlite to MySql (several records at once)

How to make a selection to the records that I created with my "high" method (to see that I save them as I want) my problem is that I want to create the table without a PK, and I also wanted to know what the form is more useful to upload the data...
asked by 22.12.2016 / 18:39
1
answer

SQLite + Webservice (json) - MySql

I am developing a tracking application with the class LocationManager accessing the latitudes and longitudes of the gps and uploading to the server with jsonparser every minute by means of a Handler . I want to make a lo...
asked by 16.12.2016 / 16:38