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

[Brad Davidson]

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