Field_Overlap_Offset_Start, Field_Overlap_Offset_End

Obsolete

Overlap columns were replaced by multi-segment relationships in DataFlex 11.0 and are obsolete.

 

Define begin- and end column of an overlap column.

Supported By

SQL Drivers (SQL Server, DB2 and ODBC)

Value

1 .. Length of a row in the table

Associated Attributes

DF_FIELD_LENGTH (Integer)

DF_FIELD_OFFSET (Integer)

Remarks

The Field_Overlap_Offset_Start and Field_Overlap_Offset_End keywords are used to define an overlap column. An overlap column is a logical column that overlaps multiple underlying real columns. The keywords are set to the offset in the row of the columns that are overlapped. These keywords can be used to create so-called "underlaps".

The Field_Overlap_Offset keywords are not supported in Structure operations. If you perform a restructure operation on a table with underlaps, they will be forced to complete overlap by the Structure_End logic.

Please note that every back-end has its own rules for offsets and field lengths. Using the same settings in DataFlex and SQL servers can result in different overlaps. Be sure to check if the overlap definition is correct.

See the discussion on the Field_Overlap_Start and Field_Overlap_End keywords for more information on inserting overlaps and the consequences for other column’s numbers.

See Also

Column Keywords