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.
This is a simple example of a BUFFER-COMPARE for dynamic tables:
Code:
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.