this.AppendRecord()

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