Still, it should not miscalculate like that. It would probably be good to supply RBTI with a demo if you can replicate it.
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Saturday, June 21, 2008 8:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: select group by problem You got it Larry, When I looked at the keys there was a foreign key and an index (Haven't the faintest idea how that happened). I removed the index and now it is correct! Thanks, Bernie ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, June 21, 2008 9:02 PM Subject: [RBASE-L] - RE: select group by problem > << > Yes John, I just tried that and same result, first date is doubled. But > thanks for looking. Any other ideas? > Do you have a table that you could try a similar test? >>> > > Try re-indexing, or removing all indexes on the table, and see what > happens. > -- > Larry > > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
