Ignoring a Column

Go Up to Inserting Rows with NULL Column Values

A NULL value is assigned to any column that is not explicitly specified in an INTO clause. When InterBase encounters an unreferenced column during insertion, it sets a flag for the column indicating that its value is unknown. For example, the DEPARTMENT table contains several columns, among them HEAD_DEPT, MNGR_NO, and BUDGET. The following INSERT does not provide values for these columns:

EXEC SQL
INSERT INTO DEPARTMENT (DEPT_NO, DEPARTMENT)
VALUES (:newdept_no, :newdept_name);

Because HEAD_DEPT, MNGR_NO, and BUDGET are not specified, InterBase sets the NULL value flag for each of these columns.

Note: If a column is added to an existing table, InterBase sets a NULL value flag for all existing rows in the table.