Most voted "sqlite" questions
Sqlite is a C-language library that implements a built-in SQL database. Programs that use the Sqlite library can have access to SQL database without running a separate DBMS process, not requiring service configuration.
Learn more…652 questions
Sort by count of
-
0
votes1
answer531
viewsSqlite - Python - refer to table column in a loop
I’m doing a script in Python accessing Sqlite database. I made a loop for but don’t know how to get the value of a column in the table. Take the example: cursor2 = cnx.cursor()…
-
0
votes1
answer59
viewsWhat is the utility of using Basecolumns. _ID to define a contract class in Sqlite?
Why should I wear Basecolumns. _ID instead of simply defining a string as _id ? For example, instead of using: public static final String _ID = BaseColumns._ID; Wouldn’t it be simpler to use this?…
-
0
votes2
answers50
viewsHide registration to the user
When "delete" an accurate record hides it from a table, in the user view, but it must remain in the database. I put a field called 'status' on the table that manages just that. In the exhibition I…
-
0
votes2
answers535
viewsSearch values between two dates in Sqlite
How can I find the records on two dates in the bank Sqlite? In mysql I know it is through BETWEEN, but I don’t know how you do it in Sqlite.
sqliteasked 6 years, 8 months ago José Raimundo Neris 17 -
0
votes2
answers222
viewsFormat year on Sqlite
I need to format a timestamp in the following format: DDMMYYHHMMSS I got it using the strftime, example: select strftime("%d%m%Y%H%M%S", current_timestamp) from stream; But this way it shows 4…
-
0
votes0
answers93
viewsCursor.getColumnIndex() returns -1
I’m trying to accomplish a select in the database of Android, but every time I try, it ends up generating error. By debug discover that one of the columns, when performing the getColumnIndex() is…
-
0
votes0
answers15
viewsHow can I control the time a data was entered in the database - sqlLite Android
I need to control the time a data is entered into the database, to do certain actions as a function of time. I thought to make the difference between the current system time and the insertion time,…
-
0
votes1
answer152
viewsHow can I create a dynamic database in Pyhton
Could someone help me on how to create a dynamic database, where I can add and remove items? In Python, if possible with Sqlite
-
0
votes0
answers33
viewsIonic 2 Offline
Good night! I have an app created in Ionic and all the information is currently online on a server and the app makes the request, the server returns the data, assembles the page and Ok. But it will…
-
0
votes2
answers2189
viewsHow to delete all records from the database
Good afternoon, in my application has a database that shows the results of the game, I put a button that its function will be to erase all the data of the bank... how do I do this part? in the blogs…
-
0
votes0
answers143
viewsDifficult to make an Android Sqlite query
I’m doing a project for college but I’ve been having difficulties with consultations to Sqlite. I wish you could assist me in this issue. Oncreate: protected void onCreate(Bundle savedInstanceState)…
-
0
votes0
answers57
viewsProblems with Sqlitehelper
Hello, I have a registration project and I’m having trouble reading Sqlitehelper, the app only runs without it, when I try to use gives error, the app turns off, if anyone can help me find where is…
-
0
votes0
answers591
viewsSynchronize sqlite with an online database
I need to synchronize (one throwing information to the other) a DB sqlite with some DB server like sqlserver or mysql, and I would like to know how I can do this, I am using the language C# with…
-
0
votes1
answer34
viewsplaceholder for sql varchar
I’m making a program that reads the output of Arduino and sends to a SQLITE3 database. You’re making this mistake: cursor.execute("INSERT INTO reciclagem_data (personID, nome) VALUES (%s,%s)",…
-
0
votes1
answer231
viewsComparing Dates in string, using Sqlite and Nhibernate
I am using Sqlite and Nhibernate, and I am saving in my bank the Datas as String in Sqlite, as it is not possible to store dates in it. Everything was going ok, but I needed to compare dates to…
-
0
votes1
answer77
viewsDynamic background image
I have a list of products, clicking on some of them, redirects to another page showing only the content of this item. I receive the Image, but I would like it to be in the background, that is, it…
-
0
votes1
answer56
viewsUpdate in a table row
I’m starting to use the Sqlite on a project and would like a help on how to do the update in a specific line, in this case, only one "ID" will be updated at a time. Follows the codes: View and where…
-
0
votes0
answers16
viewsHow do I leave a value that comes from Sqlite in an Edittext?
I am developing an app in Android Studio, and I have an Activity on a wallet, and I wanted to take the column ID of Sqlite and leave as default value, how can I do this?
-
0
votes0
answers32
viewsHow to use 2 databases using Room Sqlite?
Hello. Is it possible to use multiple DB using Sqlite Room? In my case I need to use 2 DB if it is possible to switch from DB1 to DB2 dynamically?
-
0
votes0
answers22
viewsSearching Sqlite database data with php
I’m trying to get the name of my Session, and search the database for the data of those who have this name, but echo returns absolutely nothing. $nome = $_SESSION["Aluno"]; $results =…
-
0
votes0
answers90
viewsProblem to connect to external database
When trying to open the connection an error message appears: W/System.err: java.sql.SQLException: opening db: 'C:\sqlite\AgendaOnline': open failed: EROFS (Read-only file system) W/System.err: at…
-
0
votes1
answer407
viewsSet a condition in order by mysql
I am having doubts about a subject related to order by. In my table you have the following information: ID | ORDEM | NOME 1 | 0 | NOME01 2 | 2 | NOME02 3 | 1 | NOME03 I want to give a select where…
-
0
votes1
answer43
viewsInsert with Where where I don’t have full value
Example, I already have in the table the following value in the column NUM_IMPRESSAO: K3244.K1019706.FSJC.08915 The new value I want to insert has only the last 4 digits (08915) and I need to insert…
-
0
votes1
answer147
viewsPopulated sqlite when install apk
When I compile the app directly on mobile Sqlite comes empty (exactly as is the file in the path specified for DB) but when I use . apk generated in the same compilation he populates the DB…
-
0
votes2
answers792
viewsCheck if Registration Exists in BD Sqlite and if there is no Return Message
Good night, I’m trying to make a little app that consists of searching a Sqlite database. For the research I will use two forms, ie through the UN Number and through the Name. However I am facing a…
-
0
votes1
answer546
viewsSQLITE query returning value outside of query rule
I made a program, in python language, that creates a database SQLITE which stores information about a number of closet doors. The information stored are: id (port identification), size (PQ = small,…
-
0
votes1
answer89
viewsSave Radiobuttom after selection
Hello, someone could help me in this matter, I have a list with questions in them there are 3 Radiosbuttom for responses, what I want is when the user click the save button, he lists the selected…
java android sqlite android-recyclerview radiobuttonasked 5 years, 5 months ago Renderson Cerqueira 1 -
0
votes1
answer33
viewsSQL: Sort by columns from another table
I have a user tabala, and another with the respective scores, I need to select from the scoreboard only users who live in a certain country. The country is defended in the users table, each table…
-
0
votes0
answers44
viewsCalculate time intervals in months ( Date List )
I have a Date List 01.01.2017 13-month interval 02.02.2018 period of 14 months 03.04.2019 interval of 8 months 19.12.2019 Is there any way to make a select that returns months between listed dates I…
-
0
votes2
answers1873
viewsCan Sqlite be considered a relational database?
According to Wikipedia, A relational database is a database that models the data in a way that the user perceives them as tables, or more formally relations. In my mind SQLite fits this definition…
-
0
votes1
answer428
viewsApp hangs when giving create in Datamodule
I am creating an Android application in delphiXE7 and everything works until I will create dynamically the datamodule. Then it hangs and does not come back. procedure TForm1.Btn1Click(Sender:…
-
0
votes1
answer73
viewsAdd two columns and subtract with condition
I am trying to sum two columns after subtracting the following way in sql: SELECT sum(valor) WHERE lancamentotipo = "R" - sum(valor) WHERE lancamentotipo = "D" from lancamentos From the above by…
-
0
votes1
answer23
viewsProblem with Sqlite.Net.Interop
I am trying to use the Sqlite.Net.Interop namespace to use the Isqliteplatform class but the package "Sqlite.Net PCL" is as discontinued. I wonder if you have any alternative to solve this problem.…
-
0
votes1
answer78
viewsHow do I complete SQL table name with a variable value?
I want to create a new table for each client and I want to complete the account table with the client id I am creating in another table as in the example below: await db.run('create table if not…
-
0
votes0
answers46
viewsSELECT in a time period in a datetime column
I have the following column id datareg 1 2020-07-24 08:00:00 2 2020-07-24 08:30:00 3 2020-07-24 08:45:00 4 2020-07-24 09:00:00 5 2020-07-24 13:00:00 I need a query that returns the AMOUNT of records…
-
0
votes1
answer35
viewsSqlite is not creating a table
Screenshots of the ERROR that appears. Sqlite is not creating a table and I can’t fix the error if anyone can help me…
-
0
votes0
answers15
viewsI’m having problems with Exception in thread "AWT-Eventqueue-0" and I’m not getting it right
I need to put information from a database into a Jtable and I’m not getting out of that internship and I can’t find it on the Internet. In this project I need to register residents in an Sqlite,…
-
0
votes0
answers13
viewsCakephp returns error in Sqlite database Cannot describe users. It has 0 Columns
Please, Using Cakephp 4.2.5, I have an sqlite database of 3 tables and are not empty. When I do on controller: $usersTable = TableRegistry::getTableLocator()->get('Users'); $query =…
-
0
votes0
answers17
viewsHow to import Mysql data in Xamarin Forms application?
Good morning! I have a dilemma here. I need to import data from a hosted Mysql database to my application in Xamarin.Forms and use it locally in Sqlite. Thus, the user would import the data from the…
-
0
votes0
answers13
viewsSQLITE3 installation via NPM finds 3 vulnerability
Good afternoon guys. I am trying to install sqlite3 with npm, and at the end of the installation it is reported that it had 3 vulnerabilities. I’ve done some research and I’d like to understand…
-
0
votes1
answer147
viewsSELECT in multiple SQLITE tables
I have a table of clients and I make a list of all the items in this table in SQLite I need to list these customers, also search for the lowest date, related to the customer, in another table.…
-
0
votes2
answers337
viewsProblems with reading database [Sqlite]
Day number 3. The app insists on "crashing" its startup and the Frustration is strong at the moment. The problem, I believe, is found in the getFromDb() method, more specifically in the line where I…
-
0
votes0
answers37
viewsjava.lang.Nullpointerexception error when trying to popular Spinner
Inside the Oncreate: spnMateriasID = (Spinner) findViewById(R.id.spnMateria); try{ atividadeModel = new AtividadeModel(this); atividadeModel.getWritableDatabase(); materiaModel = new…
-
0
votes2
answers1720
viewsPHP Fatal error: Uncaught Error: Class 'Sqlite3' not found in /var/www/html/
I have the code below supposedly simple. The intuition is to create a table include values and soon after showing the information, but in the log apache is showing the following: [:error] [pid…
-
0
votes2
answers96
viewsHow to check if last item was registered today?
I have a following table: +----+-----------------------+-----------------------+ | id | description | created_at | +----+-----------------------+-----------------------+ | 5 | Game Of Thrones |…
-
0
votes1
answer665
viewsError using cursor to read Sqlite table
I’m having the following mistake: Couldn’t read Row 0, col -1 from Cursorwindow. Make sure the Cursor is initialized correctly before accessing data from it. however to my view the cursor was…
-
0
votes0
answers67
viewsSqlite only accesses the bank on a device
I created an application on Android that accesses the Sqlite database, the first application I created works normally! The application that works is version 7.1 of Android, but when I try to run the…
-
0
votes0
answers54
viewsSqlite Leak without having any class using Sqlite
Good evening, everyone, I’m building an Android app and the last thing I need is to build the local bank. I built it but I realized that errors of memory appeared Eak, I thought I had fixed but the…
-
0
votes1
answer58
viewsQuery is repeating results - Sqlite
I’m making a query in my bd Sqlite, but is returning me some repeated results can not find the error. cursor = db.Select(DataBaseHandler.TABLE_OS + " LEFT JOIN " + DataBaseHandler.TABLE_SITUACAO + "…
-
0
votes2
answers2265
viewsInsert data when creating Sqlite table
In my database I have a table State and Cities, I would like to enter this data once the app is installed, ie when creating the database these records are already inserted in the tables at once. I…