Returns the name of the column identified by the specified column ID.
Visual Basic Public Function GetColumnSQLName( _ ByVal columnID As Integer _ ) As String
C# public string GetColumnSQLName( int columnID );
columnID ID of the column. The value must be in the range [0,ColumnCount-1].
The name of the column or a null reference (Nothing in Visual Basic) if the column has no name. If the column is aliased in the SQL query, the alias is returned.
Note that in result sets, not all columns have names and not all column names are unique. If you are using aliases, the name of the column is the alias.
The GetColumnSQLName method differs from the GetColumnName in that for non-aliased, non-computed columns GetColumnSQLName always returns just the name of the column (without the table name as a prefix). While this behavior more closely resembles the behavior of other ADO.NET providers, it is more likely to produce non-unique names.
Column IDs and count may change during a schema upgrade. To correctly identify a column, access it by name or refresh the cached IDs and counts after a schema upgrade.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|