HomeActive Query BuilderCreate a custom Syntax Provider

Create a custom Syntax Provider


In order to support Teradata SQL I have created a custom SyntaxProvider.

#1
I understand
Get1ParamAggregateNames
GetPrefixed1ParamAggregateNames
but what does
GetStarAggregateNames
need to return?

#2
I see the function
GetBuiltinFunctionNames
but I do not see any place in the UI that displays function names for the user to select.
Is this override required only if I plan to use your syntax validation function? (I don't)

#3
I need to add support for
Select Distinct
Select All
Select Top n [percent] [with Ties]
Select And Consume
This requires adding a Properties dialog.
How do I add/activate the dialog, and then how do I use the data that was entered through the dialog?
Do I create the dialog myself or do I override an existing dialog?

#4
Is there a way to add support for statement, or From, prefixes?
Teradata [like DB2] supports temporal data.
This adds optional prefixes such as
Validtime Select ...
TransactionTime Select ...
As Of 2011-09-01 Select
Select ... From ValidTime Table1
Select ... From TransactionTime Table1
etc.
(Note that your DB2SyntaxProvider does not seem to support this either. It was added in DB2 9.5 or 9.7)

Thanks
Mike Dempsey | email
January 30 2012, 04:11 PM
It's not a support ticket system. It's a forum. I will move your post to STS as I don't think that other users may benefit from it. I will answer shortly.
Sergey Smagin | email
4 hours, 42 mins since original post
This topic is closed