hi,
Are your data fields numeric data type ? yes
sorry,numbers always be 8 in SOURCE and 7 in INTERVIEWED ?
i get error message, Command is missing required clause for this line
INDEX ON MOD(fixed_line,1000000) && For Numeric field
thanks.
>Are your data fields numeric data type or are they character fields containing numbers?
>Will the lengths of the numbers always be 7 in INTERVIEWED and 6 in SOURCE? If that is true you can try
>CLOSE ALL
>USE interviewed
>INDEX ON MOD(fixed_line,1000000)
>INDEX ON SUBSTR(fixed_line,2)
>
>
>SELECT 0
>USE source
>SET RELATION TO fixed_line INTO interviewed
>REPLACE ALL flag1 WITH interviewed.flag1 FOR FOUND('interviewed')
>
>
>
>
>>hi all,
>>
>>i try to compare between 2 tables via field(fixed_line) at 2 tables
>>
>>but source.dbf have fixed_line as 7 numbers, and another table have fixed_line as 6 numbers,
>>i need to to begin from second number from source.dbf
>>
>>as 8524163 begin form 524163.
>>
>>CLOSE all
>>
>>USE INTERVIEWED in 0
>>INDEX on fixed_line TO ll
>>USE source in 0
>>INDEX on fixed_line TO hh
>>
>>
>>
>>replace IN source ;
>> FOR fixed_line==LOOKUP(INTERVIEWED.fixed_line,fixed_line,INTERVIEWED.fixed_line) AND NOT EOF('INTERVIEWED') ;
>> flag1 with INTERVIEWED.flag1
>>
>>thanks.