Question Dynamic Buffer Compare

[Tarun213706]

How do we compare dynamic tables in progress .? And how do we store the result into a character variable .?I would appreciate if any one can provide me with any sample code snippet.

Thanks

 

[Osborne]

This is a simple example of a BUFFER-COMPARE for dynamic tables:

DEFINE VARIABLE hBufferDestination AS HANDLE NO-UNDO.
DEFINE VARIABLE hBufferSource AS HANDLE NO-UNDO.
 
CREATE BUFFER hBufferDestination FOR TABLE "Sports2000.Customer".
CREATE BUFFER hBufferSource FOR TABLE "Sports.Customer".
 
IF NOT hBufferSource:BUFFER-COMPARE(hBufferDestination) THEN
   MESSAGE "The records are different." VIEW-AS ALERT-BOX INFORMATION.
 
DELETE OBJECT hBufferDestination.
DELETE OBJECT hBufferSource.

From the manual though, I do not think the BUFFER-COPY method will help for what you want:

This method does a rough compare of any common fields, determined by name, data type, and extent-matching, between the source buffer and the target buffer. The resulting logical value is either TRUE or FALSE as a whole. A single field that does not compare causes the entire buffer to return FALSE. If there are fields in one buffer that do not exist in the other, they are ignored.