ubase.addField

Syntax	ubase.addField (fnum, fieldName, fieldType)
Params	fnum is the file refnum identifying the uBASE database that a field will be added to. fieldName is a four-character string that will be used to identify the field. fieldType is the type of the field. See Notes.
Action	Adds a field with the indicated name and type to the database identified by fnum. It is possible to add one or more fields to a database which contains records, but see Notes.
Returns	True if the new field is added successfully, false otherwise.
Examples	To create a database and add a field named 'fld1' to it: fnum = ubase.newFile (path) ubase.addField (fnum, 'fld1', stringType)
Errors	An error is produced if uBASE is not running, if fnum does not identify an open database, or if some problem prevents adding the new field to the database
Platform Notes	uBASE runs only on Mac OS and is not a supported component of Frontier 5.0,
Notes	The possible field types are: booleanType true or false. longType 32-bit signed number. dateType the number of seconds since Jan 1, 1904. stringType a variable length text handle. doubleType double-precision floating point number. binaryType unformatted data, variable-length. In general, its best to add fields to a database before there are any records in it. If a field is added to a database which contains records, ubase.lookupRecord will include an 'errn' entry with a value of 2 and an 'errs' entry in each table it produces for a record which lacks the new field. The errs entry will cause lookupRecord to return false. One solution is to visit each record, do ubase.lookupRecord on that record (ignoring the false result), add an entry for each missing field to the table produced by ubase.lookupRecord, and add the completed record to the database replacing the old record. [Consider copying the data from your existing database to a new database which has the additional fields, rather than adding fields to a database which contains records.]
See Also	ubase.getField ubase.lookupRecord