dang
Posts: 11
|
| Posted: 03/21/2008, 12:57 AM |
|
Hi
I'm doing something very simple: Creating a view that Sum few fields in a table. The view is stored as in MySql 5.0.25 database. If I do a check all records are well Sum. So far, so good.
In CCS 3.2.0.4, I generate a grid that will display all those records. But when I execute the webpage, no records is shown.
In the view procedure, I remove all the Sum and let just the normal fields. Recompile the view and execute again the same web page. It work well.
Conclusion: It seems there is a problem with CCS when adding function into view.
It's seems odd for me that CCS could not display that.
Below, the Sql view:
CREATE ALGORITHM=UNDEFINED DEFINER=abc_user@% SQL SECURITY DEFINER VIEW new_view AS
select
t.dataid AS dataid,
t.datano AS datano,
sum(t.datapj) AS sumdatapj
from
t
group by
t.dataid,t.datano;
By removing the line with «Sum» it's work well.
Does anybody have a clue how to solve this problem?
_________________
Dan |
 |
 |
|
