Returns information about a materialized view.
Info("The data of the view was produced on " + ...
HInfoView("MyConnection", MyView, hDateLastRefresh)
Syntax
<Result> = HInfoView(<Connection> , <View> , <Requested information>)
<Result>: Character string
Requested information.
<Connection>: Character string or Connection variable
Connection to the HFSQL server that contains the materialized view. This connection corresponds to:
<View>: Character string
Name of the materialized view found on the server and for which the information is requested.
<Requested information>: Integer constant
Requested information about the specified materialized view. | |
| hDateLastRefresh | <Result> will contain the date (in YYYYMMDD format) of the last successful refresh of the view. |
| hErrorLastRefresh | <Result> will correspond to: - the error that occurred during the last refresh.
- Empty string ("") if the last refresh was successful.
|
| hRefreshInProgress | <Result> will correspond to: - 1 if the view is currently refreshed,
- 0 otherwise.
|
| hSQLCode | <Result> will contain the SQL code of the view content. |