[RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm

[Brad Davidson]

Javier,   I’ve set default vstartdate and venddate ‘s to current month: 11/1/04 and 11/30/04.   Most recent date in dataset is 11/10/04, yet, scrolling region does not display the 11/10/04 dataset, rather begins with 11/9/04. This is consistent (prod_date) with any venddate value between 11/1/04 and 11/30/04. I’ve also entered in dummy data for October and December – no difference in the anomaly.   Thanks for any other ideas on this!   -Brad   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Thursday, November 11, 2004 7:33 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm   Brad: What is the value for venddate? What is the most recent date in your data set? Any chance that the most recent date in your data set is more recent (larger) than venddate and it is not being selected by your clause? Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Brad Davidson Sent: Thursday, November 11, 2004 9:19 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region Sort Order Descending Pblm     Bld 78: Have a single table form with scrolling region and 2 DBEDITs: Prod_Date (date) and Prod_Count (int).   Upon entry to form: EDI USING produced WHERE prod_date BETWEEN .vstartdate AND .venddate ORDER BY prod_date DESC   The last prod_date (most recent date) row does not appear, rather, 2nd to most recent date.   Yet, when ordering by ASC shows all rows within where clause.   On After Start form eep:   IF vrcode = 1 then    PROPERTY VL_VPRODTXT VISIBLE 'FALSE'    PROPERTY DB_PROD_DATE SET_FOCUS 'TRUE'  ENDIF    IF vrcode <> 1 then    PROPERTY OB_DISCARD VISIBLE 'FALSE'    PROPERTY DB_PROD_DATE SET_FOCUS 'TRUE'    PROPERTY TABLE PRODUCED 'APPEND'  ENDIF    RETURN   Removing above form eep makes no difference in order by DESC behavior described.   It’s gotta be something basically wrong in my form design/syntax, as cannot duplicate similar querry and order by DESC in concomp (ScrollingRegEnter form, edi using… order by LastOrderDate=D).   Any ideas? Thanks!   -Brad Davidson   Can’t duplicate in Concomp