>>>Hi all,
>>> I currently try to append a text file to my database by using append from command. My problem is I want to check to see is there any duplicate record by compare the person lastname and firstname from the text file with my database. However, I can't read the variable in the text file as a field!! Any ideas on how to read the fields in a text file which delimited by |.
>>
>>probably two steps -- read text file into temp file, then
>>
>>scan temp file
>>if not seek('mainfile',fname+lname)
>>insert into mainfile.....
>>else
>>loop
>>endif
>>endscan
>
>Hi Dave,
>
>I had try your idea, however when I use the seek command it gives me "alias not found" error. Is that because of the 'mainfile' (which is a table) cannot be found in my pc?? Also, I though the seek command can only search for the index key of specific table??

use the name of your database as mainfile