SQLITE UPDATE QUERY NOT WORK FOR ME

Database & APIs

Hello, I am trying to do a project on sqlite in flutterflow. I know how to use supabase and firebase, but since I have a lot of data in my dataset, I chose this method to make it less costly. Also, reading is very fast in sqlite, which is why it works for me.

Everything is perfect in reading my data in sqlite tables in flutterflow, but I am having problems with adding, deleting or updating data. When I try it on sqlite, the codes that work, do not work when I try it as a flutterflow query. I think the reason for this is that I cannot match the "id" of the data with the queries.

For example, I created currentID in appstate. I could not figure out how to match this with the id of my own data in the update sqlite action, can you help me?

What have you tried so far?

Hello, I am trying to do a project on sqlite in flutterflow. I know how to use supabase and firebase, but since I have a lot of data in my dataset, I chose this method to make it less costly. Also, reading is very fast in sqlite, which is why it works for me.

Everything is perfect in reading my data in sqlite tables in flutterflow, but I am having problems with adding, deleting or updating data. The codes that work when I try them on sqlite do not work when I try them as flutterflow queries. I think the reason for this is that I cannot match the "id" of the data with the queries.

For example, I created currentID in appstate. I could not figure out how to match this with the id of my own data in the update sqlite action, can you help me?

I have watched all the content I could find so far, but I could not figure it out. They said that sqlite does not work very efficiently on FF, could this be because of this?

Did you check FlutterFlow's Documentation for this topic?
No