>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
try
INSERT INTO (ALIAS()) FROM MEMVAR