Questions tagged [db-browser-sqlite]
104 questions
0
votes
1 answer
DB. Browser.Sqlite.OperationalError: database is locked
I am trying to submit a form into DB Browser Sqlite. I've created a table. I am able to store the data into Sqlite. However, once I add in a function to execute a cofirmation popup box in submit button (submitclaim.html), I was displayed with this…
Elton Tan
- 49
- 1
- 13
0
votes
0 answers
No Such Column in SQLite Temporary Table Statement
I have two SQLite tables (companies and complaints) I'm using to calculate a ratio of HR complaints to employees, but when attempting to run the query below in DB Browser, I'm getting this error:
-- Result: no such column:…
Marcatectura
- 1,721
- 5
- 30
- 49
0
votes
3 answers
Change duplicate value in a column
Can you please tell me what SQL query can I use to change duplicates in one column of my table?
I found these duplicates:
SELECT Model, count(*) FROM Devices GROUP BY model HAVING count(*) > 1;
I was looking for information on exactly how to change…
Alex Rebell
- 465
- 3
- 15
0
votes
0 answers
Python & db browser : cannot insert data from a table in another one
I have a little project and I don't understand how to resolve it.
I want to create a pc builder for a school project with Tkinter and SQLite 3 (that's the rules). But I have a huge issue : When i want to save informations into the database, nothing…
Erikagle
- 1
0
votes
1 answer
how to export queried result from db browser sqlite to google drive
i have a table with over six millions rows and i want to query them and save the result as a google sheet document but I don't know how.
as well I would like to know how to save the result as a new table in the database
davidla
- 85
- 1
- 11
0
votes
1 answer
Why I can't find my database file in C: disc from DB Browser
I made database file called doctors.db in path given in following picture. I played with it in Command Prompt and it works perfect!
Now when I try to find it with program DB Browser for sqlite, you can see it is not possible to find it. Does…
Stefan
- 969
- 6
- 9
0
votes
0 answers
SQLite DB Browser, can't modify column because trigger
I want to add a column to a table with DB Browser but when I try to save, I get this error message:
Modifying this column failes. Error returned from database: Error
renaming table 'sqlb_temp_table_19' to 'ClientData'.Message from
database engine:…
sirzento
- 537
- 1
- 5
- 23
0
votes
1 answer
Trying to add a CHECK constraint using DB Browser for SQLite
Using DB Browser for SQLite I am trying to add a check constraint on a numeric field. In the Edit Table Definition screen, I can add and name the constraint, but I'm unable to add the check conditions in the CHECK() section of the command. I can…
Eric M
- 21
- 2
0
votes
3 answers
Time overlaps from Nesting queries
Based on the current schema I have been asked to find
-- people who were untested and exposed to some one infectious
-- Do not list anyone twice and do not list known sick people
-- Exposed = at the same place, and overlap in time (No overlap time…
Vij
- 59
- 5
0
votes
2 answers
Timestamps and addition of weeks
My query requires me to find the number of people positive and their infectious periods which is plus and minus 2 weeks. In my query below I keep getting null in my 2 weeks Timestamp
select PersonID, f_name || ' ' || L_name as 'Citizen', Timestamp,…
Vij
- 59
- 5
0
votes
2 answers
Ambiguous Columns and Count
My query requires me to find the busiest location by number of people (Schema Attached)
select DISTINCT location.name as 'Location', f_name|| ' ' || l_name as 'Citizen'
from CheckIn
join location on checkin.LocID = Location.LocID
join person on…
Vij
- 59
- 5
0
votes
0 answers
(sqlite) How to share the same Primary Key across four tables
I'm really new to setting relationships between tables.
I created 4 tables and they're in a one-on-one relationship, so I want to make these tables share the PK.
I'm using db browser for sqlite.
Thanks
erinoy
- 1
- 1
0
votes
1 answer
Why am I getting a foreign key mismatch when trying to insert unique values from parent table into child?
I am attempting to insert the unique values of the Subject field in Main_Standards into the Name field of Subjects, which is a foreign key referencing the Subject field.
Here is my Main_Standards table:
CREATE TABLE "Main_Standards" (
"ID" …
DaddyProphet
- 128
- 2
- 8
0
votes
1 answer
Third column conditional upon first two columns (SQL)
In DB Browser for SQLite, if I have two columns, results1 and results2, each of which can either have "pass" or "fail" (or blank( in the column, how can I create a third column called results_final which returns "pass" if both results1 and results2…
bz_2020
- 79
- 1
- 14
0
votes
1 answer
Convert format of data to just date
Whilst using DB Browser for SQLite, how can I convert e.g.:
2017-06-20T23:12:58Z
to just the date (2017-06-20) without the characters "T" and "Z" and without the time?
If I use CAST(expression as date) or CAST(expression as datetime) I get the year…
bz_2020
- 79
- 1
- 14