I need help with my React Native app. I need to calculate the average value between each element of the array. The logic is as follows, if there are 4 elements with values 3,5,6,9, then you need to calculate the…
I'm running some SQLite commands at the launch of an iOS app to prepare database tables. The whole statement runs without returning an error. When I try to insert data into second or third tables, I get this SQLite error:…
The delete request using fetch on the site does not work. But in the server part, the delete request is triggered(http://127.0.0.1:8000/docs ). show_posts_to_delete.html: {% extends "shared/index.html" %} {% block title %} <title>Delete posts</title> {% endblock %} {% block content %}…
I have searched through this site and the general consensus is that you cannot embed an UPDATE within a SELECT statement -- UPDATEs do not return data and SELECTs do not modify data. That being said, I have found 2…
I have 4 entities : User(id*, ...) Permission(user_id*, resource_id*, resource_type, role) Resource1(id*, ...) Resource2(id*, ...) Resource1 and Resource2 share no semantic relation and are completely independant. How can I force my database to ensure that Permission.resource_id exists in one and…
When I learned that no file could be modified inside the assets folder I did the following: Use a variable to store data. How to call it again? Using SQLite shows the same problem and error messages. Store the data…
SQLite Error 1: no such table: __EFMigrationsHistory It happens after I migrate and update database. I am using a combination of Entity Framework Core and SQLite and have several DbSets in my DbContext file: using Microsoft.EntityFrameworkCore; using VinylTap.Models; namespace VinylTap.ClientApp.Data…
For a to-do list app I want to make data persist using SQLite but I'm facing issues: - Invariant Violation: "main" has not been registered. This can happen if: * Metro (the local dev server) is run from the wrong…
Please let me ask. schema.prisma model User { id Int @id @default(autoincrement()) name String // Not Null self Friend[] @relation("self") friend Friend[] @relation("friend") } model Friend { id Int @id @default(autoincrement()) user User @relation("self", fields: [userId], references: [id]) userId Int…
I'm new to C# and I want to use a third library party library for the first time, in this case the sqlite library. My problem: I haven't got enough memory on my computer to install Visual Studio, so I…