Questions tagged as 'sqlite'

Tagged questions
2
answers

how to make a copy of sqlite file to external memory

I'm trying to create a copy of the sd memory, but the procedure I do does not do anything or I get an error, I have the write permissions, this is the code I'm implementing public static boolean copyFile(String from, String to) { bool...
asked by 04.10.2018 / 23:02
1
answer

Convert Calendar to Date to store it in SQLite database

I need to convert a CALENDAR variable to DATE (to get date and time), so after that that DATE variable is saved in an SQLite table that has a DATETIME type. Clarified this we begin by showing the SQLite table called "file", which I plan conta...
asked by 24.08.2018 / 18:01
1
answer

SQLite query

When I want to ask a question, the program closes. I attach the code: public void consulta (View v){ AdminSQLiteOpenHelper admin= new AdminSQLiteOpenHelper(this, "administracion", null, 1); SQLiteDatabase BaseDeDatos=admin.getW...
asked by 14.06.2018 / 01:36
0
answers

CTE with subqueries in anchor and recursive call

It turns out that I have these three tables, Users(id, name) Colleagues(id1, id2) Friends(id1, id2) I need to write a query that gives me pairs of ids so that one can "get" from id1 to id2 with an arbitrary numbe...
asked by 29.06.2018 / 22:48
1
answer

How can I consult several elements of a database with the same identifier? -SQLite-Android Studio

I want to consult a SQLite database in Android Studio. Having a database of people, which has the fields age and name. What I want is to extract from the database all people who are 19 years old. SQLiteDatabase db = OpenHelper.getReadableData...
asked by 08.05.2018 / 21:08
0
answers

ImageView does not load me with your android studio route

From my application I access the gallery to select an image, after selecting it in the database I keep the path of that image, but then to load it in an imageview it does not load it with the saved route and it is that I notice the next problem,...
asked by 21.04.2018 / 04:22
0
answers

The "GenerateJavaStubs" task failed unexpectedly

I am using Xamarin.Forms with local database sqlite-net-pcl, I created a cross-platform project for Android, IOs and two other DLLs to create the classes of the engine and access. I have been running the project without problems but today I got...
asked by 10.05.2018 / 13:00
1
answer

Doubt about sqlite in java

I'm currently doing my first job for a client, I'm using sqlite3 in java. Well the question is the following, to make the project I need to create a database, and to test the program filled the database with fictitious data. Now, what happ...
asked by 19.04.2018 / 00:42
0
answers

The data is not shown in the listview with SQLite (Android studio)

I am creating an application in android studio, on a menu of a cafeteria, what I want to do is that when the person clicks on the "hamburger bbq" button (to give an example) a dialogue box is displayed that ask if you really want to add the hamb...
asked by 31.03.2018 / 00:18
0
answers

Error migrating from SQLite3 to PostGreSQL: No operator matches the given name and argument type (s). You might need to add explicit type casts

SELECT ag.user_id, ag.user_des, ag.user_login, ag.user_pwd, ag.act_readers, ag.h_reader, ag.email, ag.phone, ag.workgroup, ag.suspended, ag.accesstype, ag.firekey, cli.tpdoc FROM agenda ag INNER JOIN Cliente cli ON ag.user_id = cli.doc...
asked by 19.04.2018 / 16:50