正规365体育投注

Questions tagged [sqlite]

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Database doesn't exist/not being loaded in built app with Expo

for the last couple of months I've been working on my first app project with react native and Expo. I'm ready to finally launch my app but I'm having one big issue: The app uses a premade sqlite ...
2
votes
2answers
34 views

ANDROID STUDIO / SQLiteLog: (1) near “LIMIT”: syntax error

I am trying to delete the duplicates that I am getting in my database using DELETE function of my SQL with LIMIT 1 but it is showing me the "LIMIT" syntax error . myDatabase.execSQL("CREATE ...
0
votes
0answers
13 views

SQLite not working with Electron and Node on Windows 10

I have been trying for weeks to get SQLite installed and working with Electron, but rebuild keeps failing. I am on windows 10 and here is my procedure... Install Node... node-v12.16.3-x64 During ...
0
votes
0answers
10 views

Qt - QTabWidget, how to load some data in QScrollArea from a database inside QTabWidget

I have a database which have fields like: name, address, phone no etc. Now, I want to load these properties within a Scroll area inside a tab from the database. Like: Tab1 | Tab2. Tab3. Tab4 ...
0
votes
1answer
15 views

How to solve sqlalchemy.exc.InvalidRequestError: One or more mappers failed to initialize [closed]

I have 3 models in models.py, and the relationship is many Products to many Sellers and one Category can have many Products: association_table = db.Table('association', db.metadata, db.Column('...
0
votes
1answer
27 views

How to manage empty result set from SQL query?

This is what I have: Problem 1: Some companies don't have "R&D Expenses" at all. In which case select statement would return nothing (that's the H case). When this happens the entire SQL returns ...
1
vote
1answer
11 views

Variable value in search box is lost when displaying records with pagination using Flask

Problem description: I have a list of swimmer names stored in Sqlite db at the swimmer table. The list is displayed to the user when clicking on home menu. When the swimmers option is selected from ...
0
votes
1answer
14 views

Android Kotlin - Error when using one to many entity relationship

When I originally built my application, it took the cardName and hosted it in a RecyclerView that held a list of each card by name. Since I'm still new to development, I did this to see if I could get ...
0
votes
1answer
30 views

Inserting data to the table by querying from multiple tables [closed]

I want to populate the table 'Employee' by querying data from 'Access' and 'Employee_old' tables. I want to, only populate newer records that are not present in the 'Employee' table. Below query ...
0
votes
1answer
11 views

Update sqlite table with non-null values from another table

I have two sqlite tables, both with the same column layout. I would like to merge the two tables (or update table 1), taking values from table 2 if they are not null, otherwise, taking them from table ...
0
votes
4answers
40 views

How to connect two list together in python

I have these two list: names = ["John", "Barack", "Elon"] numbers = ["0342", "03478878", "0345"] They are my clients, what I want is that the item "John", should be linked with its number, which is ...
1
vote
2answers
15 views

I am getting 0 whenever I try to do division in SQL (how do I get around this)?

I tried running this query (current_pop is the current population of the countries in my table): select country, current_pop/8000000000 from countries What I got was 0s . I'm pretty sure this is ...
0
votes
0answers
5 views

Displaying specific range of dates on the x-axis with GraphView using SQLite on Android Studio

I am using a date range picker to be able to pick the range of dates to be displayed on the x-axis. For example, if I picked between May 10 and May 17 on the date range picker, I'd like to be able to ...
-1
votes
1answer
14 views

How to set two columns together as the primary key of a table (sqlite)? [closed]

I tried running this code create table manufacturing_facilities ( company nvarchar(25) NOT NULL, country nvarchar(25) NOT NULL, number_of_locations integer NOT NULL Primary ...
1
vote
1answer
28 views

Connect to sqlite3.Connection using sqlalchemy

I am using a library that creates an SQLite library in-memory by calling sqlite3.connect(':memory:'). I would like to connect to this database using sqlalchemy to use some ORM and other nice bells and ...

15 30 50 per page
1
2 3 4 5
5511