SqlId count("COUNT(*)");
sql * Select(count).From(sqlTable).Where(PRODUKT=="prohibis");

G:\Entwicklung\UPP\prohibisZA\prohibisZA.cpp(1048) : error C2679: binary '=' : no operator found which takes a right-hand operand of type 
	'Upp::SqlVal' (or there is no acceptable conversion)
        C:\upp\uppsrc\Core/String.h(297): could be 'Upp::String &Upp::String::operator =(const char *)'
        C:\upp\uppsrc\Core/String.h(298): or       'Upp::String &Upp::String::operator =(const Upp::String &)'
        C:\upp\uppsrc\Core/String.h(299): or       'Upp::String &Upp::String::operator =(Upp::StringBuffer &)'
        while trying to match the argument list '(Upp::String, Upp::SqlVal)'
G:\Entwicklung\UPP\prohibisZA\prohibisZA.cpp(1052) : error C2668: 'Upp::SqlSelect::From' : ambiguous call to overloaded function
        c:\upp\uppsrc\sql\Sqlexp.h(454): could be 'Upp::SqlSelect &Upp::SqlSelect::From(const Upp::SqlVal &)'
        c:\upp\uppsrc\sql\Sqlexp.h(451): or       'Upp::SqlSelect &Upp::SqlSelect::From(Upp::SqlId)'
        while trying to match the argument list '(Upp::String)'
G:\Entwicklung\UPP\prohibisZA\prohibisZA.cpp(1052) : error C2228: left of '.Where' must have class/struct/union
prohibisZA: 1 file(s) built in (0:02.01), 2016 msecs / file, duration = 2047 msecs, parallelization 0%

sql * Select(count).From(KUNDEN).Where(PRODUKT=="prohibis");

sql * Select(SqlCountRows()).From(sqlTable).Where(PRODUKT=="prohibis");

Sql sql(session);
SqlId all("*");
sql * Select(SqlCountRows()).From(sqlTable).Where(PRODUKT=="prohibis");

H:\Entwicklung\UPP\prohibisZA\prohibisZA.cpp(1049) : error C2668: 'Upp::SqlSelect::From' : ambiguous call to overloaded function
        c:\upp\uppsrc\sql\Sqlexp.h(454): could be 'Upp::SqlSelect &Upp::SqlSelect::From(const Upp::SqlVal &)'
        c:\upp\uppsrc\sql\Sqlexp.h(451): or       'Upp::SqlSelect &Upp::SqlSelect::From(Upp::SqlId)'
        while trying to match the argument list '(Upp::String)'
H:\Entwicklung\UPP\prohibisZA\prohibisZA.cpp(1049) : error C2228: left of '.Where' must have class/struct/union
prohibisZA: 1 file(s) built in (0:03.63), 3635 msecs / file, duration = 3697 msecs, parallelization 0%

There were errors. (0:04.68)

sql * Select(SqlCountRows()).From(SqlId(sqlTable)).Where(PRODUKT=="prohibis");

String sqlWhere = "PRODUKT=='prohibis'";

sql * Select(SqlCountRows()).From(SqlId(sqlTable)).Where(sqlWhere);

SqlBool sqlWhere = (PRODUKT=='prohibis');

if(something_true){
    sqlWhere = sqlWhere && Like(SOME_FIELD, "a%");
}