ExpressionStore.DeleteExpression
Use this method to delete an existing expression from the expression store.
Definition
Sub DeleteExpression(nExprID As Long,flags As Long)
Parameters
nExprID
[in] A Long that specifies the expression to be deleted.
flags
[in] A Long that contains the optional control flags. This parameter is currently unused and should be set to zero (0).
Return Values
None.
Error Values
This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to either standard or custom COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors.
The following table shows the custom COM errors that this method can return.
Constant | Value | Description |
E_EXPR_BADCONNECTION | &H8110001F | Invalid connection |
E_EXPR_BADEXPRID | &H8110000A | Invalid expression ID specified, or expression ID not found in store |
E_EXPR_EXPRDELFAILED | &H81100010 | Delete operation failed, possibly due to other expressions having dependencies on this expression |
E_EXPR_NOCONNECTIONSTRING | &H8110000D | No connection string specified |
Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
If the specified expression has a non-zero reference count, meaning that other expressions depend on the specified expression, the expression is not deleted.
Call the Connect method before calling the DeleteExpression method.
Example
' oExpressionStore is an ExpressionStore object connected to
' a valid expression store.
' 59552 is a valid expression ID retrieved by the GetExprID method.
oExpressionStore.Delete(59552, 0)