DBCreate(database-name, num-fields, field-list, overwrite-flag)

You can use DBCreate to create a new database. DBCreate requires four parameters: the name of the database, the number of fields, a container containing a field list, and "true" or "false" (true if you don't want FileFlex to overwrite a data file).

Each line of the field list container is used for a field. Each line contains the following information: name of field, type of field, length, and number of decimal places (for numeric fields).

The type of field parameter may be one of the following:

• 'N': Numeric
• 'C': Character
• 'B': Boolean
• 'M': Memo
• 'D': Date
• 'B': Binary
• 'F': Float
• 'G': General

In FileFlex 2, you could also use the FileFlex Database Designer. The Database Designer is obsolete in FileFlex 3. In FileFlex 3, you can create a new database using FoxPro (recommended), Access (specify FoxPro format), or programmatically, using DBCreate or DBCreateAuto.

DBCreate has been modified so it works properly with the safety functions and actually matches how the manual describes it (this was not the case in earlier versions...hey, we get better with age!) FileFlex now recognizes "true" or "t" in the safety field as an instruction to prevent overwriting the database and "false" or "f" as an instruction to allow overwriting.

put DBCreate("FRIENDS",6, dbFields,"false") into dbResult