Med version 7 af TeamShare tager Lector næste skridt og bygger en platform for AI-agenter, der i højere grad kan følge medarbejderen gennem hele arbejdsprocessen.
Keyword Description CHARACTERSET For the Text driver, OEM or ANSI. COLLATINGSEQUENCE The sequence in which the fields are sorted.When the dBASE or Microsoft FoxPro driver is used, the sequence can be: ASCII (the default) or International.When the Paradox driver is used, the sequence can be: ASCII (default), International, Swedish-Finnish, or Norwegian-Danish.This sets the same option as the Collating Sequence control in the setup dialog box. COLNAMEHEADER For the Text driver, indicates whether the first record of data will specify the column names. Either TRUE or FALSE. COMPACT_DB For the Microsoft Access driver, performs data compaction on a database file. CREATE_DB For the Microsoft Access driver, creates a database file. Has the following format: CREATE_DB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used. When using the CREATE_DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples:“C:\PROGRAM FILES\COMMON FILES\ MyAccess.mdb”“C:\PROGRAM FILES\Access2.mdb”CREATE_DB=C:\TEMP\test.mdb (no quotation marks needed) CREATE_SYSDB For the Microsoft Access driver, creates a system database file. Has the following format: CREATE_SYSDB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used. CREATE_V2DB For the Microsoft Access driver, creates a database file that is compatible with Microsoft Access 2.0. Has the following format: CREATE_V2DB=, where the path name is the full path to a Microsoft Access database. An error will be returned if the path name specifies an existing database. The sort order will be as set up in the New Database dialog box displayed when the Create button is pressed in the Microsoft Access Setup dialog box. If no sort order is specified, General is used. When using the CREATE_V2DB keyword, if the pathname of the Microsoft Access database to be created contains one or more spaces, then the entire pathname must be enclosed by double quotation marks, as shown in the following examples:“C:\PROGRAM FILES\COMMON FILES\ MyAccess.mdb”“C:\PROGRAM FILES\Access2.mdb”CREATE_V2DB=C:\TEMP\test.mdb (no quotation marks needed) DBQ For the Microsoft Access or Paradox driver, the name of the database file.For the Microsoft Excel driver when accessing Microsoft Excel 5.0, 7.0, or 97 files, the name of the workbook file.This sets the same option as the Database control in the setup dialog box. DEFAULTDIR The path specification to the database file (for the Microsoft Access driver) or directory (for the dBASE, Microsoft Excel, Microsoft FoxPro, Paradox, or Text driver). This sets the same option as the Select Directory control in the setup dialog box, or for Microsoft Excel, the Select Workbook control in the setup dialog box. DELETED For the dBASE or Microsoft FoxPro driver, specifies whether or not rows that have been marked as deleted can be retrieved or positioned on. If set to 1, deleted rows are not displayed; if set to 0, deleted rows are treated the same as non-deleted rows. The default is unchecked. This sets the same option as the Show Deleted Rows control in the setup dialog box. DESCRIPTION A description of the data in the data source.This sets the same option as the Description control in the setup dialog box. DRIVER The path specification to the driver DLL. DRIVERID An integer ID for the driver. 25 (Microsoft Access) 21 (dBASE III) 277 (dBASE IV) 533 (dBASE 5.0) 534 (Microsoft Excel 3.0) 278 (Microsoft Excel 4.0) 22 (Microsoft Excel 5.0/7.0) 790 (Microsoft Excel 97) 24 (Microsoft FoxPro 2.0) 280 (Microsoft FoxPro 2.5) 536 (Microsoft FoxPro 2.6) 26 (Paradox 3.x) 282 (Paradox 4.x) 538 (Paradox 5.x) 27 (Text) EXCLUSIVE Determines whether the database will be opened in exclusive mode (accessed by only one user at a time) or shared mode (accessed by more than one user at a time). Can be true (exclusive mode) or false (shared mode). (This does not apply to the Microsoft Excel or Text driver.)This sets the same option as the Exclusive control in the setup dialog box. EXTENSIONS Lists the file name extensions of the Text files on the data source. This sets the same option as the Extensions List control in the setup dialog box. FIL File type MS Access for Microsoft Access dBase III, dBase IV, or dBase 5 Excel 3.0, 4.0, 5.0, 7.0, or 97 for Microsoft Excel FoxPro 2.0, 2.5, or 2.6 for Microsoft FoxPro Paradox 3.x, 4.x, or 5.x) Text. FILETYPE File type for the Text driver (Text). FIRSTROWHASNAMES For the Microsoft Excel driver, indicates whether the cells of the first row of the range contain the column names for the table (1) or not (0). FORMAT For the Text driver, can be FIXEDLENGTH, TABDELIMITED, CSVDELIMITED (by a comma), or DELIMITED() (by the special character specified in the parentheses). The special character is one character in length and can be in character, decimal, or hexadecimal format. IMPLICITCOMMITSYNC Determines whether the Microsoft Access driver will perform internal or implicit commits asynchronously. This value is initially set to “Yes”, which means that the Microsoft Access driver will wait for commits in an internal/implicit transaction to be completed. The value of this option should not be changed without careful consideration of the consequences. For more information on the option, see the the Microsoft Jet Database Engine Programmers’s Guide.This sets the same option as the ImplicitCommitSync control in the setup dialog box. MAXBUFFERSIZE The size of the internal buffer, in kilobytes, that is used by Microsoft Access to transfer data to and from the disk. The default buffer size is 512K (displayed as 512). Any integer value divisible by 256 can be used. This sets the same option as the Buffer Size control in the setup dialog box. MAXSCANROWS For the Microsoft Access, Microsoft Excel, or Text driver, the number of rows to be scanned when setting a column's data type based upon existing data.A number from 1 to 16 can be entered for the rows to scan. The value defaults to 8; if it is set to 0, all rows are scanned. (A number outside the limit will return an error.) For the Text driver, you can enter a number from 1 to 32767 for the number of rows to scan; however, the value will always default to 25. (A number outside the limit will return an error.) This sets the same option as the Rows to Scan Control in the setup dialog box. PAGETIMEOUT Specifies the period of time, in tenths of a second, that a page (if not used) remains in the buffer before being removed. For the Microsoft Access driver, the default is 5 tenths of a second (0.5 seconds). For the dBASE, Microsoft FoxPro, and Paradox drivers, the default is 600 tenths of a second (60 seconds). Note that this option applies to all data sources that use the ODBC driver. This sets the same option as the Page Timeout control in the setup dialog box. PARADOXNETPATH For the Paradox driver, the full path of the directory containing a Paradox lock database, because it contains either the PDOXUSRS.net file (in Paradox 4.x) or the PARADOX.net file (in Paradox 5.x). If the directory does not contain one of these files, the Paradox driver creates one. For information about these files, see the Paradox documentation.Before a network directory can be selected, a Paradox user name must be entered. This sets the same option as the Select Network Directory control in the Paradox setup dialog box. PARADOXNETSTYLE For the Paradox driver, the network access style to use when accessing Paradox data: either “3.x” for Paradox 3.x or “4.x” for Paradox 4.x or 5.x. Can be set to “3.x” or “4.x” if the version is Paradox 4.x or 5.x; if the version is Paradox 3.x, the style must be “3.x”. This sets the same option as the Net Style control in the Paradox setup dialog box. PARADOXUSERNAME For the Paradox driver, the Paradox user name. This sets the same option as the User Name control in the Paradox setup dialog box. PWD For the Microsoft Access or Paradox driver, the password.For the Paradox driver, this is an optional keyword and will never be written to the file by the driver. It is used in a call to SQLDriverConnect against password-secured Paradox files. READONLY TRUE to make file read-only; FALSE to make file not read-only. This sets the same option as the Read-Only control in the setup dialog box. REPAIR_DB For the Microsoft Access driver, repairs a database damaged by a failure that occurs during the commit process. STATISTICS For the dBASE or Microsoft FoxPro driver, determines whether table size statistics are approximated. Note that this option applies to all data sources that use the ODBC driver. This sets the same option as the Approximate Row Count control in the setup dialog box. SYSTEMDB For the Microsoft Access driver, the path specification to system database file. This sets the same option as the System Database control in the setup dialog box. THREADS The number of background threads for the engine to use. For the Microsoft Access driver, this value defaults to 3, but can be changed. For the dBASE, Microsoft Excel, Microsoft FoxPro, Paradox, and Text drivers, this value is 3, and cannot be changed. This sets the same option as the Threads control in the setup dialog box. UID For the Microsoft Access driver, the user ID name used for login. USERCOMMITSYNC Determines whether the Microsoft Access driver will perform user-defined transactions asynchronously. This value is initially set to “Yes”, which means that the Microsoft Access driver will wait for commits in a user-defined transaction to be completed. The value of this option should not be changed without careful consideration of the consequences. For more information on the option, see the the Microsoft Jet Database Engine Programmers’s Guide.This sets the same option as the UserCommitSync control in the setup dialog box.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.