RecordSet.IdxField

From Xojo Documentation
Jump to: navigation, search
Method
RecordSet.IdxField ( Index as Integer ) As DatabaseField

Returns a DatabaseField containing information about the column (specified by index, which is 1-based) from the current position in the RecordSet.

Notes

If the RecordSet has no rows, the returned DatabaseField only contains the Name of the column.

Example

Get the string value of a column in a RecordSet:

// rs is a RecordSet; column 1 is a string column
Dim productName As String
productName = rs.IdxField(1).StringValue


Set the string value of a column in a RecordSet:

// rs is a RecordSet; column 1 is a string column
rs.Edit
rs.IdxField(1).StringValue = "Generic Widgets"
rs.Update
Personal tools
Namespaces

Variants
Actions
Main
Documentation
Community
Toolbox
Help