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
Go raibh maith agat
~M