ISQLSyntax2 Interface

Provides access to members that supply information about SQL functionality.

Members

Name Description
Method FormatDatetime Format a datetime value into a literal string.
Method GetDelimitedIdentifierCase True if DBMS's quoted identifiers are case sensitive.
Method GetFunctionName DBMS dependent SQL function names.
Method GetIdentifierCase True if DBMS's identifiers are case sensitive.
Method GetInvalidCharacters The list of invalid characters used in literals (if any).
Method GetInvalidStartingCharacters The list of invalid characters used in literals (if any).
Method GetKeywords The list of DBMS specific reserved keywords.
Method GetOperator SQL operators.
Method GetSpecialCharacter Special DBMS dependent SQL characters.
Method GetSQLInfo SQL Syntax Information.
Method GetStringComparisonCase True if string comparisons are case sensitive.
Method GetSupportedClauses Supported SQL clauses.
Method GetSupportedPredicates Supported SQL predicates.
Method ParseColumnName Given a column name, determine its qualification parts.
Method ParseTableName Given a table name, determine its qualification parts.
Method QualifyColumnName Given a table name and column name, returns its fully qualified name.
Method QualifyTableName Given a database, owner, and table name, return its fully qualified name.
Method TruncateToLimit Truncate identifier to what database can support.

ISQLSyntax2.FormatDatetime Method

Format a datetime value into a literal string.

Public Function FormatDatetime ( _
    ByVal datetimeValue As Object, _
    ByVal datetimeType As esriSQLDatetimeType _
) As String
public string FormatDatetime (
    object datetimeValue,
    esriSQLDatetimeType datetimeType
);

ISQLSyntax2.GetOperator Method

SQL operators.

Public Function GetOperator ( _
    ByVal sqlOperator As esriSQLOperator _
) As String
public string GetOperator (
    esriSQLOperator sqlOperator
);

ISQLSyntax2.GetSQLInfo Method

SQL Syntax Information.

Public Function GetSQLInfo ( _
    ByVal sqlInfo As esriSQLInfo _
) As Object
public object GetSQLInfo (
    esriSQLInfo sqlInfo
);

ISQLSyntax2.TruncateToLimit Method

Truncate identifier to what database can support.

Public Function TruncateToLimit ( _
    ByVal Type As esriIdentifierType, _
    ByVal identifier As String _
) As String
public string TruncateToLimit (
    esriIdentifierType Type,
    string identifier
);

Inherited Interfaces

Interfaces Description
ISQLSyntax Provides access to members that supply information about SQL functionality.

Classes that implement ISQLSyntax2

Classes Description

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.