Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\btrieve.20.07.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Defining Table Structure</title> <link rel="StyleSheet" href="css/btrieve.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="btrieve.20.01.html#116630">15 The Btrieve (Pervasive.SQL) Driver</a> : Defining Table Structure</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="116630">Defining Table Structure</a></div> <div class="Body"><a name="116632">Because Btrieve does not store any column information in the data file, you may need to </a>define its structure. Tables created by the Btrieve driver or by Scalable SQL will not require this. Utilities are also available from Pervasive Software that will perform this operation.</div> <div class="Body" style="color: #000000; font-style: normal; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"><span class="Action_bold"><a name="116633">To define the structure of a file:</a></span></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="116634">Display the ODBC Btrieve Driver Setup dialog box through the ODBC Administrator. </a>Click the <span class="Action_bold">Advanced</span> tab; then, click <span class="Action_bold">Define</span> to display the Define File dialog box.</div> </td> </tr> </table> </div> <div class="picture"><a name="130944"><img class="procedure" src="images/btrdefil.gif" width="563" height="347" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The Btrieve Define File dialog box" /></a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="116643">In the Define File dialog box, select the file you want to define and click </a><span class="Action_bold">Open</span> to display the Define Table dialog box.</div> </td> </tr> </table> </div> <div class="picture"><a name="130957"><img class="procedure" src="images/btrdetbl.gif" width="533" height="322" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The Btrieve Define Table dialog box" /></a></div> <div class="Body_Indent"><span class="Action_bold"><a name="116652">Database Name:</a></span> This field displays the directory in which the file you selected in the Define File dialog box is located.</div> <div class="Body_Indent"><span class="Action_bold"><a name="116653">File:</a></span> This field displays the name of the file that you selected in the Define File dialog box.</div> <div class="Body_Indent"><span class="Action_bold"><a name="116654">Table:</a></span> Type the name of the table to be returned by SQLTables. The name can be a maximum of 20 characters and cannot be the same as another defined table in the database. This field is required.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="116655">Specify values in the following fields to define each column. Click </a><span class="Action_bold">Add</span> to add the column name to the list box. </div> </td> </tr> </table> </div> <div class="Body_Indent"><span class="Action_bold"><a name="116656">Name:</a></span> Type the name of the column.</div> <div class="Body_Indent"><span class="Action_bold"><a name="116657">Type:</a></span> Select the data type of the column.</div> <div class="Body_Indent"><span class="Action_bold"><a name="116658">Length:</a></span> Type the length of the column, if applicable.</div> <div class="Body_Indent"><span class="Action_bold"><a name="116659">Scale:</a></span> Type the scale of the column, if applicable.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="116660">To modify an existing column definition, select the column name in the list box. Modify </a>the values for that column name; then, click <span class="Action_bold">Modify</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">5 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="116661">To delete an existing column definition, select a column name in the list box and click </a><span class="Action_bold">Remove</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">6 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="116662">Click </a><span class="Action_bold">OK</span> to define the table.</div> </td> </tr> </table> </div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de