AddField

Adds a new field to a database.

Compatibility

Available as of IDEA version 9.0

Syntax

AddField(fieldName As String, description As String, type As Integer, length As Integer, decimals As Integer)

Parameters

fieldName

The name of the new field.

description

The description of the new field.

type

The type of the new field.

length

The length of the new field.

decimals

The decimals of the new field.

Examples

Const CreateOnServer As Integer = 1
Const CreateOnDesktop As Integer = 0

Sub Main
	Set SimpleCommands = SmartContext.MacroCommands.SimpleCommands
	Set CreateDatabase = SmartContext.MacroCommands.CreateDatabase
	fileName = SimpleCommands.UniqueFileName("My Database")
	dbData = "1111;Create Database Test1#2222;Create Database Test2#3333;Create Database Test3"

	'Create a database and specify the location
	CreateDatabase.AddDatabaseAt fName, "", CreateOnServer
	CreateDatabase.AddField "AMOUNT", "description of this field", WI_NUM_FIELD, 8, 2
	CreateDatabase.AddField "ACCOUNT_DESCR", "character field description", WI_CHAR_FIELD, 32, 0
	CreateDatabase.AppendValues dbData
	CreateDatabase.PerformTask

	'Release object
	Set SimpleCommands = Nothing
	Set CreateDatabase = Nothing

End Sub

Copy example

Const CreateOnServer As Integer = 1

Const CreateOnDesktop As Integer = 0