Interface ISQLSyntax2

Namespace
ESRI.ArcGIS.Geodatabase
Assembly
ESRI.Server.Geodatabase.dll

Provides access to members that supply information about SQL functionality.

[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("27EAC2DF-89C1-496D-88BA-7A82C2DDBA05")]
public interface ISQLSyntax2 : ISQLSyntax

Methods

FormatDatetime(object, esriSQLDatetimeType)

Format a datetime value into a literal string.

string FormatDatetime(object datetimeValue, esriSQLDatetimeType datetimeType)

Parameters

datetimeValue object
datetimeType esriSQLDatetimeType

Returns

string

GetDelimitedIdentifierCase()

bool GetDelimitedIdentifierCase()

Returns

bool

GetFunctionName(esriSQLFunctionName)

string GetFunctionName(esriSQLFunctionName sqlFunc)

Parameters

sqlFunc esriSQLFunctionName

Returns

string

GetIdentifierCase()

bool GetIdentifierCase()

Returns

bool

GetInvalidCharacters()

string GetInvalidCharacters()

Returns

string

GetInvalidStartingCharacters()

string GetInvalidStartingCharacters()

Returns

string

GetKeywords()

IEnumBSTR GetKeywords()

Returns

IEnumBSTR

GetOperator(esriSQLOperator)

SQL operators.

string GetOperator(esriSQLOperator sqlOperator)

Parameters

sqlOperator esriSQLOperator

Returns

string

GetSQLInfo(esriSQLInfo)

SQL Syntax Information.

object GetSQLInfo(esriSQLInfo sqlInfo)

Parameters

sqlInfo esriSQLInfo

Returns

object

GetSpecialCharacter(esriSQLSpecialCharacters)

string GetSpecialCharacter(esriSQLSpecialCharacters sqlSC)

Parameters

sqlSC esriSQLSpecialCharacters

Returns

string

GetStringComparisonCase()

bool GetStringComparisonCase()

Returns

bool

GetSupportedClauses()

int GetSupportedClauses()

Returns

int

GetSupportedPredicates()

int GetSupportedPredicates()

Returns

int

ParseColumnName(string, out string, out string, out string, out string)

void ParseColumnName(string FullName, out string dbName, out string OwnerName, out string TableName, out string columnName)

Parameters

FullName string
dbName string
OwnerName string
TableName string
columnName string

ParseTableName(string, out string, out string, out string)

void ParseTableName(string FullName, out string dbName, out string OwnerName, out string TableName)

Parameters

FullName string
dbName string
OwnerName string
TableName string

QualifyColumnName(string, string)

string QualifyColumnName(string TableName, string columnName)

Parameters

TableName string
columnName string

Returns

string

QualifyTableName(string, string, string)

string QualifyTableName(string dbName, string OwnerName, string TableName)

Parameters

dbName string
OwnerName string
TableName string

Returns

string

TruncateToLimit(esriIdentifierType, string)

Truncate identifier to what database can support.

string TruncateToLimit(esriIdentifierType Type, string identifier)

Parameters

Type esriIdentifierType
identifier string

Returns

string