GetLastWhereFromGeneralReport

Structure

GetLastWhereFromGeneralReport: String

Type

Function

Description

This function returns the WHERE clause from the most recently run GENERAL report (as created from PrintBuilder). Typically this function would be used within a script project that was created from use as a button within the General report. For example, you could select a listing of templates (GAGEDEFLIST) records in a General search/report, then upon a button press launch a script project that updates a field in all the templates. The text returns begins with the word 'WHERE' - it does not include the table name and does not include an ORDER BY.

Parameters: 0

Return Value

String

Example

sCount = ReturnFromSQL("SELECT COUNT(*) FROM GAGEDEFLIST " & GetLastWhereFromGeneralReport) |