I need to insert the data one at a time and add it to the end of the string, but what happens is that the way I’m doing is overwriting the data Output: This is my SQL: Output SQL: I need it to be like this: Answer According to my comment, use 3 tables : RECEIPTS id nameReceipt descReceipt 1
Tag: dart
SQL Statment fails to run with Syntax errors using Flutter/Dart and PostgreSql 12, even though exact same query runs to the same db from python
Hi Flutter/Dart/PostgreSQL noob here; I have an SQL statement which is running fine from a python/Flask application, I am using some variables within it which are added in at runtime to the statement before it is sent to the db.This is the python version; As I said this works fine apologises if I have not add…
How to stop class database file getting created multiple times when using flutter_moor?
Whenever I am adding a new row to my database in my flutter app, I am getting this error : WARNING (moor): It looks like you’ve created the database classAppDatabase multiple times. When these two databases use the same QueryExecutor, race conditions will ocur and might corrupt the database. I read diff…
Can I do a case-based foreign key command (either cascade or set null)?
I would like to give the user the option when he is deleting an item in the parent table, to either cascade delete or set null to the items in the child table that references the foreign key, is that possible within SQLITE? or do I have to do this within my code? These are the commands I currently use