Lorenz
|
| Posted: 05/21/2002, 6:42 AM |
|
Here is my query :
SELECT Year,Field1,Field2,Field3,Field4
FROM Mytable
GROUP BY Year
This is the problem :
SQL Error ... Column not found Field1
if I cancel Field1 the same happen for Field2 and so on.
I need those Fields as they are keys.
Even if I write only :
SELECT Year
FROM Mytable
GROUP BY Year
the table is so long that webpage need 30 and more seconds to charge
I'm very confused ...
|
|
|
 |
Nicole
|
| Posted: 05/21/2002, 6:50 AM |
|
Lorenz,
as I understand send sql works against db. If so, then use it in CC. Of course the page will load slow if returned recordset contain large amount of records.
BTW, lets continue one thread for this problem .
|
|
|
|
Ken Hardwick
|
| Posted: 05/21/2002, 6:50 AM |
|
Lorenz,
One potential problem is that "year" may be a reserved word and could cause problems with your sql statement.
Does "Select Field1,Field2,Field3,Field4 FROM Mytable" work ok ?
If so, you may want to rename your "year" column.
|
|
|
|
Lorenz
|
| Posted: 05/21/2002, 7:04 AM |
|
Sorry if I opened a new thread, I'm new in these things.
Ken, it's not a reserved word,and probably is as Nicole said.
Now I'm trying to modify "custom show" in form events, but it affect only the first page of the grid. I suppose I have to act in "Custom navigation", but I don't know how. 
Thank you to all!!! (again)
|
|
|
|
|
