Oh wow, it seems using RETURNING _id; at the end of my insert statements was breaking the Flow refresh 😮
adte
04/08/2023, 3:29 PM
Actually I tried this method:
Copy code
insertThing {
INSERT INTO ...;
SELECT last_insert_rowid();
}
and the Flow refresh also doesn't work. So it seems for the auto refresh to work I need to have a function call that inserts and does not return any data. Is that by design? I totally didn't figure it out until now