GetDataByOrdinal (Table)

The GetDataByOrdinal attribute function loads the data to the current data entry of the loaded record.

Syntax
GetDataByOrdinal(Ordinal, NullValue)
Return value
Type		Description
Variant		Contents of the field of the current record
Parameter
Use	Name		Type	Passing	Description
Required	Ordinal		Long	ByVal	Column number, starting at 0
Required	NullValue		Variant	ByVal	Return value if the field is zero

Example:

Dim T As Table

T.Connection := DBCRM

T.Query := "SELECT OPPSTATUS,OPPVOLUME FROM DBO.OPPORTUNITIES WHERE OPID='1521587'"

If T.EOF = False Then

OPPSTATUS := T.GetDataByOrdinal(0, 0)

OPPVOLUME := T.GetDataByOrdinal(1, 0)

End If