>Hi there,
>
>I am having a problem when searching a table by unique key. I am using the scatter gather method to update the table. Basically the program will update if the record is found and add it if it isn't. When I APPEND BLANK and then try to Gather the records, it tells me EOF is encountered. HELP!!!!
>
>
>Jolene Dicks
The record pointer is getting moved between the APPEND BLANK and GATHER MEMVAR. IMO, it is not a good idea to use this method. Look at the INSERT INTO and UPDATE - SQL commands in help. These commands will not have the problem you describe and are faster.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer