RecordSet.Field
From Xojo Documentation
This item was deprecated in version 2019r2. Please use RowSet.Column as a replacement. |
Method
Returns a DatabaseField containing information about the column (specified by Name) from the current position in the RecordSet.
Example
Get the string value of a column in a RecordSet:
// rs is a RecordSet with a string column called "ProductName"
Dim productName As String
productName = rs.Field("ProductName").StringValue
Dim productName As String
productName = rs.Field("ProductName").StringValue
Set the string value of a column in a RecordSet:
// rs is a RecordSet with a string column called "ProductName":
rs.Edit
rs.Field("ProductName").StringValue = "Generic Widgets"
rs.Update
rs.Edit
rs.Field("ProductName").StringValue = "Generic Widgets"
rs.Update