Par2: Duplicate() 1999-01-28 -- Scott Ferret The DUPLICATE() statement has two states. If you do a GET(file,0) before calling DUPLICATE() it tests if the current record buffer would fail on an ADD() call. If no GET(file,0) is issued it tests if a PUT() would fail. The only one of these options that work with SQL systems is the ADD test. It also works when doing the PUT test for the primary key. The PUT test fails if you have a primary key and another unique key and you are changing the component of the unique (but non-primary) key. Printed May 13, 2024, 3:19 am This article has been viewed/printed 35116 times. |