Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Let select more faster
Message
From
06/06/2006 05:01:10
 
 
To
06/06/2006 04:17:17
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01127280
Message ID:
01127287
Views:
9
hi Metin,
thank you for reply.
i try as under but the same time,
USE main2 
select main2                 
INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO ll 

USE mstr 
select mstr                 
INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO tt
insert INTO mstr ;
 Select * From main2 Where ;
  DtoS(file_date) + DtoS(intervdate)+Str(num) Not In ;
   (Select  DtoS(file_date) + DtoS(intervdate)+Str(num) ;
    From mstr)
thanks.
>Hi Muhammed,
>
>Did you try create indexes with "DtoS(file_date) + DtoS(intervdate)+Str(num)" both of two files?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform