All Questions
11,389
questions
-4
votes
1
answer
37
views
Deleting item from sqlite database have error [closed]
Deleting item from sqlite database error.
CustomAdapter
public class PassAdapter extends RecyclerView.Adapter<PassViewHolder> {
Context context;
MainActivity mainActivity;
private ...
- 1
0
votes
1
answer
35
views
Sqlite3 Checking to see if a record exists
I have scoured stackoverflow for answers and none that i found have worked for me.
I want to check if a user already exists in an sqlite3 database
self.c.execute('SELECT username AND password, COUNT(*)...
-3
votes
0
answers
29
views
Advice on ideal data structure for storing Long Jsons within SQLite/RDBMS
I am developing a project that displays a live rendering of bus, when the user clicks on a bus, i would like a linestring representing the bus route to appear/highlight.
I am currently attempting to ...
-2
votes
0
answers
22
views
C# Plugin Database Connection
in the Autocad Plugin I wrote in C#, I can use the x, y axis and last field information entered by the user.
I want to save to SqLite database.
I would be very happy if you could help me on how to do ...
-2
votes
0
answers
26
views
Problem opening the database with SQLite in Visual Studio Code
I am following a course named "Build an app with ASP.NET Core and Angular from scratch", and in that course everything was going smoothly up till I tried to run the "SQLite: Open ...
- 1
-2
votes
1
answer
59
views
Can't fetch the audio data from the sql database using python
I am trying to store a song in a database using Python and then retrieve it using Python as well. The song is in MP3 format. However, when I attempt to retrieve the song file, it does not play. ...
- 1
-2
votes
0
answers
31
views
local(s) - remote database sync strategy
i need to develop a database synchronization strategy, i have a wpf application that can run on different clients.
each application has a SQLite database where it can write data, and then I have a ...
- 73
-4
votes
2
answers
62
views
I am trying to run SQL statement getting the syntax error
Error code returned:
Result: near "Type": syntax error
At line 2:
SQL statement:
SELECT
InvoiceDate,
BillingAddress,
BillingCity,
total,
CASE
WHEN total < 2....
0
votes
0
answers
19
views
Why does the first connection release its PENDING lock when the second connection commits?
In the following code, conn1 first obtains a PENDING lock on the database but fails to write (because conn2 is holding a SHARED lock).
However, when conn2 commit()s, conn1 releases its PENDING lock.
...
- 100
0
votes
0
answers
13
views
Insert commands work according to the terminal but the values are not imported in the datebase. What do I do wrong?
According to my Terminal, I inserted values in my database succesfully.
I used : db.execute("...")
But the table in the database does not contain those values.
They are set NULL but initally ...
- 11
0
votes
0
answers
48
views
Flutter SQLite database limit size length to load external database from assets
I insert SQLite database file in my project and its size almost 2GB. I always got this error message in debug console when running on Android native device:
E/flutter (25145): [ERROR:flutter/shell/...
- 865
0
votes
0
answers
50
views
Can I get the type (class) of a table using SQLite in C#?
I have multiple tables for separate classes and want to print their data using a single method.
My code so far.
In the while (reader.Read()) loop the program doesnt enter the if statements (reader....
0
votes
0
answers
20
views
After "make" my electron app can't find the sqlite3 module
I'm using electron forge, React and sqlite3 with node.js, and after i tried to make the app: "npm run make" the app works fine, but can't find the sqlite3 module, so my database don't work. ...
0
votes
1
answer
49
views
SQLite same-table ON DELETE CASCADE not working
I'm building a web forum thing and using SQLite (with Python) to store data. Each forum has a table with the following create statement (defined via DB Browser for SQLite 3.12.2):
CREATE TABLE "...
-3
votes
1
answer
50
views
How to only get a value from a table?
I want to extract a specific value from a table and do some calculations with it and insert the solution into an other table. The calculation includes an user input.
I get a runtime error: unsopported ...
- 11