Progress
Language Reference


BUFFER-COPY Statement

Interfaces
OS
SpeedScript
All
All
Yes

Performs a bulk copy of a source record to a target record by copying each source field to the target field of the same name. You can specify a list of fields to exclude from the bulk copy, or a list of fields to include in the bulk copy. You can also specify WHEN...THEN phrases. For each such phrase, BUFFER-COPY executes the THEN portion if the corresponding WHEN portion evaluates to TRUE.

SYNTAX

BUFFER-COPY source [ { EXCEPT | USING } field ... ]
  TO target [ ASSIGN assign-expression ... ] [ NO-ERROR ] 

source

The source database table, buffer, temporary table, or work table.

EXCEPT field ...

A list of space-separated source fields to exclude from the bulk copy.

USING field ...

A list of space-separated source fields to include in the bulk copy. The USING option is simply a positive version of the EXCEPT option.

TO target

The source database table, buffer, temporary table, or work table.

ASSIGN assign-expression

A space-separated list of any valid Progress 4GL ASSIGN statements (without the EXCEPT option, which BUFFER-COPY already provides). BUFFER-COPY performs each assign-expression and automatically excludes the field on the left side (“destination”) of each assign-expression from the bulk copy-except for field extents (subscripted fields). If a field extent appears on the left side of an assign-expression, BUFFER-COPY does not automatically exclude that extent (such as customer.mnth-sales[1]) or the field as a whole (such as customer.mnth-sales) from the bulk copy.

NO-ERROR

Diverts any error messages from this statement to the ERROR-STATUS system handle and records the success of this statement in ERROR-STATUS:ERROR

NOTES

SEE ALSO

BUFFER-COMPARE Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095