Questions tagged as 'sqlite'

1
answer

SQLite with Javascript does not work

I'm getting SQLite now, trying to deploy in a mobile application, I did this test based on some web codes but I can not return a record of the data successfully, until it does the select but it returns 0 records, as the snippet shows : alert(...
asked by 11.02.2016 / 07:39
0
answers

Error saving data in Sqlite database

The create table works, but by putting the code to save, the application compiles but not saved. What can it be? SQLiteDatabase winlife; EditText edt_meta; EditText edt_tempo; EditText edt_dataExpiracao; /** * Fragment managing the behaviors...
asked by 19.09.2015 / 17:36
0
answers

External database is not loading on android [closed]

I need to make an application Android that accesses a servidor , downloads .s3db and queries about downloaded files. I can usually download to data/data/meu-pacote/databases/ and I can also do operations on those files...
asked by 07.06.2015 / 15:34
1
answer

INNER JOIN with OR clause

I have the following select: SELECT linha._id, linha.numero_onibus, linha.nome, percurso.nome FROM linha INNER JOIN percurso ON linha._id = percurso.id_linha AND (linha.numero_onibus LIKE ? OR linha.nome LIKE ?) COLLAT...
asked by 14.10.2014 / 03:24
0
answers

How to synchronize SQLite with MySQL

I have an application in Ionic and Angular that receives information through a $http . I would like to know how to keep the updated offline information of the updated application with those of the MySQL database whenever a connection is...
asked by 22.04.2015 / 18:29
1
answer

Delete function from my table

I wonder why you are giving this problem. I created a function to delete the table of my database and instanciei in the button to execute this function, but when I go to test it presents / displays an error to me. logcat error: E/AndroidR...
asked by 21.12.2016 / 15:15
1
answer

Incompatibility of blob types and byte sqlite

I am making an application to save the image in sqlite. However it is accusing the following error in my class dao: incompatible types byte cannnot be converted to byte. My Classes: import java.io.Serializable; public class Produto implem...
asked by 11.01.2016 / 21:47
2
answers

Popular Spinner with SQLite Database -

I have the following table in the database: CREATE TABLE turma(_id integer primary key autoincrement, nome varchar(20)) I need to fill in a SPINNER with this data, so that the class NAME is displayed, but actually when the user chooses the...
asked by 26.07.2016 / 16:40
2
answers

Local database (serveless) not modifiable with update

Scenery: I'm developing a small application WinForm in C# to distribute to sellers to assemble their budgets faster and would like to store simple information such as budget issued and registered customers. Well, until today...
asked by 16.10.2015 / 15:18
2
answers

Pass activity object id to another

I'm trying to pass id from my object to another activity using Serializable , but it's returning me a damn error that I can not fix.    Obs: My object already implements serialiable My code is as follows: if...
asked by 08.10.2015 / 01:31