DEF DATABASE ROW

General Form:

[PRIVATE | PUBLIC ] DEF DATABASE ROW recordname
FLD fldname [ = packspec]
...
END RECORD

Where:

packspec = string expression | sym expression

A DEF DATABASE ROW is a special form of DEFRECORD. This syntax creates a special DEFRECORD that is flagged as representing a database row. This can then be used by kc and kviewinfo to optimize the columns fetched back when using SQL databases.

At runtime a DEF DATABASE ROW performs exactly as a DEFRECORD definition would.

Example

// full details of the employee
DEF DATABASE ROW employee
	FLD empno = "UINT(4)"		// clock number
	FLD ename$ = "CHAR(30)"		// employee name
	FLD esalary = "UNUM(7,2)"		// monthly salary
	FLD elist$(10)_ELIST	// attributes
END RECORD
DIM ebuf$_employee_view

Compatibility

DEF DATABASE ROW was introduced in KCML 6.60.