Probleam in dataset [message #152752] |
Tue, 16 May 2006 14:09 |
Jayanta Messages: 22 Registered: July 2009 |
Junior Member |
|
|
Hi
This is my query
It done well in mysql But error in birt dataset query
/************************query****************************** ****/
SELECT
.course.course_name,
.course_creation_details.date_created,
count(.userscoinfo.SCOID)
FROM course,course_creation_details,userscoinfo
WHERE
.userscoinfo.CourseID=.course.course_id and
.course_creation_details.course_id=.userscoinfo.CourseID
GROUP BY .userscoinfo.CourseID
/*********************************************************** *********/
/**************ERROR**************************************** ***/
Cannot get the decimal value from column(3).
Cannot get BigDecimal value in result set
Reason:
A Birt exception occured.
/*********************************************************** ***/
Plz reply
|
|
|
Powered by
FUDForum. Page generated in 0.07171 seconds