VistaDB 5






Column name
Expression to evaluate to the default when it is not provided as a part of the udpate
When set, the engine uses this value in update operations, too
Description for the default value
DefineDefaultValue Method
Assign default value to the column.
Syntax
'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
)
procedure DefineDefaultValue( 
    columnName: System.String;
    scriptExpression: System.String;
    useInUpdate: System.Boolean;
    description: System.String
); 
function DefineDefaultValue( 
   columnName : System.String,
   scriptExpression : System.String,
   useInUpdate : System.boolean,
   description : System.String
);
void DefineDefaultValue( 
   System.string* columnName,
   System.string* scriptExpression,
   System.bool useInUpdate,
   System.string* 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

See Also