>>Can someone tell me what had I done wrong below:
>>
>>select 1
>>use table1
>>
>>select 1
>>append from textfile type delimited with tab
>>
>>
>>use table2 exclusive
>>index on f_fname+f_lname tag lastname
>>
>>select 1
>>
>>scan for .not. seek(f_fname+f_lname, table2)
>> scatter fields like * to t_array
>> select table2
>> append from array t_array
>> release t_array
>>endscan
>>
>>close database
>>use
>>
>>everything going ok on table1 which I can appending the text file. But in table2 I can't append any record over from table1 (table1 is alway empty)
>>
>>Any idea!!
>
>Sam, you're using table2 on top of table1
>try this: before using table2...SELECT 0

Thanks Matt,

But I still don't understand the concept of this. When I use scan for seek('blah') I had select the alias on which the table I'm comparing right. How come, it doesn't seen to compare the index of two tables???