AddRecord()
Summary
Adds a record to a table and sets the current record.
Syntax
record_handle = AddRecord(string view_name, array values)
| Argument | Contents |
|---|---|
| view_name | The name of the view containing the table |
| values | An array of name-value pairs that contain field names and values |
Returns
The record handle (string) for the new record.
Notes
-
You cannot add records to a view that is part of a joined view.
-
By default, all fields of the new record contain missing values. The values array can be used to specify non-missing field values for one or more fields.
-
Use AddRecord() or AddPoint() to add points to a standard point (.DBD) geographic file or a point Oracle Spatial layer.
-
You can also use AddRecord() to add records to a non-geographic database.
-
Use AddLink() to add records to a standard line (.DBD) geographic file or a line Oracle Spatial layer.
-
Use AddNode() to add records to the node layer of a line geographic file,
-
The values array is identical in format to that returned by GetRecordValues().
-
AddRecords() is much faster than repeated calls to AddRecord() when a block of records is added at one time.
Example
rh = AddRecord("Employees", {
{"LNAME", "Smith"},
{"FNAME", "Peter"},
{"PAYRATE", 10.75},
{"YOB", 1948}
})Error Codes
| Error Type | Meaning |
|---|---|
| Error | Invalid values in the values array; the input view does not allow addition of new records (e.g., some types of joined views and aggregate views, ODBC tables); or error writing to file (e.g., a required file is read-only, or there is not enough disk space.) |
| NotFound | The specified view, or some of the specified fields, does not exist |
See Also
| Function | Summary |
|---|---|
| AddRecords() | Adds one or more records to a table and sets the current record |
| DeleteRecord() | Deletes a record from a view |
| GetRecordValues() | Reads the values of one or more fields for a record in a view |
| SetRecordValues() | Updates the data for a record in a view |