Syntax

Public Function getIndex(ByVal FieldName As String) As Short

Description

This function used to get the field index base on its name.

Parameters

Return value

Returns field index as a short value.

Sample

Public Sub main()        'Variables        Dim DB As New VTLGeneral.Database()        Dim RecordCount As Integer        Dim m_Recordset As VTLGeneral.RecordSet        Dim _historyData As object()        Dim Record As Integer        Dim m_Date As VTLGeneral.Field        Dim m_Open As VTLGeneral.Field        Dim m_High As VTLGeneral.Field        Dim m_Low As VTLGeneral.Field        Dim m_Close As VTLGeneral.Field        Dim _recordCount as integer = 100        Dim i As Integer        m_Recordset = DB.CreateRecord        m_Open = New VTLGeneral.Field        m_High = New VTLGeneral.Field        m_Low = New VTLGeneral.Field        m_Close = New VTLGeneral.Field        DB.RecordCount = _recordCount        RecordCount = _recordCount         'Initialize Recordsets        m_Open.initialize(_recordCount, "Open")        m_High.initialize(_recordCount, "High")        m_Low.initialize(_recordCount, "Low")        m_Close.initialize(_recordCount, "Close")         m_Recordset.addField(m_Open)        m_Recordset.addField(m_High)        m_Recordset.addField(m_Low)        m_Recordset.addField(m_Close)        ' get field name        GUI.MsgDialog(m_Recordset. getIndex ("Open")) End Sub  

See Also

• getField
• addField
• renameField

Back to RecordSet
Back to VTL Server Script Index