Replace Query With Temp

inverse of ReplaceTempWithQuery

See IntermediateValues


Example Usage:

The Crystal Report OCX control (typically used in VisualBasic under MicroSoft Windows) has a function "FetchSelectionFormula?()" which, for some reason, takes several seconds to execute. Each call takes several seconds to execute, even if it's called several times in a row. It returns a string -- the "where" clause of the query for the report, so I optimized our function that customizes this where clause by introducing a local String variable; we now work on the local string before calling "ReplaceSelectionFormula?()" with our final result. This change made simple one page reports display about twice as fast. -- JeffGrigg


CategoryRefactoring


EditText of this page (last edited June 20, 2003) or FindPage with title or text search