HomeActive Query BuilderIs there support for using custom functions?

Is there support for using custom functions?


We currently use the Active Query Builder in an ad hoc query tool that connects to our ODBC/OleDb driver. The driver currently supports ANSI 92 SQL plus additional functions such a TSQL and custom sql functions. Does the active query builder have the ability to customize a list of recognized built-in functions?

Thanks,
Brian
Brian | email
September 23 2011, 01:24 PM
The list of built-in functions is defined in the syntax provider. You may override it by inheriting from one of existing syntax providers.

class CustomSytnaxProvider : MSSQLSyntaxProvider
{
public override void GetBuiltinFunctionNames(SQLQualifiedNameList names)
{
names.AddBuiltin("Function1");
names.AddBuiltin("Function2");
}
}
Sergey Smagin | email
2 days, 17 hours since original post
This topic is closed