EditValue

Edits a value.

Compatibility

Available as of IDEA version 9.0

Syntax

EditValue(rowNumber as Long, fieldName as String, newValue as String)

Parameters

rowNumber

The row number of the value.

fieldName

The name of the field which contains the value.

newValue

The value to be added to the cell.

Example

Sub Main 
	Set CreateDatabase = SmartContext.MacroCommands.CreateDatabase 

	'Open existing database and edit its values. 
	CreateDatabase.Open "My Database.IMD" 
	CreateDatabase.EditValue 1, "NUM_FIELD", "111111" 
	CreateDatabase.EditValue 1, "CHAR_FIELD", "Create Database Test2222" 
	CreateDatabase.EditValue 1, "NUM_FIELD", "333333" 
	CreateDatabase.PerformTask 

	'Close the database. 
	CreateDatabase.Close 

	'Release objects 
	Set CreateDatabase = Nothing 
End Sub

Copy example