Subject Update a Highwater Value in a single Statement
Author robert_difalco
This is a simple question that has me stumped. I know I can do this in
a single statement:

UPDATE Stat SET Stat.count = State.count + 1
WHERE Stat.id = 10;


But how do I do this:

UPDATE Stat SET
Stat.count = State.count + 1,
Stat.maxValue = NUMERIC_MAX( Stat.maxValue, 200 )
WHERE Stat.id = 10;

I know there is no NUMERIC_MAX function in FB 1.0.3, so I am only
using it as an example. Think of it as a C max() function or java
Math.max() method.

Sorry for asking such a simple question, couldn't find anything
googling around and searching in these forums; well I only have
patience if search results are found in the first few thousand messages.

TIA,

R.