Category "sqlite"

how can I use vcpkg to install sqlite3 and use in cmakelist.txt?

I use vcpkg to load sqlite3 for my C++ project. for vcpkg, I think I integrate it correctly: PS D:\tool\vcpkg\vcpkg> .\vcpkg.exe integrate install Applied us

Sqlite running total fails when executed from Embarcadero Delphi

I have unsuccessfully tried to execute a SELECT from inside Delphi XE7. The same query perfectly works when run from inside SqliteExpert (or any other similar a

Python sqlite3.OperationalError: no such table:

I am trying to store data about pupils at a school. I've done a few tables before, such as one for passwords and Teachers which I will later bring together in o

How to make it so that the user cannot modify the sqlite3 database when distributing

I have created a python script that uses a database, which I have to pass in the file when compiling the .exe to a file. I would like to know if it is possible

SQL query question, how to make a query that outputs all entries of two tables

I have two tables, CITIES and FLIGHTS: CITIES id name 1 New York 2 Paris 3 Tokyo 4 Amsterdam FLIGHTS id departure_id arrival_id 1 1 2 2 1 3 3 2 3 4 2 4 I ne

Finding duplicate values in multiple colums in a SQL table and count for chars

referring to this question: Finding duplicate values in multiple colums in a SQL table and count I have the following table structure: id name1 name2 name3 ...

sqllite offline in ionic 4

I am facing issue in ionic 4 . Induction variable gives undefined but there is data when i run sql query ..Help me Please following is my code try {

Klockwork Error with dependency (SqliteAgent)

Good afternoon, I am trying to add the klockwork plugin in QNX (eclipse based) which is using Java 1.6 version (It is needed this version). I have Klockwork ver

rails tutorial Test errors that occur after Chapter 6

I'm a beginner. rails tutorial I got an error like this when I did a rails test after finishing Chapter 6 and before giving it to git. I did an integration test

How to Close Statements and Connection in This Method

How to Close Statements and Connection in This Method public static ResultSet getData (String query){ try { Connection con = ConnectionPro

Flask + sqlite + html

I need to make that when I click register on the site, the data is added as a new line in the database. But when the button is clicked, the site is simply updat

Prisma SQLite List

I'm trying to add a List to a model using String[] but it it gives me this error: Field "stats" in model "Player" can't be a list. The current connector does no

How set up a project with nextjs and SQLite3 in electron?

This is the first time with electron, i found a repo called nextron on github, but there are no examples with SQLite3. Do you have a boilerplate? How can i reac

Not saving the flutter switch value to sqflite database

I am a completely a beginner to sqlite and flutter. I was trying to create a local database to my flutter to do app. So I watched some youtube videos and starte

SQLITE_BUSY The database file is locked

I'm getting the error [SQLITE_BUSY] The database file is locked (database is locked), even though I close my connection and the statements. Not sure what else

Unknown error calling sqlite3_step (11: database disk image is malformed) eu : iOS

I am working on an iOS App, using SQLite DB. The app has a functionality where on opening the app, records from the server are inserted into the local SQLite db

Room database RawQuery() is not work on "IN" and "NOT IN" clause

I have my one table like UserTable. @Entity public class UserTable{ @PrimaryKey(autoGenerate = true) private int userId; private String userName;

Sequelize transaction with optimistic locking is locking the whole db

I have an API coded with Node.js and I use a SQLite database with Sequelize. When I make updates, I use a transaction to rollback if something failed during the

geograpy3: sqlite3.OperationalError: no such table

I would like to use the geograpy3 package for a city & country mapping of string values, related to locations (like 'Roma, Italy' or just 'Timișoara').

JOIN 2 tables with an array as a result in the object

I have the following tables: Table 'images': file_name file1.jpg file2.jpg Table 'types': type type_a type_b Table 'images_types_bridge': file_name type fi