InsertSchemaColumn Method

Description

Inserts a new column into the currently loaded Schema. Use LoadSchema to load a Schema for editing.

Syntax

Public Function InsertSchemaColumn( _
   ByVal formula As String, _
   ByVal nColumn As Integer _
) As Integer

Parameters

formula

The expression of the new column. See Property Expressions Syntax for details.

 

nColumn

The position in the columns list at which to insert the new column. If this argument specifies a position in the existing columns then the new column will not replace the existing column at the given position, but will shuffle any other columns down the list.

Remarks

This does not affect overlays that already use the schema being edited. The schema has to be re-applied using StoreSchema to save the changes, then SetOverlaySchema.

Available: GEO MM ME MD OD OM SISpy

Groups:

• Table and Schema Methods

Example

sis.InsertSchemaColumn ("Item_name$", 0)

Send comments on this topic.

Click to return to www.cadcorp.com

© Copyright 2000-2017 Computer Aided Development Corporation Limited (Cadcorp).