setCurrentPosition: BEGIN ; DELETE FROM CurrentSetPosition; INSERT INTO CurrentSetPosition(pos) VALUES (:position); END;

I am using the SQLDelight Library and this does not generate the right function. There is no "position" parameter, in fact there is no parameter at all. Why is this happening

Could you try it with the transaction syntax block?

like ?

BEGIN TRANSACTION ; ...

Nope:

setCurrentPosition {
DELETE FROM CurrentSetPosition; INSERT INTO CurrentSetPosition(pos) VALUES (:position);
}

That appears to have done the trick, many thanks