hi,
thank you verey much for every thing, it's ok now.
thanks again.
>>hi,
>>thank you for reply,
>>NUM field is numeric type(5,0),
>>how i can get SP1 for VFP9 ,
>>
>> ok ,i try as under, still the same.
>>
>>insert INTO mstr ;
>> Select * From main2 Where ;
>> DtoS(file_date) + DtoS(intervdate)+Str(num, 5) Not In ;
>> (Select DtoS(file_date) + DtoS(intervdate)+Str(num, 5) ;
>> From mstr)
>>
>>
>>thanks.
>>
>
>The link to download Service Pack 1 for Visual FoxPro 9 is:
>
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=1C06E35D-10A2-4A05-84FC-495B3A73ECF7&displaylang=en>
>And you have indexes in both tables on the exact expression?
>
>Instead of using one insert command do it into 2 steps (here I think it may help). First select records into cursor
>
>Select * From main2 Where ;
> DtoS(file_date) + DtoS(intervdate)+Str(num, 5) Not In ;
> (Select DtoS(file_date) + DtoS(intervdate)+Str(num, 5) ;
> From mstr) into cursor curInsert nofilter
>
>insert into Mstr select * from curInsert