General information
Category:
Coding, syntax & commands
>>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???
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only