private SQLExpressionItem ParseExpressionAccess(string expression)
{
SQLContext accessSQLContext = new SQLContext();
SQLExpressionItem accessExpression;
try
{
// set up context class to use Access syntax
accessSQLContext.SyntaxProvider = msAccessSyntaxProvider1;
accessExpression = accessSQLContext.ParseExpression(expression);
try
{
// clone parsed expression in our default context
// this converts identifiers quotation, but leave the same constants notation
if (accessExpression != null)
{
return(accessExpression.Clone(queryBuilder1.SQLContext));
}
else
{
return(null);
}
}
finally
{
if (accessExpression != null)
{
accessExpression.Dispose();
}
}
}
finally
{
accessSQLContext.Dispose();
}
}
