Javier, Thanks for the info. It does indeed print in the order that the data is in the database. (Even if that isn't what I want in this situation).
I will add a separate SELECT command to get the data in the correct order for a quick print for the user after they have finished editing. Thanks for the comment on syntax. Most of the time R:Base is pretty lenient, but it is hard to know when the old rules may not hold up. Bill On Fri, Jun 10, 2011 at 11:46 AM, Javier Valencia < [email protected]> wrote: > ** > > Bill,**** > > ** ** > > TTBOMK, the data will display and print in the order in which is stored in > the database unless you specify a sort. You can always click the “Sort” > button on the browser to specify and/or clear the sort order before > printing.**** > > ** ** > > By the way, the “correct” syntax for your command would be:**** > > ** ** > > EDIT trial plotnum, sample, stand1, stand2, stand3 FROM rawdata WHERE trial > = '118732' ORDER BY plotnum ASC, sample ASC**** > > ** ** > > R:Base has been pretty lenient with old syntax, but sooner or later it > might come back to bite you...I have been there…**** > > ** ** > > Javier, > ** > ****** > > **Javier Valencia**, PE**** > > 913-829-0888 Office**** > > 913-915-3137 Cell**** > > 913-649-2904 Fax**** > > [email protected]**** > > ** ** > ------------------------------ > > *From:* **[email protected]** [mailto:**[email protected]**] *On Behalf Of > *Bill Niehaus > *Sent:* Friday, June 10, 2011 11:20 AM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Printing from data brows/edit window**** > > ** ** > > When I print from the data browser window, I get a different order of data > vs. what is displayed on the screen. The data is sorted by the first > criteria (plotnum) on the printout, but not the second criteria (sample). > If I use the menu option SORT and specify the two criteria, then it prints > in the proper order. > > R> command follows: > > EDIT trial plotnum sample stand1 stand2 stand3 FROM rawdata WHERE trial = > '118732' ORDER BY plotnum sample > > We use this option at times when we aren't too concerned with the > appearance of the output. This is in 9.1.4.10602 > > Thanks. Bill Niehaus**** >
