Skip to content
Advertisement

Tag: flutter

Converting image files to VARBINARY(max) in flutter

I need to store images that are captured using “image picker” in a SQL server database now, I know that the images should be stored in a “VARBINARY” datatype. I tried to convert the XFile “image” that I got from the “ImagePicker()” to VARBINARY and these are the steps I made. and then I store the image in the database

How do I select and count records less than 1 year old?

I’m using sqflite in my Flutter application. In this example, date is the actual date(10.06.2021) and DATUM is the datafield in the DB. I keep getting this syntax error: E/SQLiteLog(30657): (1) near “.2021”: syntax error in “SELECT COUNT (*) FROM Shisha_table WHERE (YEAR(10.06.2021) – YEAR(DATUM)) = 1” Answer There is no YEAR() function in SQLite. The logic of your code

Flutter Insert data into the database sqflite

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

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 added all the variables, that

How to use relational database with flutter [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 1 year ago. Improve this question I’m currently making an app using Flutter. Now I really want the database to be SQL based and not NoSql like Firebase. What could

Advertisement