At 05:10 PM 11/30/2009, Tommy Croker wrote:
I forgot the syntax to order the data in a scrolling region. I remember something about an ARRANGE BY command but I can't find anything in the help file. Can somebody please send me the syntax and where it should be run?
Tommy, If you have a form with slave tables and a report with sub-reports, and if you wish to sort the matching rows related to slave table(s) /sub-report(s), you'll need to use the ARRANGE BY clause to achieve your goal. ARRANGE tablename BY columnlist sorts the rows displayed by a form's or report's lower-level tables. Each lower-level table in the form or report that you want to sort requires its own ARRANGE clause. You can specify up to twenty-five tables to ARRANGE and up to five columns in each table on which R:BASE will sort. -- Example 01 (Forms with Slave Tables) Database: RRBYW16 Sample Form: SalesTransactions Associated Tables (5): . Customer (Master) . InvoiceHeader (Slave 1) . InvoiceDetail (Slave 2) . Employee (Slave 3) . Contact (Slave 4) Command: -- Begin EDIT USING SalesTransactions + ARRANGE InvoiceHeader BY TransID, + ARRANGE InvoiceDetail BY ItemNum, + ARRANGE Employee BY EmpLName,EmpFName + ARRANGE Contact BY ContLName,ContFName + WHERE CustState = 'CA' ORDER BY Company RETURN -- End Example 02: (Reports and Sub-Reports) Database: RRBYW16 Sample Report with Sub-Report: CustomerContacts Associated Tables (2): . Customer (Master) . Contact (Slave 1) Command: -- Begin PRINT CustomerContacts + ARRANGE Contact BY ContLName,ContFName + ORDER BY Company WHERE CustState = 'CA' + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90 RETURN -- End Very Best R:egards, Razzak.
