On Tuesday 07 October 2008 14:48, Marc Mamin wrote:
> maybe you try to retrieve the value of grade with an inappropriate
> method ?
I use the getFoat Method. Here is the code:
// Query grade data:
float result = 0;
ResultSet gradeData = dbHelper.queryUserWorksheetGrade(userId, worksheetId);
if ( !gradeData.next() )
this.logDebug("### DEBUG 1 ### Result set empty");
else
{
result = gradeData.getFloat(DbColumn.GRADE);
if ( gradeData.wasNull() )
this.logDebug("### DEBUG 2 ### Column was SQL NULL");
}
In the logs I see: "### DEBUG 2 ### Column was SQL NULL"
In earlier tries, I experimented with different types for "result" (double,
String). I also casted on the SQL side to "double precision" before
multiplying und summing. No effect.