Razzak, Deleted constraint, then re-assigned new key to the prod_date column and voila, sorts in descending order just fine!
Interesting, in that over past couple of days we've unloaded and 're-loaded' (schema, indexes recreated) the entire DB and yet did not receive errors... Anyway, all is fine, now - thanks to your tip. Thank you! -Brad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Thursday, November 11, 2004 3:08 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm Brad, In your earlier post, you mentioned that you cannot duplicate that in ConComp sample database. So, what is different about your database or DATE column type? Is the date column INDEXed? Try PACK INDEX FOR tablename and see what happens. If it still reveals the same results, then send me that database and I would love to see what else is going on. Very Best R:egards, Razzak. At 09:52 AM 11/11/2004 -0800, Brad Davidson wrote: >Hi Razzak, > >Interesting! Matching the date format settings suggested get the same >anomaly in select command for DESC order, only - ASC order returns all >values. > >Vstartdate = 11/01/2004 >Venddate = 11/30/2004 >Most recent date for prod_date is 11/10/2004. > >SELECT prod_date FROM produced WHERE + >prod_date BETWEEN .vstartdate AND .venddate ORDER BY prod_date DESC > >Descending query returns values for prod_date beginning with 11/09/2004, >omitting the 11/10/2004 entry. > >Ascending order correctly returns values 11/01/2004 through 11/10/2004. > >-Brad > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak >Memon >Sent: Thursday, November 11, 2004 8:23 AM >To: RBG7-L Mailing List >Subject: [RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm > > >At 07:56 AM 11/11/2004 -0800, Brad Davidson wrote: > > >I've set default vstartdate and venddate is to current month: 11/1/04 and > >11/30/04. > >Brad, > >What happens when you SORT those dates using the simple >SELECT command at the R> prompt: > >Example: > >SELECT datecolumn FROM TableViewName WHERE ... + >ORDER BY datecolumn ASC > >OR > >SELECT datecolumn FROM TableViewName WHERE ... + >ORDER BY datecolumn DESC > >Does that command display the dates accordingly? > >On a side note, what are your database DATE FORMAT, >SEQUENCE, YEAR and CENTURY SETtings? > >Try the following settings and see what you get. > >DATE FORMAT: MM/DD/YYYY >DATE SEQUENCE: MMDDYY >Century Threshold YEAR: 30 >Default CENTURY: 19 > >Hope that helps! > >Very Best R:egards, > >Razzak.
