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!
--
