Whou.. !!   many thanks Razzak and Adrian
You are the best !
R:egards,
Daniele


----- Original Message ----- From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, June 30, 2009 1:31 PM
Subject: [RBASE-L] - Re: Sort a slave table in a form


At 02:23 AM 6/30/2009, R:Daniele wrote:

How can I sort a slave table (scrolling region in a FORM)
by colname1 when colname1 is not a commun column?


Daniele,

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:

Database: RRBYW15
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 +
ORDER BY Company WHERE CustState = 'PA'
RETURN
-- End

-- Example 02:

Database: RRBYW15
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 = 'PA' +
OPTION SCREEN|WINDOW_STATE MAXIMIZED +
|ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90
RETURN
-- End

Very Best R:egards,

Razzak.

--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]

(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================




Reply via email to