This is stretching, but perhaps immediately before the computation, put these two lines in your code. Ya neva no...
SET TIME SEQ HHMMSS SET TIME FORMAT HH:MM:SS SELECT ... "Alastair Burr" <[EMAIL PROTECTED]> wrote: >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/ >> > > -- 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/
