Retrieves the value of columns on which an upload or download operation occurred.
Public Property ColumnValue( ByVal index As Integer ) As Object Member of DbmlsyncCOM.IRowTransferData
index The zero based integer specifying the column value to be retrieved. Index values range from zero to one less than the ColumnCount property value.
See ColumnCount property.
When an update operation is encountered, the column values given by this property are the values after the update is applied.
Associated column names can be retrieved using the ColumnName property with the same index.
BLOB column values are not available through this property. When a BLOB column is encountered, the ColumnValue is the string "(blob)".
The following Visual Basic .NET example iterates through all the columns for a row in the UploadRow event. It determines if a column value is null and outputs column names and values.
See UploadRow event.
Private Sub dbmlsync1_UploadRow( ByVal rowData As DbmlsyncCOM.IRowTransferData ) Handles dbmlsync1.UploadRow Dim liX As Integer For liX = 0 To rowData.ColumnCount - 1 If VarType(rowData.ColumnValue(liX)) <> VariantType.Null Then ' output the non-null column value MsgBox("Column " + CStr(liX) + ": " + rowData.ColumnName(liX) + _ ", " + CStr(rowData.ColumnValue(liX))) Else ' output 'NULL' for the column value MsgBox("Column " + CStr(liX) + ": " + rowData.ColumnName(liX) + _ ", " + "NULL") End If Next liX End Sub |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |