Description

Inserts the current output record into the output database table. Returns the unique identifier for the record if such supported by the underlying database system.

Syntax

Function AppendRecord( get_id(optional) )

Parameters

boolean get_id(optional) - true: ask for the record's unique identifier to be returned if possible. Default - false

Return value

variant - the record's unique identifier if applicable

Example

Example 1

Function OnRecord
this.AppendStart
DictOut.Field1.value = val1
DictOut.Field2.value = val2
DictOut.Field3.value = val3
this.AppendRecord
End Function

Example 2

Function OnFinishProcess 'creates footer
this.AppendStart
For i = 1 to dictout.GetFieldCount(): Dictout.SetFieldValue i, Empty: Next ' clears the fields of prior data
DictOut.Field_1.value = "FOOTER RECORD" ' insets literal but could be variable
this.AppendRecord

this.AppendStart 'creates empty line
For i = 1 to dictout.GetFieldCount(): Dictout.SetFieldValue i, Empty: Next  ' clears the fields of prior data
this.AppendRecord
End Function

See also

Platform Objects and Methods

DB.sort()

DB.AppendFinish
DB.SetFieldValue
DB.TransactionFinish
this.AddToBuffer()
this.AppendStart()

This. Methods()