That is way cool! I learned something today. Dan Goldberg
-----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! --
