<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <!--Converted with LaTeX2HTML 98.1p1 release (March 2nd, 1998) originally by Nikos Drakos (nikos@cbl.leeds.ac.uk), CBLU, University of Leeds * revised and updated by: Marcus Hennecke, Ross Moore, Herb Swan * with significant contributions from: Jens Lippmann, Marek Rouchal, Martin Wilck and others --> <HTML> <HEAD> <TITLE>Modification of Tables</TITLE> <META NAME="description" CONTENT="Modification of Tables"> <META NAME="keywords" CONTENT="vol1"> <META NAME="resource-type" CONTENT="document"> <META NAME="distribution" CONTENT="global"> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <LINK REL="STYLESHEET" HREF="vol1.css"> <LINK REL="next" HREF="node63.html"> <LINK REL="previous" HREF="node61.html"> <LINK REL="up" HREF="node59.html"> <LINK REL="next" HREF="node63.html"> </HEAD> <BODY > <!--Navigation Panel--> <A NAME="tex2html1264" HREF="node63.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="icons.gif/next_motif.gif"></A> <A NAME="tex2html1260" HREF="node59.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="icons.gif/up_motif.gif"></A> <A NAME="tex2html1254" HREF="node61.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="icons.gif/previous_motif.gif"></A> <A NAME="tex2html1262" HREF="node1.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="icons.gif/contents_motif.gif"></A> <A NAME="tex2html1263" HREF="node216.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="icons.gif/index_motif.gif"></A> <BR> <B> Next:</B> <A NAME="tex2html1265" HREF="node63.html">Interactive Editing of Tables</A> <B> Up:</B> <A NAME="tex2html1261" HREF="node59.html">Management of Tables</A> <B> Previous:</B> <A NAME="tex2html1255" HREF="node61.html">Displaying Tables</A> <BR> <BR> <!--End of Navigation Panel--> <H2><A NAME="SECTION00843000000000000000"> </A> <A NAME="modification-of-tables"> </A> <BR> Modification of Tables </H2> <P> Elements in a table can be <I>inserted, changed</I>, and <I>deleted</I>. These functions are all performed by the <TT>WRITE/TABLE</TT> or <TT>COPY</TT> commands (See Table 5.4). The element to be modified must be defined by giving its column and row location. An element is deleted if the value is set to <TT>NULL</TT>. A whole row is considered deleted if the element in the reference column is <TT>NULL</TT>. The data type of a column cannot be changed once the column has been created. However, the command <TT>COPY/TT</TT> can be used to copy and convert the values of a column of a certain type into a column of an another type. <BR> <DIV ALIGN="CENTER"><A NAME="6120"> </A> <TABLE> <CAPTION><STRONG>Table 5.4:</STRONG> Commands to Modify a Table</CAPTION> <TR><TD> <DIV ALIGN="CENTER"> <TABLE CELLPADDING=3 BORDER="1" ALIGN="CENTER"> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><B> Command</B></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><B> Description</B></TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>WRITE/TABLE </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Write value into a table element.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/KT </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy a keyword into a table element.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/TK </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy a table element into a keyword.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/TT </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy columns values into another column.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/TI </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Transform the format of the file from table into image.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/IT </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Transform the format of the file from image into table.</TD> </TR> </TABLE></DIV> <A NAME="commands-to-modify-a-table"> </A></TD></TR> </TABLE> </DIV> <BR> <P> It is possible to <I>define a ``subset''</I> of a table by the <TT>SELECT</TT> command. All commands that do not change a table element will only use the subset selected. By selecting <TT>ALL</TT> the whole table is selected. <P> It is also possible to <I>transfer</I> data from one table to another. The four commands described in Table <A HREF="node62.html#commands-to-transfer-table-data">5.5</A> can be used. <BR> <DIV ALIGN="CENTER"><A NAME="6131"> </A> <TABLE> <CAPTION><STRONG>Table 5.5:</STRONG> Commands to Transfer Table Data</CAPTION> <TR><TD> <DIV ALIGN="CENTER"> <TABLE CELLPADDING=3 BORDER="1" ALIGN="CENTER"> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><B> Command</B></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><B> Description</B></TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/TT </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy all selected elements with identical reference values.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>COPY/TABLE </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy all selected elements from one table into another.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>MERGE/TABLE </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Merge common columns in several tables.</TD> </TR> <TR><TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1><TT>PROJECT/TABLE </TT></TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH=1>Copy a set of columns from one table into another.</TD> </TR> </TABLE></DIV> <A NAME="commands-to-transfer-table-data"> </A></TD></TR> </TABLE> </DIV> <BR><I>Interactive identification</I> of table entries is done with the command <TT>IDENTIFY/xxx</TT>, where <TT>xxx</TT> is <TT>CURSOR</TT> for the image display and GCURSOR for the graphic screen. <P> <HR> <!--Navigation Panel--> <A NAME="tex2html1264" HREF="node63.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="icons.gif/next_motif.gif"></A> <A NAME="tex2html1260" HREF="node59.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="icons.gif/up_motif.gif"></A> <A NAME="tex2html1254" HREF="node61.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="icons.gif/previous_motif.gif"></A> <A NAME="tex2html1262" HREF="node1.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="icons.gif/contents_motif.gif"></A> <A NAME="tex2html1263" HREF="node216.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="icons.gif/index_motif.gif"></A> <BR> <B> Next:</B> <A NAME="tex2html1265" HREF="node63.html">Interactive Editing of Tables</A> <B> Up:</B> <A NAME="tex2html1261" HREF="node59.html">Management of Tables</A> <B> Previous:</B> <A NAME="tex2html1255" HREF="node61.html">Displaying Tables</A> <!--End of Navigation Panel--> <ADDRESS> <I>Petra Nass</I> <BR><I>1999-06-09</I> </ADDRESS> </BODY> </HTML>