Stack Overflow
Stack Overflow

Questions tagged [sqlitestudio]

SQLiteStudio is a DB manager for SQLite databases

SQLiteStudio is a Windows-base DB manager for SQLite databases

90 questions
1
vote
1 answer

SQL Subquery status for specific week added to aggregate

I have spent several hours trying to solve this and come up with a lot of frustration and no results. I am a newbie to this but willing to learn. I am using SQLiteStudio Data: I have a table with a years worth of rental data. There is an entry…
Mark
  • 49
  • 11
1
vote
1 answer

How to select from static list of values in android sqlite, syntax error near values(

I am trying to create a static list of timestamps so that i can join them agains another table to create chart data. So far I have a query in this format SELECT * FROM (VALUES('a'),('b'),('c'),('d')) AS tbl ,which is working in sqlitestudio but not…
Japheth Ongeri - inkalimeva
  • 4,909
  • 6
  • 29
  • 46
1
vote
1 answer

SQLite Studio - Export database with adding quote to string number

I cannot export my database to a sql file with adding quote to string number. I store code postal number as CHAR[5] but it exports without 'quote'. eg: What I want my quoting string number '01234' like: CREATE TABLE codepostal ( code CHAR( 5 )…
Anh-Tuan Mai
  • 1,129
  • 19
  • 36
1
vote
1 answer

SQLite 3.8 timestamp update trigger issue

I just recently started using SQLite Studio 3.0.5, just to try it out, I've been using SQLiteSPY 1.9.6 for a while now, with almost never any issues. Here is a simple dictionary table with two triggers that execute perfectly. CREATE TABLE IF NOT…
Eduard Florea
  • 49
  • 6
0
votes
0 answers

Cannot install SQLite Studio on Raspberry Pi 3B

I'm new to Raspberry pi and unable to install this particular app. I've just got a fresh install of Raspbian OS. The site just offers .run file. Whenever I click it, it asks which app to open it with, that's confusing because on Ubuntu it just…
Prajjwal
  • 1
  • 2
0
votes
0 answers

SQLite view column name, specifically in SQLiteStudio

I have two tables in a SQLite3 database, table a has columns id (primary key) and name, table b has columns parent (foreign key into a) and name as well. I create a view for the join: CREATE VIEW a_b AS SELECT * FROM a JOIN …
Grismar
  • 27,561
  • 4
  • 31
  • 54
0
votes
0 answers

Why can't I divide two column number values in SQLite Studio?

I am trying to show the likelihood of dying if you contract COVID, by using a division expression as shown below but, I am only getting zeros for the results. I replaced the division symbol with a multiplication symbol and it worked but not with…
klopezdata
  • 1
0
votes
0 answers

How to print function parameter's value?

In SQLiteStudio 3.3.3 I created a function. How can I print parameter args1's value in the area "Function implementation code"? Error: No such column: arg1
megaultron
  • 399
  • 2
  • 15
0
votes
0 answers

Window frame specification in SQLiteStudio

I am running below code from the SQLite documentation on SQLiteStudio 3.3.3 : SELECT a, b, group_concat(b, '.') OVER ( ORDER BY a ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING ) AS group_concat FROM t1; Where t1 is defined as : CREATE TABLE t1(a…
davide lacapra
  • 1
  • 1
0
votes
1 answer

How can i import .DMP files into SQLiteStudio

i need to import some .DMP files into SQLiteStudio, i tried a lot of things but can´t find how to do it. If you can help me i appreciate it
Marco Solis
  • 1
0
votes
1 answer

BEFORE INSERT trigger with primary key using the sqlite3 shell .import command

I'm trying to create a BEFORE INSERT trigger in Sqlite that catches my unique primary key column (UID) during import and replaces the remaining columns. I'm using sqlite3 command line for CSV import and whenever it sees an existing UID it doesn't…
DonShaun
  • 21
  • 5
0
votes
1 answer

Unable to understand sql statement termination

SQL noob here. I am trying to learn SQL using the following guide. So here is my simple query answer for the following exercise question SELECT the report_code, year, quarter, and temperature, where a “quarter” is “Q1”, “Q2”, “Q3”, or “Q4”…
AjB
  • 890
  • 13
  • 34
0
votes
1 answer

SQLite syntax error at UPDATE - works in SQLiteStudio, not in my code

my problem is, that I wrote an update, checked it in SQLiteStudio, it works fine. When I execute the same in my program, it throws a syntax error. ('near "FROM": syntax error') There is a difference in the sqlite3.dlls, because SQLiteStudio uses a…
Gabor
  • 11
  • 2
0
votes
0 answers

comparing two BLOB statements in SQLite using SQLiteStudio

I am currently working on a warehouse management system operated on a Raspberry Pi. Scanning a QR code should open the correct line of the database. I read the text file/CSV file containing the QR code into my Table QR database via: insert into QR…
PatriciaAM
  • 1
0
votes
0 answers

Viewing database with an external program on Mac

First time on SO. I am new to Flutter and I have created an SQLite database ‘fmp.db’ in Android Studio 4.1.1 on Mac (Catalina). If I use ‘View->Tool Windows ->Database inspector’ I can see all the tables and the data inside those tables but if I…
user1690480
  • 1
  • 1
1 2
3
4 5 6