ParamName

This property is a collection of parameter IDs. In the case of the TM.GetItems use of the DataRecord object the parameter IDs are:

(1) QueueName

(5) Source

(9) UserId

(13) ExecTime

(2) SeqNo

(6) Name

(10) DeviceNo

(14) Status

(3) TranDate

(7) Record

(11) IPAddress

(15) ErrMsg

(4) TranTime

(8) FormId

(12) ExecDate

If the DataRecord object is used for another purpose the parameter names would be different. See the ParamCount property to get a count of the parameter IDs.

Group: DataRecord Object


Syntax: sValue = oData.ParamName([nIndex])

sValue     (String) the name of the parameter at the specified index

nIndex     (Long) Optional – the index of the parameter to be evaluated

Example:

When using the TM.GetItems method, to retrieve the name of the macro for the first row in the DataRecord:

Dim oData As New DataRecord

Dim sMacroName As String

TM.GetItems(tmCompleted, Date, App.User, oData)

oData.MoveFirst

sMacorName = oData.Param(6)

sMacorName = oData.Param("Name")