AppendRecord

Appends a single record to a new database.

Compatibility

Available as of IDEA version 9.0

Syntax

AppendRecord(value As String)

Parameter

value

String containing values separated by either the default setting (";" for field delimiter, "#" for record delimiter) or by the setting of FieldDelimiter or RecordDelimiter respectively.

Example

Sub Main

	Set SimpleCommands = SmartContext.MacroCommands.SimpleCommands
	Set CreateDatabase = SmartContext.MacroCommands.CreateDatabase

	'Open an existing database and append records to it.
	CreateDatabase.Open "My Database.IMD"
	CreateDatabase.AppendRecord "1111;Create Database Test1"
	CreateDatabase.AppendRecord "2222;Create Database Test2"
	CreateDatabase.AppendRecord "3333;Create Database Test3"
	CreateDatabase.PerformTask

	'Close the database
	CreateDatabase.Close

	'Release objects
	Set SimpleCommands = Nothing
	Set CreateDatabase = Nothing

End Sub

Copy example