DefineDefaultValue Method

In This Topic

Assign default value to the column.

Syntax

Visual Basic
C#

'Declaration
 
Sub DefineDefaultValue( _
   ByVal columnName As System.String, _
   ByVal scriptExpression As System.String, _
   ByVal useInUpdate As System.Boolean, _
   ByVal description As System.String _
)

'Usage
 
Dim instance As IVistaDBTableSchema
Dim columnName As System.String
Dim scriptExpression As System.String
Dim useInUpdate As System.Boolean
Dim description As System.String
 
instance.DefineDefaultValue(columnName, scriptExpression, useInUpdate, description)

void DefineDefaultValue( 
   System.string columnName,
   System.string scriptExpression,
   System.bool useInUpdate,
   System.string description
)

Parameters

columnName: Column name
scriptExpression: Expression to evaluate to the default when it is not provided as a part of the udpate
useInUpdate: When set, the engine uses this value in update operations, too
description: Description for the default value

Remarks

The default value may be either a constant or the evaluated one throw sql expression. You cannot set default value if identity has already been assigned to the column.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IVistaDBTableSchema Interface
IVistaDBTableSchema Members

Send Feedback