Hi Keith, > Why is the following query too complex to be viewed in the design mode? > > SELECT `Date`, weekday( `Date` ) AS `Weekday`, > `Precipitation` AS `Precip` > FROM `kwbo4418_WaterlooWeather2000`.`2005` AS `2005` > WHERE ( weekday( `Date` ) = '4' > OR weekday( `Date` ) = '5' > OR weekday( `Date` ) = '6' ) > AND `Precipitation` > 0
Can reproduce in OOo 3.0.1, but not in OOo 3.1, nor in DEV300m54 (the most recent dev build towards 3.2). Which version did you use? (3.1 has another problem when switching back from the graphical to the SQL view, which is fixed in m54.) Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
