Hi Albert, No change in ZERO setting and it's defined at start-up anyhow as on and all rows have a value (no nulls) with 0:00:00 the default. I just tried it with zero set to off and it still fails.
All I can think of is that some limit is being reached in the calculation. The average is 1:16:17 for the 446 rows selected. That is a total of 2,041,342 seconds which doesn't look particularly significant in any way. Thanks anyway, Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 7:41 PM Subject: [RBASE-L] - RE: Select AVG INTO v Compute > Have you changed your SET ZERO ON/OFF since the last time it worked? > SET ZERO ON and see if the problem disappears. If so, then either leave it on, as I do, or try one of these: > -- Only look at rows that actually have times in them > ... WHERE Walk_Time IS NOT NULL > > -- If there is no time entered, time is zero > select AVG(IFNULL(Walk_Time,0,Walk_Time)) ... > > "Alastair Burr" <[EMAIL PROTECTED]> wrote: > > >This command has worked for well over a year: > > > >select AVG(Walk_Time) into vTotTime from Walk_Data where Route_ID NOT IN > >(14, 31) > > > >It stopped working a few days ago, on the 13th. If I add "and Walk_Date < > >13/02/2003" it's fine as it is if I use "and Walk_Date > 09/10/2001". > > > >I assume that the data is okay because, one way or the other, all of it can > >be used - and I can't see anything wrong. I have reloaded the database as > >well. The number of rows being selected is 437 with the ">" or 438 with the > >"<" than clauses. > > > >This, however, does work: > > > >compute vTotTime AS AVG(Walk_Time) from Walk_Data where Route_ID NOT IN (14, > >31) > > > >It is, therefore, not a problem as there is a work-around but does anybody > >have any idea why the select does not work? Is the any limit on the number > >of rows selected for a calculation? > > > >Thanks in advance for any help, > >Regards, > >Alastair. > > > >---------------------------------- > >A D B Burr, > >St. Albans, UK. > >---------------------------------- > >[EMAIL PROTECTED] > >---------------------------------- > > > > > > > -- > Albert Berry > Full Time Consultant to > PSD Solutions > 350 West Hubbard, Suite 210 > Chicago, IL 60610 > 312-828-9253 Ext. 32 > > > __________________________________________________________________ > The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ >
