Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\dbasfox.21.04.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>Connection Option Descriptions</title> <link rel="StyleSheet" href="css/dbasfox.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="dbasfox.21.01.html#110826">16 The dBASE Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="110826">Connection Option Descriptions</a></div> <div class="Body"><a name="163419">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. </div> <div class="Body"><a name="163420">In most cases, the GUI name and the attribute name are the same; however, some </a>exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.</div> <div class="Body"><a name="163421">Also, a few connection string attributes, for example, Password, do not have equivalent </a>options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#110839', '');" name="112729">Table 16-1</a></span> lists the connection string attributes supported by the dBASE driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 16-1. <a name="110839">dBASE Attribute Names</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="110846">Attribute (Short Name)</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="110848">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#115280', '');" name="136455">ApplicationUsingThreads (AUT)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136457">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111572', '');" name="136448">CacheSize (CSZ)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136450">4</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111587', '');" name="136441">CreateType (CT) [dBASE]</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136443">dBASE5</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#115599', '');" name="136434">CreateType (CT)) [FoxPro]</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136436"> FoxPro30 Database</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#121924', '');" name="136469">Database (DB) [dBASE]</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136471">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#121945', '');" name="136462">Database (DB) [FoxPro]</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136464">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111602', '');" name="136483">DataFileExtension (DFE)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136485">DBF</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#115926', '');" name="136476">DataSourceName (DSN)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136478">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#116019', '');" name="136546">Description (n/a)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136548">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111673', '');" name="136539">ExtensionCase (EC)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136541">UPPER</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111688', '');" name="136532">FileOpenCache (FOC)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136534">0 (no file open caching)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#116579', '');" name="136525">IANAAppCodePage (IACP)</a></span><br />UNIX ONLY</div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136527">4 (ISO 8559-1 Latin-1)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#116967', '');" name="136518">IntlSort (IS)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136520">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111753', '');" name="136511">LockCompatibility (LCOMP)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136513">dBASE</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#111775', '');" name="136504">Locking (LCK)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136506">RECORD</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#117762', '');" name="136497">UseLongNames (ULN)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136499">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.04.html#117147', '');" name="136490">UseLongQualifiers (ULQ)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="136492">0 (Disabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="114700">ApplicationUsingThreads</a></div> <div class="gutter_text_right"><a name="115278">Attribute</a></div> <div class="Body_attr"><a name="115280">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="114701">Description</a></div> <div class="Body"><a name="163290">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="gutter_text_right"><a name="114710">Valid Values</a></div> <div class="Body"><a name="163386">0 | 1</a></div> <div class="Body"><a name="163387">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="163388">If set to 0 (Disabled), the driver does not work with multi-threaded applications. If using the </a>driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.</div> <div class="gutter_text_right"><a name="114717">Default</a></div> <div class="Body"><a name="114719">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="112029">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="112033">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111570">Cache Size</a></div> <div class="gutter_text_right"><a name="111571">Attribute</a></div> <div class="Body_attr"><a name="111572">CacheSize (CSZ)</a></div> <div class="gutter_text_right"><a name="114993">Description</a></div> <div class="Body"><a name="163382">The number of 64 KB blocks the driver uses to cache database records. The larger the </a>number of blocks, the better the performance.</div> <div class="gutter_text_right"><a name="121500">Valid Values</a></div> <div class="Body"><a name="163402">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="163403">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of 64 KB blocks for caching.</div> <div class="Body"><a name="163404">If set to 0, no records are cached.</a></div> <div class="Body"><a name="163405">If set to </a><span class="EquationVariables">x</span>, the specified number of 64 KB blocks are set aside for caching. The maximum number of blocks you can set depends on the system memory available. If the cache size is greater than 0, when browsing backwards, you are not able to see updates made by other users until you run the Select statement again.</div> <div class="gutter_text_right"><a name="111574">Default</a></div> <div class="Body"><a name="111575">4</a></div> <div class="gutter_text_right"><a name="123688">GUI tab</a></div> <div class="Body"><span class="Cross_ref_" style="font-size: 10.0pt; font-weight: normal;"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136596">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111585">Create Type [dBASE]</a></div> <div class="gutter_text_right"><a name="111586">Attribute</a></div> <div class="Body_attr"><a name="111587">CreateType (CT) [dBASE]</a></div> <div class="gutter_text_right"><a name="115252">Description</a></div> <div class="Body"><a name="111588">The type of table or index to be created on a Create Table or Create Index statement.</a></div> <div class="gutter_text_right"><a name="115340">Valid Values</a></div> <div class="Body"><a name="115341">dBASE4 | dBASE5 | Clipper | FoxPro25 | FoxPro30</a></div> <div class="gutter_text_right"><a name="111589">Default</a></div> <div class="Body"><a name="111590">dBASE5</a></div> <div class="gutter_text_right"><a name="115405">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106318', '');" name="111599">General tab</a></span></div> <div class="head_2_no_TOC"><a name="115597">Create Type [FoxPro]</a></div> <div class="gutter_text_right"><a name="115598">Attribute</a></div> <div class="Body_attr"><a name="115599">CreateType (CT)) [FoxPro]</a></div> <div class="gutter_text_right"><a name="115600">Description</a></div> <div class="Body"><a name="115601">The type of table or index to be created on a Create Table or Create Index statement.</a></div> <div class="gutter_text_right"><a name="115602">Valid Value</a></div> <div class="Body"><a name="115603">FoxPro30 Database</a></div> <div class="gutter_text_right"><a name="115604">Default</a></div> <div class="Body"><a name="115605">FoxPro30 Database</a></div> <div class="gutter_text_right"><a name="115606">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106461', '');" name="115611">General tab</a></span></div> <div class="head_2_no_TOC"><a name="111600">Data File Extension</a></div> <div class="gutter_text_right"><a name="111601">Attribute</a></div> <div class="Body_attr"><a name="111602">DataFileExtension (DFE)</a></div> <div class="gutter_text_right"><a name="116730">Description</a></div> <div class="Body"><a name="163450">A one- to three-character file name extension to use for data files.</a></div> <div class="gutter_text_right"><a name="115296">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="163443">ext</a></span></div> <div class="Body"><a name="163444">where </a><span class="EquationVariables">ext</span> is the name of the one- to three-character file name extension.</div> <div class="Body"><a name="163445">This value is used for all Create Table statements. Sending a Create Table using an </a>extension other than the value specified for this option causes an error.</div> <div class="Body"><a name="163446">In other SQL statements, such as Select or Insert, users can specify an extension other </a>than the one specified for this connection option. The Data File Extension value is used when no extension is specified.</div> <div class="Body"><a name="116853">The file extension cannot be one the driver already uses, such as MDX or CDX.</a></div> <div class="gutter_text_right"><a name="111605">Default</a></div> <div class="Body"><a name="123668">DBF</a></div> <div class="gutter_text_right"><a name="123709">GUI tab</a></div> <div class="Body"><span class="Cross_ref_" style="font-size: 10.0pt; font-weight: normal;"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136608">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="123675">Data Source Name</a></div> <div class="gutter_text_right"><a name="115924">Attribute</a></div> <div class="Body_attr"><a name="115926">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="115927">Description</a></div> <div class="Body"><a name="163294">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="115932">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="163392">string</a></span> </div> <div class="Body"><a name="163393">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="115938">Default</a></div> <div class="Body"><a name="115940">None</a></div> <div class="gutter_text_right"><a name="112067">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106318', '');" name="112072">General tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106461', '');">General tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="121922">Database Directory</a></div> <div class="gutter_text_right"><a name="121923">Attribute</a></div> <div class="Body_attr"><a name="121924">Database (DB) [dBASE]</a></div> <div class="gutter_text_right"><a name="131495">Description</a></div> <div class="Body"><a name="163434">The directory that contains the data files.</a></div> <div class="gutter_text_right"><a name="121929">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="163438">database_directory</a></span></div> <div class="Body"><a name="163439">where </a><span class="EquationVariables">database_directory</span> is the full path name of the directory in which the data files are stored. If no directory is specified, the current working directory is used.</div> <div class="gutter_text_right"><a name="121935">Default</a></div> <div class="Body"><a name="121936">None</a></div> <div class="gutter_text_right"><a name="121937">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106318', '');" name="121942">General tab</a></span></div> <div class="head_2_no_TOC"><a name="121943">Database Name</a></div> <div class="gutter_text_right"><a name="121944">Attribute</a></div> <div class="Body_attr"><a name="121945">Database (DB) [FoxPro]</a></div> <div class="gutter_text_right"><a name="131489">Description</a></div> <div class="Body"><a name="121946">The directory that contains the database container (.DBC) files.</a></div> <div class="gutter_text_right"><a name="121947">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="121948">database_directory</a></span></div> <div class="Body"><a name="121949">where </a><span class="EquationVariables">database_directory</span> is the full path name of the directory and .DBC file that you want to use.</div> <div class="gutter_text_right"><a name="121950">Default</a></div> <div class="Body"><a name="121951">None</a></div> <div class="gutter_text_right"><a name="121952">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106461', '');" name="121957">General tab</a></span></div> <div class="head_2_no_TOC"><a name="116016">Description</a></div> <div class="gutter_text_right"><a name="116017">Attribute</a></div> <div class="Body_attr"><a name="116019">Description (n/a)</a></div> <div class="gutter_text_right"><a name="116020">Description</a></div> <div class="Body"><a name="163354">An optional long description of a data source. This description is not used as a runtime </a>connection attribute, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="gutter_text_right"><a name="116025">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="163397">string</a></span> </div> <div class="Body"><a name="163398">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="116031">Default</a></div> <div class="Body"><a name="116032">None</a></div> <div class="gutter_text_right"><a name="137106">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106318', '');" name="137219">General tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106461', '');">General tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="137121">Extension Case</a></div> <div class="gutter_text_right"><a name="111672">Attribute</a></div> <div class="Body_attr"><a name="111673">ExtensionCase (EC)</a></div> <div class="gutter_text_right"><a name="116400">Description</a></div> <div class="Body"><a name="111674">This option determines whether uppercase or lowercase file extensions are accepted. </a></div> <div class="gutter_text_right"><a name="116309">Valid Values</a></div> <div class="Body"><a name="116390">LOWER | UPPER</a></div> <div class="Body"><a name="116519">When set to UPPER, uppercase extensions are accepted.</a></div> <div class="Body"><a name="116575">When set to LOWER, lowercase extensions are accepted.</a></div> <div class="gutter_text_right"><a name="111675">Default</a></div> <div class="Body"><a name="111676">UPPER</a></div> <div class="gutter_text_right"><a name="123726">GUI tab</a></div> <div class="Body"><span class="Cross_ref_" style="font-size: 10.0pt; font-weight: normal;"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136629">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111686">File Open Cache</a></div> <div class="gutter_text_right"><a name="111687">Attribute</a></div> <div class="Body_attr"><a name="111688">FileOpenCache (FOC)</a></div> <div class="gutter_text_right"><a name="116669">Description</a></div> <div class="Body"><a name="163464">The maximum number of used file handles to cache.</a></div> <div class="gutter_text_right"><a name="116650">Valid Values</a></div> <div class="Body"><a name="163468">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="163469">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="163470">If set to 0, no file open caching is performed.</a></div> <div class="Body"><a name="163471">If set to </a><span class="EquationVariables">x</span>, when a user opens and closes <span class="EquationVariables">x</span> tables, the tables are not actually closed. The driver keeps them open so that if another query uses one of these tables, the driver does not have to perform another open, which is expensive. The advantage of file open caching is improved performance. The disadvantage is that a user who tries to open the file exclusively may get a file locking conflict even though no one appears to have the file open.</div> <div class="gutter_text_right"><a name="117125">Default</a></div> <div class="Body"><a name="117126">0 (No File Open Caching)</a></div> <div class="gutter_text_right"><a name="123735">GUI tab</a></div> <div class="Body"><span class="Cross_ref_" style="font-size: 10.0pt; font-weight: normal;"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="157030">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="157045">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="157046">Attribute</a></div> <div class="Body_attr"><a name="116579">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="116580">Description</a></div> <div class="Body"><a name="163231">An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this </a>option if your application is not Unicodeâ??enabled and/or if your database character set is not Unicode (refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'unicode.06.1.html#106144', '');">Chapter 4 â??Internationalization, Localization, and Unicodeâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span> for details). The value you specify must match the database character encoding and the system locale.</div> <div class="Body"><a name="163240">The Driver Manager checks for the value of IANAAppCodePage in the following order:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="163241">In the connection string</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="163242">In the Data Source section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="163243">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="116599">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="163425">IANA_code_page</a></span> </div> <div class="Body"><a name="163427">where </a><span class="EquationVariables">IANA_code_page</span> is one of the valid values listed in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1 â??Values for the Attribute IANAAppCodePageâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span>. The value must match the database character encoding and the system locale.</div> <div class="gutter_text_right"><a name="116610">Default</a></div> <div class="Body"><a name="116612">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="123744">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136663">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111735">International Sort</a></div> <div class="gutter_text_right"><a name="116966">Attribute</a></div> <div class="Body_attr"><a name="116967">IntlSort (IS)</a></div> <div class="gutter_text_right"><a name="116968">Description</a></div> <div class="Body"><a name="163454">Uses international sort order as defined by your operating system when you issue a Select </a>statement with an Order By clause.</div> <div class="gutter_text_right"><a name="116973">Valid Values</a></div> <div class="Body"><a name="163458">0 | 1</a></div> <div class="Body"><a name="163459">If set to 1 (Enabled), this order is always alphabetic, regardless of case; the letters are </a>sorted as "A, b, C." Refer to your operating system documentation concerning the sorting of accented characters.</div> <div class="Body"><a name="163460">If set to 0 (Disabled), ASCII sort order is used. This order sorts items alphabetically with </a>uppercase letters preceding lowercase letters. For example, "A, b, C" is sorted as "A, C, b."</div> <div class="gutter_text_right"><a name="116980">Default</a></div> <div class="Body"><a name="116981">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123757">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136679">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111751">Lock Compatibility</a></div> <div class="gutter_text_right"><a name="111752">Attribute</a></div> <div class="Body_attr"><a name="111753">LockCompatibility (LCOMP)</a></div> <div class="gutter_text_right"><a name="117376">Description</a></div> <div class="Body"><a name="117377">The locking scheme the driver uses when locking records.</a></div> <div class="gutter_text_right"><a name="117379">Valid Values</a></div> <div class="Body"><a name="117174">Clipper | dBASE | Fox | Q+E | Q+EVirtual</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117279">Clipper specifies Clipper-compatible locking.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117280">dBASE specifies Borland-compatible locking.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117281">Fox specifies FoxPro-compatible locking.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117282">Q+E specifies that locks be placed on the actual bytes occupied by the record. Only </a>applications that use the dBASE driver can read and write to the database. Other applications are locked out of the table completely (they cannot even read other records). This locking is compatible with earlier versions of Q+E products.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117283">Q+EVirtual specifies that locks be placed on bytes beyond the physical end-of-file. </a>Q+EVirtual is the same as Q+E except that other applications can open the table and read the data.</div> </td> </tr> </table> </div> <div class="Body"><a name="117491">The advantage of using a Q+E locking scheme over dBASE locking is that, on Inserts and </a>Updates, Q+E locks only individual index tags, while dBASE locks the entire index. The following values determine locking support as described:</div> <div class="Body"><a name="117176">If you are accessing a table with an application that uses the dBASE driver, your locking </a>scheme does not have to match the Create Type. If you access a table with two applications, however, and only one uses the dBASE driver, set your locking scheme to match the other application. For example, you do not have to set this value to Fox to work with a FoxPro table. But if you are using a FoxPro application simultaneously with an application using the dBASE driver on the same set of tables, set this value to Fox to ensure that your data does not become corrupted.</div> <div class="gutter_text_right"><a name="111761">Default</a></div> <div class="Body"><a name="111762">dBASE</a></div> <div class="gutter_text_right"><a name="123768">GUI tab</a></div> <div class="Body"><span class="Cross_ref_" style="font-size: 10.0pt; font-weight: normal;"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136691">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111773">Locking</a></div> <div class="gutter_text_right"><a name="111774">Attribute</a></div> <div class="Body_attr"><a name="111775">Locking (LCK)</a></div> <div class="gutter_text_right"><a name="131516">Description</a></div> <div class="Body"><a name="111776">The level of locking for the database file.</a></div> <div class="gutter_text_right"><a name="117536">Valid Values</a></div> <div class="Body"><a name="117537">NONE | RECORD | FILE</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117647">NONE offers the best performance, but is intended only for single-user environments. </a>See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'lock.09.2.html#106167', '');">â??Lockingâ??</a></span> for details.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117601">RECORD locks only the records affected by the statement.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="117675">FILE locks all of the records in the table.</a></div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="117595">Default</a></div> <div class="Body"><a name="111778">RECORD</a></div> <div class="gutter_text_right"><a name="123781">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136783">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111804">Use Long Names</a></div> <div class="gutter_text_right"><a name="111805">Attribute</a></div> <div class="Body_attr"><a name="117762">UseLongNames (ULN)</a></div> <div class="gutter_text_right"><a name="117831">Description</a></div> <div class="Body"><a name="117763">Specifies whether to use long file names as table names.</a></div> <div class="gutter_text_right"><a name="117731">Valid Values</a></div> <div class="Body"><a name="117734">0 | 1</a></div> <div class="Body"><a name="117735">If set to 1 (Enabled), the driver uses long file names as table names. The maximum table </a>name length is specific to the environment in which you are running.</div> <div class="Body"><a name="117736">If set to 0 (Disabled), the driver does not long file names as table names.</a></div> <div class="gutter_text_right"><a name="117738">Default</a></div> <div class="Body"><a name="117739">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123794">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136809">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</div> <div class="head_2_no_TOC"><a name="111819">Use Long Qualifiers</a></div> <div class="gutter_text_right"><a name="117146">Attribute</a></div> <div class="Body_attr"><a name="117147">UseLongQualifiers (ULQ)</a></div> <div class="gutter_text_right"><a name="117148">Description</a></div> <div class="Body"><a name="163475">Determines whether the driver uses long path names.</a></div> <div class="gutter_text_right"><a name="117153">Valid Values</a></div> <div class="Body"><a name="163479">0 | 1</a></div> <div class="Body"><a name="163480">If set to 1 (Enabled), path names can be a maximum of 255 characters.</a></div> <div class="Body"><a name="163481">If set to 0 (Disabled), path names can be a maximum of 128 characters.</a></div> <div class="gutter_text_right"><a name="117160">Default</a></div> <div class="Body"><a name="117161">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123807">GUI tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106336', '');" name="136829">Advanced tab</a></span> [dBASE]<br /><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'dbasfox.21.03.html#106478', '');">Advanced tab</a></span> [FoxPro]</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