>>>>>Is there a reason that you are not using "INSERT INTO tablename ..." to add records?
>>>>
>>>>Hi Larry, have not heard from you in a while...
>>>>I am using APPEND BLANK with table buffering, is it preferably to use INSERT INTO with table buffering?
>>>>:)))))
>>>
>>>insert into is preferrable almost all the time
>>
>>especially assuming multiple manipulations with buffering, etc.:)
>...yeah...what they said! //:^)
>Still having problems with the dups. I know that there are bugs using table buffering. I dont recall specifically what they are, but nevertheless I dont like table buffering because it consumes a lot of network and work station resources (from what I understand). Unless you are adding multiple records (child records) that may need to be "undone" then you should try to stay with record buffering. //:^)
I took care of the dups.. In the UNLOAD event, I coded:
scan empty(field_name)
blank
delete
endscan

When I add, I scan for deleted() and recall.
Just like to you showed me... :))))))