Frank Schönheit - Sun Microsystems Germany wrote: > forgot to add: > >> You can use all those functions in the graphical designer, too. The >> reason they don't appear in the "Function" list is that this list >> contains aggregate functions only. > > Of course we could see this is the root of the problem: To the user it > isn't really clear why the list contains aggregate functions only, it > would easily also be possible to add all other functions, too, wouldn't it? > Somebody here recently said the query designer is somewhat ... stone-aged. > > Ciao > Frank >
Danke, Frank! I see more clearly now. It would be possible to add all the other functions, BUT there is a reason why the aggregate functions are separated. When using aggregates, all the selected fields need to be aggregated by one of the functions or they have to be collected in the GROUP BY clause, since all selected fields require a specific method to "fit into the shrinked recordset". This does not apply to the other functions, which simply do something to every single value of the field in the recordset without affecting the record count. Because there are no aggregates for "simple sources" I concluded wrongly that there are no functions at all. This error message could have been another reason for my mistake: > SQL Status: HY000 > > Statement to complex. Only "COUNT(*)" is supported. > The SQL command leading to this error is: > > SELECT SUM( "BETRAG" ) FROM "List" (Source was dBase) Only COUNT(*) is supported. Mmmmh. Greetings, Andreas Säger --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
