February 20, 2006
From the Edge: Understanding Enhanced BROWSE Command
Section: Enhanced Commands
Chapter: Running R:BASE Your Way!
Platform: R:BASE 7.5 and V-8 Turbo for Windows
Builds: R:BASE 7.5 (7.5.24.30214 or higher)
R:BASE V-8 Turbo (8.0.12.30214 or higher)
Among many new features, commands and functions, R:BASE 7.5 and
V-8 Turbo for Windows also includes the enhanced BROWSE command.
An additional OPTION parameters have been implemented to provide
users and developers the ability to MAXIMIZE, NORMALIZE, MINIMIZE,
put a custom CAPTION for the displayed Data Browser/Editor Window,
and even to display the browser data as one row.
These enhanced BROWSE command parameters are supported at the R>
Prompt, in a Command File, EEP as well as when used in Stored
Procedure/Triggers.
-- Example 01: To start Data Browse/Editor as maximized window
BROWSE ALL FROM tableview WHERE clause ORDER BY clause +
OPTION WINDOW_STATE MAXIMIZED
-- Example 02: To start Data Browser/Editor as normal window
BROWSE ALL FROM tableview WHERE clause ORDER BY clause +
OPTION WINDOW_STATE NORMAL
-- Example 03: To start Data Browser/Editor as minimized window
BROWSE ALL FROM tableview WHERE clause ORDER BY clause +
OPTION WINDOW_STATE MINIMIZED
-- Example 04: To start Data Browser/Editor as maximized window
-- and Read-Only mode
BROWSE ALL FROM tableview WHERE clause ORDER BY clause NOCHG +
OPTION WINDOW_STATE MINIMIZED
-- Example 05: To start Data Browser/Editor as maximized window
-- and No Query By Example mode
BROWSE ALL FROM tableview WHERE clause ORDER BY clause NOQBE +
OPTION WINDOW_STATE MINIMIZED
-- Example 06: To start Data Browser/Editor as maximized window
-- with caption as "Customer Data"
BROWSE ALL FROM tableview WHERE clause ORDER BY clause +
OPTION WINDOW_STATE MAXIMIZED|CAPTION Customer Data
-- Example 07: To start Data Browser/Editor as Vertical Row
with caption as "Customer Data"
BROWSE ALL FROM tableview WHERE clause ORDER BY clause +
OPTION WINDOW_STATE MAXIMIZED|CAPTION Customers Data|ROWVIEW ON
-- Example 08: To start Data Browser/Editor as MDI (modeless window)
BROWSE ALL FROM tableview WHERE clause ORDER BY clause MDI
A PDF version of this article is also available at:
From The Edge: http://www.razzak.com/fte
(Powered by R:WEB Suite 3.0)
Enjoy and make sure to have fun!
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.
================================================
