Ok, Bernie - I think since so many of us are mulling this over thinking how strange this is, that perhaps your RB1 file is corrupted.
Have you tried just unloading the structure and data for the one table to a new database to see if it works there? And if it does, I'd do an UNLOAD/RELOAD of your database. Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Friday, April 25, 2008 10:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Group by -- need another set of eyes Hi James, CRED is a table. It contains CreditAmount curr and CreditDate date But thanks for looking. Bernie ----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, April 25, 2008 10:33 AM Subject: [RBASE-L] - Re: Group by -- need another set of eyes > Bernie, > > Do my eyes deceive me but is CRED defined as two different data > types: > > CRED Type : DATE > CRED Type : CURRENCY > > If so that should be a no no! > --- Bernard Lis <[EMAIL PROTECTED]> wrote: > >> Hi Bill, >> I hope you can discern something from this: >> ----- Original Message ----- >> From: Bill Downall >> To: RBASE-L Mailing List >> Sent: Thursday, April 24, 2008 8:15 PM >> Subject: [RBASE-L] - Re: Group by -- need another set of >> eyes >> >> >> Bernie, >> >> What do you get if you try these: >> >> SELECT DISTINCT CreditDate FROM Credits >> CreditDate There are lots more going back to 1992 these >> are the last few >> ---------- >> 12/23/2007 >> 01/27/2008 >> 02/17/2008 >> 02/24/2008 >> 03/23/2008 >> 03/30/2008 >> >> >> SELECT CreditDate, COUNT (*) FROM Credits GROUP BY >> CreditDate >> CreditDate COUNT (*) >> ---------- ---------- >> 12/23/2007 39 >> 01/27/2008 28 >> 02/17/2008 25 >> 02/24/2008 44 >> 03/23/2008 21 >> 03/30/2008 33 >> >> SELECT CreditDate FROM Credits GROUP BY CreditDate >> CreditDate >> ---------- >> 12/23/2007 >> 01/27/2008 >> 02/17/2008 >> 02/24/2008 >> 03/23/2008 >> 03/30/2008 >> >> Do you get the doubled dates any of those ways? NO >> >> Also, just in case all those extra eyes might see something, >> please show the results of: >> LIST COLUMN CreditDate >> list col creditdate >> Column Name Table Name Attributes >> ------------------ ------------------ >> --------------------------------------- >> CreditDate Credits Type : DATE >> >> Index : >> SINGLE-COLUMN >> Comment: date of >> transaction >> CRED Type : DATE >> >> LIST COLUMN CreditAmount >> list col creditAmount >> Column Name Table Name Attributes >> ------------------ ------------------ >> --------------------------------------- >> CreditAmount Credits Type : CURRENCY NOT >> NULL >> Comment: dollar >> amount of transaction >> CRED Type : CURRENCY >> >> >> >> LIST TABLE Credits >> list table credits >> >> Table: Credits No Lock(s) >> Descr: Credit transactions >> >> No. Column Name Attributes >> --- ------------------ >> ------------------------------------------------------ >> 1 CreditRefNo Type : INTEGER NOT NULL >> AUTONUMBER >> Consrnt: PRIMARY KEY >> >> Comment: Reference no >> >> 2 OrderNo Type : INTEGER >> >> Consrnt: FOREIGN KEY REFERENCES >> OrderHeader >> Comment: order number >> >> 3 CustomerNo Type : INTEGER >> >> Consrnt: FOREIGN KEY REFERENCES >> Customer >> Comment: customer number >> >> 4 CreditDate Type : DATE >> >> Index : SINGLE-COLUMN >> >> Comment: date of >> transaction >> 5 AccountNo Type : TEXT 4 >> >> Comment: account number >> >> 6 CreditAmount Type : CURRENCY NOT NULL >> >> Comment: dollar amount of >> transaction >> 7 CreditComment Type : TEXT 30 >> >> Comment: comment >> >> 8 CreditUser Type : TEXT 18 >> >> Comment: last modified by >> >> 9 CreditDateTime Type : DATETIME >> >> Comment: date/time last >> modified >> Current number of rows: 9420 >> >> >> SHOW DATE >> SHOW ZERO >> SHOW NULL >> >> R>show date >> DATE format mm/dd/yyyy >> DATE sequence MMDDYY >> Century threshold YEAR is 50 >> Default CENTURY is 19 >> >> R>show zero >> (ZERO ) ON Treat nulls as ZERO in numeric calculations >> >> R>show null >> NULL symbol >> >> Bill >> >> >> >> >> On Thu, Apr 24, 2008 at 4:56 PM, Bernard Lis >> <[EMAIL PROTECTED]> wrote: >> >> Right on John, but for the record CreditDate is not >> indexed. >> ----- Original Message ----- From: "John Engwer" >> <[EMAIL PROTECTED]> >> To: "RBASE-L Mailing List" <[email protected]> >> Sent: Thursday, April 24, 2008 10:23 AM >> Subject: [RBASE-L] - Re: Group by -- need another set of >> eyes >> >> >> >> Larry, he created a temp table and ran the select from >> the temp table. That >> should have eliminated the index possibility. >> >> John >> >> -----Original Message----- >> From: [email protected] [mailto:[EMAIL PROTECTED] On >> Behalf Of Lawrence >> Lustig >> Sent: Thursday, April 24, 2008 9:56 AM >> To: RBASE-L Mailing List >> Subject: [RBASE-L] - Re: Group by -- need another set of >> eyes >> >> Bernie: >> >> I'll bet dollars to donuts this is an indexing issue. >> >> Is CreditDate indexed? If so, try dropping the index >> and repeating the >> command (which will run more slowly). In fact, try >> projecting a completely >> unindexed copy of the table and operating on that. >> >> Also, look for CreditDate used in a multi-column index. >> >> -- >> Larry >> >> >> >> >> > === message truncated === > > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > > ____________________________________________________________________________ ________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > >
