>>>>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

I did, but it still give me an error