TheStorageUtilities..::..ValidateGroupByClause Method

Validates a 'GROUP BY' SQL clause and returns a fixed clause that correlates with the column filter if possible. If invalid, returns an empty string.

Namespace: nsCDEngine.Engines.StorageService
Assembly: C-DEngine (in C-DEngine.dll)

Syntax

public static string ValidateGroupByClause(
	string pGRP,
	string pCFI,
	string pUID,
	string[] pAggregateFunctions
)

Public Shared Function ValidateGroupByClause ( _
	pGRP As String, _
	pCFI As String, _
	pUID As String, _
	pAggregateFunctions As String() _
) As String

public:
static String^ ValidateGroupByClause(
	String^ pGRP, 
	String^ pCFI, 
	String^ pUID, 
	array<String^>^ pAggregateFunctions
)

Parameters

pGRP: Type: String
The 'GROUP BY' clause

pCFI: Type: String
The column filter used in the query

pUID: Type: String
The UID of the store

pAggregateFunctions: Type: array<String>[]()[][]
Aggregate function titles available for the DBMS (e.g. 'SUM', 'AVG', etc.)

Return Value

See Also

TheStorageUtilities Class

nsCDEngine.Engines.StorageService Namespace