ExprFltrQueryBldr.ConvertExprToSqlFltrStr
.gif "Ee824791.c++_on(en-US,CS.10).gif")
.gif "Ee824791.vb_off(en-US,CS.10).gif")
Use this method to convert an expression in Extensible Markup Language (XML) form to a SQL filter query string.
Definition
Function ConvertExprToSqlFltrStr(pExpression As String) As String
Parameters
pExpression
A String that contains the expression in XML form.
Return Values
If this method completes successfully, it returns a String that contains the SQL filter string.
Error Values
This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to standard COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
For more information about memory ownership issues related to COM property and method parameters, see Managing COM Parameter Memory.
Example
' sXMLExpr and sSqlFilter are Strings.
' Note that the sXMLExpr string is not properly formatted with respect
' to quotation marks or continuation to increase readability.
sXMLExpr = "<CLAUSE OPER="at-least">
<PROPERTY ID="user.age" TYPE="number"/>
<IMMED-VAL TYPE="number">80</IMMED-VAL>
</CLAUSE>"
sSqlFilter = oExprFltrQueryBldr.ConvertExprToSqlFltrStr(sXMLExpr)
' The resulting sSQLFilter string is: user.age >= 80.