Brad, For what it�s worth, check your form expressions. I recently shot myself in the foot with a stray column assignment which affected a sort order.
Claudine ________________________________________ 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
