[OT] SQL question

Malte Brill revolution at derbrill.de
Wed Nov 13 09:27:55 EST 2013


Peter wrote:

> It seems Malte is having two problems - how to conditionally update a
> column value and how to ensure everything stays locked during the update.
That was exactly the problem. One value needs to be incremented by one for the INSERT. The problem is the condition that the first value may or may not be 1, depending on an entry in another table. I got a solution now, but thanks again for putting thought into this @all!

All the best,

Malte




More information about the use-livecode mailing list