Table Column Editor Example
The following HTML page represents an example of how to display and traverse a Datamine table using a scripted Table Editor component:
<html xmlns:MadCap="http://www.madcapsoftware.com/Schemas/MadCap.xsd" MadCap:conditions="Primary.Table_Editor">
<head><title>Table Editor Scripting - Datamine Column Editor</title>
<script language="javascript" type="text/javascript">
function OpenFile()
{
DmEditX1.OpenFile("", false, false);
}
function EditMoveFirst()
{
DmEditX1.MoveFirst();
}
function EditMovePrev()
{
DmEditX1.MovePrev();
}
function EditMoveNext()
{
DmEditX1.MoveNext();
}
function EditMoveLast()
{
DmEditX1.MoveLast();
}
function GetInfo()
{
var objIndex = DmEditX1.CurrentColumn;
var objName = DmEditX1.ColumnName(objIndex-1);
var objType = DmEditX1.ColumnType(objIndex-1);
var objLength = DmEditX1.ColumnLength(objIndex-1);
var objDefault = DmEditX1.ColumnDefault(objIndex-1);
var objImplicit = DmEditX1.ColumnImplicit(objIndex-1);
this.NameField.value = objName;
this.TypeField.value = objType;
this.LengthField.value = objLength;
this.DefaultField.value = objDefault;
this.ImplicitField.value = objImplicit;
}
function UpdateCol()
{
var objIndex = DmEditX1.CurrentColumn;
var objName = this.NameField.value;
var objType = this.TypeField.value;
var objLength = this.LengthField.value
var objDefault = this.DefaultField.value
var objImplicit = this.ImplicitField.value
DmEditX1.UpdateColumnX(objIndex, objName, objType, objLength, objDefault, objImplicit);
}
</script>
<link rel="stylesheet" href="..\Primary.css" />
</head>
<body>
<h1>Table Column Editor</h1>
<form action="">
<input type="button" value="Open File..." name="btnOpenFile" onclick="OpenFile(); return false" />
</form>
<table style="border-collapse: separate;border-collapse: separate;" bgcolor="#000066" border="1">
<tr>
<td style="vertical-align: top;text-align: left;" height="59">
<object classid="clsid:08B27415-70B7-4FB8-91EE-12BD0D9E7B72" id="DmEditX1" style="width: 100%;" height="200">
<embed width="100%" height="200" />
</object>
</td>
</tr>
<tr>
<td style="vertical-align: top;text-align: left;" height="59">
<table cellspacing="0" width="100%">
<tr>
<td style="width: 23%;padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">Column Name</td>
<td style="width: 27%;padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">Column Type</td>
<td style="width: 13%;padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">Length</td>
<td style="width: 19%;padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">Default Value</td>
<td style="width: 18%;padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">Implicit</td>
</tr>
<tr>
<td style="padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">
<input name="NameField" type="text" value="-" />
</td>
<td style="padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">
<input name="TypeField" type="text" value="-" />
</td>
<td style="padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">
<input name="LengthField" type="text" value="-" />
</td>
<td style="padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">
<input name="DefaultField" type="text" value="-" />
</td>
<td style="padding-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;">
<input name="ImplicitField" type="text" value="-" />
</td>
</tr>
</table>
<input type="button" value="Get Info" name="btnGetInfo" onclick="GetInfo(); return false" />
<input type="button" value="Update" name="btnUpdateCol" onclick="UpdateCol(); return false" />
</td>
</tr>
<tr>
<td style="vertical-align: top;text-align: center;" height="29">
<input type="button" value="<<" name="btnMoveFirst" onclick="EditMoveFirst(); return false" />
<input type="button" value="<" name="btnMovePrev" onclick="EditMovePrev(); return false" />
<input type="button" value=">" name="btnMoveNext" onclick="EditMoveNext(); return false" />
<input type="button" value=">>" name="btnMoveLast" onclick="EditMoveLast(); return false" />
</td>
</tr>
</table>
</body>
</html>Related topics and activities