Stack Overflow
Stack Overflow

Questions tagged [sqflite]

Use this tag for questions about the plugin for flutter named sqflite - which enables storage, retrieval, and manipulation of SQLite databases via flutter code.

sqflite is an plugin for . Supports both and .

Package documentation: sqflite

902 questions
-1
votes
1 answer

flutter: sqflite insert error, "datatype mismatch"

The CREATE successfully works, but INSERT doesn't work. I think arguments of INSERT are correct... but why? (09.09 modify) The problem is the category problem with string input argument. Docker) INSERT INTO Quest(category) VALUES(?) args[walking(X)…
장성호
  • 1
  • 1
  • 1
-1
votes
1 answer

Flutter Implement a Favorites feature using SQLITE

I need help I am developing an app using SQLite, here is my scenario I want to make favorite feature using SQLLITE, if the value does exist then fill the heart icon with red color otherwise remove the color from the heart icon. here is my code …
aneel ilyas
  • 31
  • 10
-1
votes
2 answers

How to create edit function in a Sqlite database

I have created an app where a company can add the contact details of its customers. The data is saved on Sqlite. It is very similar to a To Do app. On the ListTile you get a location icon (not functional yet), the name of the company, then a delete…
Tobsig
  • 33
  • 1
  • 9
-1
votes
1 answer

Dart DateTime.toIso8601String() throwing exception when inserting into SQFlite database

I am having trouble inserting a DateTime.toIso8601String() into a SQLite (SQFlite) database in Dart. The issue I am having is with a property_model class, who's only job is to interact with the database and hold data. I have an almost identical…
Skhoooler
  • 71
  • 3
-1
votes
2 answers

sqflite: How to make a SELECT with two columns inside the same rawQuery

I want to receive info from 2 columns with OR operator, but i can not visualice. I have my column title and my column categoria. I want to make a select that affects both columns, something like this: selec * from title OR categoria where ... this…
Carlos Peñaranda
  • 632
  • 1
  • 6
  • 19
-1
votes
1 answer

Sqflite support for aliases

Does SQFLite supports aliases like SQLite database? e.g column_name AS alias_name want to use nested select query and give nested select query value to specific field
Konstantine Tirkia
  • 69
  • 2
  • 5
-1
votes
1 answer

flutter sqflite how to receive a 'todo' object to display the values?

I am using sqflite to do inserts from OnCreate. Those inserts work fine, and i can visualice the items in a ListView: But when I touch the item from that list, I get this error: this is the code of my list that works okay, and where i send the…
Carlos Peñaranda
  • 632
  • 1
  • 6
  • 19
-1
votes
1 answer

The return type 'Database' isn't a 'Future',

Hello I am getting this error I want to return the database object for the function database I am getting this error The return type 'Database' isn't a 'Future < void >' dart Future < Database > database() async { return openDatabase( …
ZAEEM ASGHAR
  • 1
  • 2
-1
votes
2 answers

Flutter - Save network image to sqflite

Hello guys i want to safe an image in my sqflite database i tried many thing but i only get errors like invalid image data or something else. class HomeScreen extends StatelessWidget { String _base64 =""; @override Widget build(BuildContext…
Eren G
  • 43
  • 8
-1
votes
1 answer

Flutter with Sqflite + Getx data update issues

I am currently using GetX and Sqflite within Flutter and encountering the issue of data update after insert. Firstly, there is a LoadingScreen which checks if there are any entries in the User Database. If none, then it opens up the SignUp Page to…
gputhige
  • 109
  • 2
  • 11
-1
votes
1 answer

While clearing cache the data stored in local database gets erased. How to avoid this issue in Flutter-SQLite-Dart application?

I'm using Flutter-SQLite-Dart to develop a mobile application that has basic functionality just as Quiz application. I store questions and answers to my local database, when cache is cleared then the stored data gets erased. I need to save those…
Terin Tittu
  • 143
  • 1
  • 1
  • 15
-1
votes
1 answer

boolean value retrieved fron sql as string

I send a boolean variable to SQL database, But when i retrieve it it was a string. The Entered Data Code Is: database.execute( "CREATE TABLE tasks (id integer PRIMARY KEY ,isFinished BOOLEAN) "); When i retrieve the data the run time type…
Mariam Albarghouti
  • 409
  • 5
  • 22
-1
votes
2 answers

How can you store lists of Items in Flutter

How could you store something like that even when the app is closed in Flutter: Class myList { String id; List list; } Class Item{ //Many property’s } I thought maybe I could do that with "sqflite", a flutter dependency, but I…
Boothosh81
  • 387
  • 1
  • 5
  • 24
-1
votes
1 answer

SQLite UPDATE multiple rows in a column with a single value except one row (something like invert selection) : flutter

I have a list of objects that only one of them can be selected. For this I have a column in this table (table of objects) that shows the status of the object (selected or not selected) I want to select the item to be clicked and change the status to…
javadbarghamadi75
  • 34
  • 4
-1
votes
1 answer

DateTime in SQL (Flutter)

I am making an app with flutter and storing the data in SQL database using sqflite. How can I store the Date and time in which the form submitted or the other information passed Currently, I am storing Date as a string (TEXT), but while sorting…
Sanchay Kasturey
  • 161
  • 1
  • 17
1 2 3
…
59
60