Subject | Update a Highwater Value in a single Statement |
---|---|
Author | robert_difalco |
Post date | 2005-05-29T16:13:05Z |
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.
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.