Alastair Are there any nulls in Walk_Time that just started being inserted. I have had problems this way in the past when doing sel v/c compute. Had to make sure there was an actual value or a default value in these cases.
This was highlighted when we had problems with operators not entering data when they should have been. Steve Breen CDI Services, Inc. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > Of Alastair > Burr > Sent: Wednesday, February 19, 2003 10:28 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Select AVG INTO v Compute > > > 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] > ----------------------------------
