And it is really handy, too. I use it often, particularly to modify a
copy of a form for a different purpose.
Albert
On 27/06/2013 7:40 PM, A. Razzak Memon wrote:
At 03:46 PM 6/27/2013, Dan Goldberg wrote:
That is way cool! I learned something today.
I'm glad!
In addition you can also use [Ctrl]+[L] key combination to search for
specific text defined within the properties of any object for the
connected database.
The functionality to search for text within Control Properties allows
users to locate Component IDs, hints, text captions, columns listed
in WHERE Clauses for Lookup controls, and also pop-up menus. Any text
defined within a form, report, or label control will be used in the
search.
When searching for text within Control Properties, text strings can
be located within the following modules:
Forms
Reports
Labels
External Forms
Have fun!
Very Best R:egards,
Razzak.
-----Original Message-----
From: A. Razzak Memon
Sent: Thursday, June 27, 2013 8:44 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Search variable list of all forms / reports
indatabase
At 11:29 AM 6/27/2013, Lawrence Lustig wrote:
>Is there any way to search the variable lists across all forms and
>reports in a database?
>
>I'm considering redefining some columns from REAL to DOUBLE (I know,
>but I didn't create the database) and would need to identify forms
>which treat those columns as REAL when setting variables. I'd like
>to identify any forms and reports that declare (in their variable
>list) any variables of type REAL.
IF you are using the R:BASE eXtreme 9.5 (32/64), you may search for
specific text that may be defined in Form, Report, and/or Label
expressions?
If you know the column name with REAL data type used in expressions,
you may use the "Find in Expressions" option.
The "Find in Expressions" feature opens a search utility to locate
specific text defined within the form, report, and label expressions
for the connected database. The functionality to search for text
within expressions allows users to locate specific columns, tables,
functions, variables, and any part of a WHERE Clause.
Any text defined within an expression will be used in the search!
Here's how:
When searching for text within expressions, text strings can be
located within the following modules:
. Forms
. Reports
. Labels
To begin searching, press the [Ctrl]+[Shift]+[F] key combination
to display the "Find in Expressions" dialog.
http://www.razzak.com/tips/FindInExpressions.jpg
Searching for text can include all listed items displayed at the
Database Explorer, or just a selected few. For example, selecting
fifteen out of fifty reports, and then pressing [Ctrl]+[Shift]+[F]
will search for the text for all expressions within the fifteen
selected reports.
Note: The "Find in Expressions" dialog can only be launched from
the Database Explorer.
After the search is complete, a list of reports and defined variable
expressions that match the search will be displayed.
http://www.razzak.com/tips/FindInReportExpressions.jpg
The search results will contain the tables(s) and expressions that
match the search criteria. The variable expression can be launched
within a dialog window for editing by double clicking on it, or by
selecting the "Edit..." button. The search results can be saved to
several output formats. The "Expand All" check box allows the list
of expressions in the search results to expand for full viewing.
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3345 / Virus Database: 3204/6445 - Release Date: 06/27/13
