Questions tagged as 'sqlite'

0
answers

Pass a value from my database to a select in a form

I am working with JSP, Servlets and SQlite using the MVC pattern, in eclipse. I explain what I'm doing, I have a page that lists a series of records and shows them in a table (all right up there) I am using JSTL, a servlet returns an ar...
asked by 08.11.2018 / 18:58
0
answers

SQLite functions transct?

Can you use SQL transct in SQLite ? If not, other embedded databases exist and which ones have these functions? Try to do full join in the following way, but do not allow it. SELECT marbete.id_marbete, producto.sku, producto."desc",...
asked by 08.11.2018 / 17:41
2
answers

Create a table in sqlite using a variable

I want to program a function in python that creates tables in a sqlite database from a variable. This code does not work: def creartabla(nombretabla): connectionObject = sqlite3.connect("jez") cursorObject = connectionObject.cursor()...
asked by 06.11.2018 / 20:45
0
answers

Problem with Update Listview associated with Sqlite

I have problems with the update of listview , which in other activities I modify the database sqlite , but when returning to the activity these changes are not reflected in listview . The event I do in onActivityResult...
asked by 06.11.2018 / 17:27
0
answers

Enter and display data on Android with Firebase

is that I have a question and it is a bit urgent. I need to do a project in Android Studio where I have a client (id, name), a product (number, product name), the goal is to create these 2 and show them as an invoice, something like showing the...
asked by 09.11.2018 / 05:20
1
answer

How to update a database from Qt?

I have a program that opens a database and presents the database through a model in a table view in Qt. I am able to add and delete rows in my database through some buttons that activate the action and some text boxes where to put the informa...
asked by 24.10.2018 / 08:08
0
answers

Return last log entered with greenDAO

I am working an android App with greenDAO, I need to keep an order-detail but I can not find a practical way to do it, I do not know if there is a method that returns the created object. at the moment what I happen to do is enter the record and...
asked by 21.10.2018 / 05:57
0
answers

SQLite Fincas with sum of income and expenses

I'm trying to play a Farm Rentals application, made with FileMaker in SQLite. I want to obtain, from each farm and year, the income and expenses. The tables involved are the following: Fincas (Farms), Lloguers (Income), Despeses (Expenses)....
asked by 19.10.2018 / 16:39
1
answer

Problem with the bridge table in SQLite database

I am learning SQL, using SQLite. I'm seeing how many-to-many relationships work between tables that use primary key and foreign key. I have three tables: contacts , which has the following columns: contact_id (primary key), first_nam...
asked by 18.10.2018 / 08:44
0
answers

Search with SQLite filter

I have a table called BUSINESS, with name, category, time, address. Create a method: public List<Negocio> findFilter(String selection){ //BUSCAR CON FILTRO //Cursor cursor = database.query(NegociosDBOpenHelper.TABLE_NEGOCIOS...
asked by 16.10.2018 / 04:15