>hi all,
>I have a program with two tables. one is a history table and the other is a live table. i have a history routine that copies any information from the live table into the historical one that is over 3 months old. both are identical and have a primary key. i extract a subset of the live file into a cursor and then check the historical file to see if the record is ther already. if it is it deletes the record and then i do
>

>append blank
>GATHER MEMVAR memo
>

>append blank fails as it violates the uniqueness of the table. i have set dele on. can i do this another way that avoids this problem?
>Slán
>~M

If an exception is thrown after append blank and before gather memvar memo it indicates to me that there is a record with a "blank" PK in the history table. So check your history table to make sure you don't have any rows with "blank" PK.

If the exception is thrown after the gather memvar memo then it means that the new record that you are appending has a PK value that already exists in the history table.