ExpressionEval.LoadAll
Use this method to pre-compile all expressions in the expression store. Each expression that pre-compiles correctly is loaded into the expression cache.
Definition
Sub LoadAll()
Parameters
None.
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_BADARGTYPE | &H81100018 | Argument datatype infomation missing from expression, or unrecognized argument data type encountered in expression |
E_EXPR_BADARGVALUE | &H81100022 | Invalid expression argument value, or impossible conversion |
E_EXPR_BADCLAUSE | &H81100016 | Invalid clause encountered |
E_EXPR_BADCONNECTION | &H8110001F | Invalid connection |
E_EXPR_BADOPER | &H81100017 | Operator missing, unrecognized operator encountered, or type mismatch |
E_EXPR_BADTERM | &H81100015 | Term type missing, or unrecognized term type encountered |
E_EXPR_BADXML | &H81100014 | An unrecognized XML element was encountered |
E_EXPR_NOCONNECTIONSTRING | &H8110000D | No connection string specified |
E_EXPR_XMLPARSE | &H81100013 | XML DOM object parsing error |
Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
Any expressions in the expression cache at the time of the call are reloaded.
If there are many expressions in the expression store, the LoadAll method may be slow. Use the LoadExpr method to load only specific expressions into the expression cache.
For every expression loaded into the expression cache, the LoadAll method increments the read-only ExprCount property by one (1).
Use the FlushAll method to remove all expressions from the expression cache.
The Connect method must be called before using the LoadAll method.