ArcGIS 空间数据属性查询是通配符 IQueryFilter.WhereClause

ISQLSyntax.GetSpecialCharacter

不需要考虑 是mdb 还是Oracle的

*  % 自动获取

 

 

 

ArcObjects Library Reference  (GeoDatabase)

ISQLSyntax.GetSpecialCharacter Method

Special DBMS dependent SQL characters.

[Visual Basic 6.0]
Function GetSpecialCharacter(
    ByVal sqlSC As esriSQLSpecialCharacters _
) As String

[Visual Basic .NET]
Public Function GetSpecialCharacter ( _
    ByVal sqlSC As esriSQLSpecialCharacters _
) As String

[C#]
public string GetSpecialCharacter (
    esriSQLSpecialCharacters sqlSC
);

[Java]
public String getSpecialCharacter (
    esriSQLSpecialCharacters sqlSC
)
throws
    IOException,
    AutomationException

[C++]
HRESULT GetSpecialCharacter(
  esriSQLSpecialCharacters sqlSC,
  BSTR* pSpecialChar
);

[C++]

Parameters

sqlSC [in]

  sqlSC is a parameter of type esriSQLSpecialCharacters

pSpecialChar [out, retval]

  pSpecialChar is a parameter of type BSTR

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Description

GetSpecialCharacter returns a String value that indicates which character is used to represent the esriSQLSpecialCharacters value specified.

Remarks

The GetSpecialCharacter can be used to return the DBMS dependent character that represents an SQL special character, including the following:

• esriSQL_WildcardManyMatch ( % in SQL_92, * in Jet 4.0)
• esriSQL_WildcardSingleMatch ( _ in SQL_92, ? in Jet 4.0)
• esriSQL_DelimitedIdentifierPrefix ( " in SQL_92, [ in Jet 4.0)
• esriSQL_DelimitedIdentifierSuffix (" in SQL_92, ] in Jet 4.0)

See Also

ISQLSyntax Interface

 

---