U++ forum: Welcome to the forum

Re: Simple SQL question [message #31479 is a reply to message #31475]

Sat, 05 March 2011 15:11

koldo
Messages: 3437
Registered: August 2008

Senior Veteran

Thank you Mirek

Yes, there is a problem in operator| for sqlite. The fix would be in SqlVal.cpp:

SqlVal operator|(const SqlVal& a, const SqlVal& b) {
	return SqlVal(a, SqlCase(ORACLE, " || ")(PGSQL, " || ")(SQLITE3, " || ")(" + "), b, SqlS::MUL);		// Added (SQLITE3, " || ")
}

In addition, please could you add function coalesce?. The functions could be:

SqlVal Coalesce(const SqlVal& exp1, const SqlVal& exp2) {
	return SqlFunc("coalesce", exp1, exp2);
}

SqlVal Coalesce(const SqlVal& exp1, const SqlVal& exp2, const SqlVal& exp3) {
	return SqlFunc("coalesce", exp1, exp2, exp3);
}

SqlVal Coalesce(const SqlVal& exp1, const SqlVal& exp2, const SqlVal& exp3, const SqlVal& exp4) {
	return SqlFunc("coalesce", exp1, exp2, exp3, exp4);
}

It is compatible with at least sqlite, mysql, postgre, oracle ans sql server.

Best regards
Iñaki

Report message to a moderator