DBCREATE()
Creates an empty database from a array.
- Syntax
-
- DBCREATE(<cDatabase>, <aStruct>,[<cDriver>],[<lOpen>],
- [<cAlias>]) --> NIL
- Arguments
-
- <cDatabase> Name of database to be create
- <aStruct> Name of a multidimensional array that contains the a database structure
- <cDriver> Name of the RDD
- <lOpenNew> 3-way toggle to Open the file in New or Current workarea:
NIL | The file is not opened. |
True | It is opened in a New area. |
False | It is opened in the current area. |
- <cAlias> Name of database Alias
- Returns
-
- DBCREATE() always returns NIL.
- Description
-
- This function creates the database file specified as <cDatabase> from the multidimensional array <aStruct>.If no file extension is use with <cDatabase> the .DBF extension is assumed. The array specified in <aStruct> must follow a few guidelines when being built prior to a call to DBCREATE():
- - All subscripts values in the second dimension must be set to proper values
- - The fourth subscript value in the second dimension - which contains the decimal value-must he specified. even 1kw nonnumeric fields.
- - The second subscript value in the second dimension-which contains the field data type-must contain a proper value: C, D, L, M or N It is possible to use additional letters (or clarity (e.g., 'Numeric' for 'N'): however, the first letter of this array element must be a proper value.
- The DBCREATE( ) function does not use the decimal field to calculate the length of a character held longer than 256. Values up to the maximum length of a character field (which is 65,519 bytes) are stored directly in the database in the length attribute if that database was created via this function. However, a file containing fields longer than 256 bytes is not compatible with any interpreter.
- The <cDriver> parameter specifies the name of the Replaceable Da- tabase Driver to use to create the database. If it is not specified, then the Replaceable Database Driver in the current work area is tised. The <lOpenNew> parameter specifies if the already created database is to be opened, and where. If NIL, the file is not opened. If True, it is opened in a New area, and if False it is opened in the current area (closing any file already occupying that area). The <cAlias> parameter specifies the alias name for the new opened database
Examples
function main()
local nI, aStruct := { { "CHARACTER", "C", 25, 0 }, ;
{ "NUMERIC", "N", 8, 0 }, ;
{ "DOUBLE", "N", 8, 2 }, ;
{ "DATE", "D", 8, 0 }, ;
{ "LOGICAL", "L", 1, 0 }, ;
{ "MEMO1", "M", 10, 0 }, ;
{ "MEMO2", "M", 10, 0 } }
REQUEST DBFCDX
dbCreate( "testdbf", aStruct, "DBFCDX", .t., "MYALIAS" )
RETURN NIL
- Status
- Ready
- Compliance
-
- This function is Not CA-Clipper compliant
- Files
-
- Library is rdd Header is Dbstruct.ch
- See Also