On Wed, 2009-08-12 at 09:27 +0200, Frank Schönheit - Sun Microsystems Germany wrote: > 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 >
Hey Frank, Indeed, I am running 3.0.1, OOO300m15 (Build:9379) But it looks like it might be repaired in future releases, from what you have experienced. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
