Bernie Did you by chance check the setting for the idquotes? Just a thought.
Buddy -----Original Message----- From: [email protected] To: RBASE-L Mailing List Sent: Fri Apr 25 11:38:52 2008 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 > > >
