Questions tagged as 'sqlite'

Tagged questions
2
answers

How to convert a date that is in string format to the database when doing a query?

I have a date that is in string format in the "dd/MM/yyyy" database and I needed to return in my query the dates from today. How can I do this query conversion to compare with today? Thank you in advance! update: I am using the minh...
asked by 07.10.2015 / 15:24
1
answer

Is WebSQL the only form of local storage on the phonegap / cord?

Outside the database created by "browser", what other forms of data persistence do we have in android with the phonegap?     
asked by 01.10.2015 / 21:00
1
answer

Value Conversion had Date in sqlite Android error The method getText () is undefined for the type String

I'm doing the insertion of a DATE type value in my project, so I had to convert it, in my corresponding class, my tribute Dt_read, it is declared as string and in the database it is as Date. For this, at the moment I'm inserting the record in th...
asked by 31.10.2015 / 19:24
1
answer

How to release the data that is in the "date" folder of the Android phone?

I am making an app where I create the forms from the database, but nothing is appearing on my phone, I can only see it in AVD, how do I release it?     
asked by 14.07.2015 / 23:43
2
answers

Why does an 'NSInvalidArgumentException' occur in this code?

I have a class that manages my entire database, my project is in Swift but I have two classes in Objective-C to bridge the classes and my Helper . p> After some testing on the iOS simulator I had the following error message:    Terminatin...
asked by 24.06.2015 / 19:32
2
answers

Android: Problem fetching last id inserted with SQLiteDataBase (ORM Lite)

I'm having a problem executing a query (with ORMLite) that adds the return to 'lastConfiguration' in which you should get the last 'id' inserted in the Configuration table. The method that looks for the last configuration is as follows: publ...
asked by 23.02.2015 / 23:57
1
answer

List tables with specific column

I'm creating an application on Android using SQLite and I need to get a list of tables with a specific column like: SELECT table_name FROM sqlite_master WHERE table_column_map = 'imagem' Is it possible to do this?     
asked by 19.01.2015 / 00:04
1
answer

Get the id of the textview that is inserted in the listview and put in the bd

I have a layout with 2 lists, one complements the other, category and subcategory I would like, when I would insert a subcategory when clicking add feed the database with the id of the category that is on the same line, that is, I will link...
asked by 22.01.2015 / 18:52
1
answer

Get database ID when selecting option in spinner?

Generally I get the ID of a selected / clicked object with onItemClickListener , but it does not work with Spinner . I've tried it this way: spn.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() { @Override...
asked by 30.01.2015 / 02:39
1
answer

Import PHP CSV file

I have a CSV file with contacts. I want to import these contacts into an sqlite database. How can I read the file and insert it into the database?     
asked by 10.11.2014 / 12:59