|
|
|
|
|
|
|
|
HDropView (Function) In french: HSupprimeVue Removes a materialized view from the HFSQL server.
// Create a materialized view on a server
IF NOT HUpdateView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
// Refresh the materialized view on the server
IF NOT HRefreshView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
// Remove the materialized view from the server
IF NOT HDropView(MyConnection1, MyMaterializedView) THEN
Trace(HErrorInfo())
END
Syntax
<Result> = HDropView(<Connection> , <View> [, <Cascading deletion>])
<Result>: Boolean - True if the operation was performed,
- False if a problem occurs. HErrorInfo is used to identify the error.
<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 to handle (present on the server). <Cascading deletion>: Optional boolean - True to enable cascading deletion,
- False (default value) otherwise.
Remarks If the materialized view does not exist, the function returns a non-fatal error. Business / UI classification: Business Logic
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|