A list of products available on this site
Documentation for XtraMania's xtras
Prices and links to the online store
Xtras, PDFs, samples
Have a question? Ask us!
Contacts
Logo. www.xtramaina.com  
Home Search E-mail
ADOxtra Reference/rst.Fields

rst.Fields

Syntax

oldValue=rst.Fields[fieldIndex]
fieldsCount=rst.Fields.Count
rst.Fields[fieldIndex]=newValue

Parameters

fieldIndex
String field name or Integer zero based index of the field object in Recordset.Fields collection.

Sets or gets

Any
recordset field value, if used in simple syntax.

Object
field object wrapper, if further cascading property is requested.

Description

Allows access to the Value property of the field objects or to Field object itself in Fields collection of the wrapped ADODB.Recordset object. Each Field object corresponds to a column in the Recordset.

Sample

on ShowCurrentRecord rst
  repeat with i = 0 to rst.Fields.Count - 1
    put rst.Fields[i].Name & "=" & rst.Fields[i]
  end repeat
end

Site homeSearchContact author © Eugene Shoustrov. www.xtramania.com