```setCurrentPosition: BEGIN ; DELETE FROM CurrentSetPosition; INSERT INTO CurrentSetPosition(pos) V...

# squarelibraries

[Vishnu Shrikar]

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

[hfhbd]

Could you try it with the transaction syntax block?

[Vishnu Shrikar]

like ?

BEGIN TRANSACTION ; ...

[hfhbd]

Nope:

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

[Vishnu Shrikar]

That appears to have done the trick, many thanks