Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Not optimized
Message
 
 
To
15/02/2010 14:06:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01449210
Message ID:
01449220
Views:
52
Try
*and Left (RecordType,2) # 'AP'
and NOT RecordType LIKE 'AP%'
>The following is very slow, presumably because of my use of IN
Select * From KTrackTagDetail							;
>	where (Seqno In (Select Seqno From C_Kits)			;
>	or SeqnoFG In (Select Seqno From C_Kits))			;
>	and Left (RecordType,2) # 'AP'						;
>	into Cursor C_Detail
>So, how can I speed this up?
>
>Thanks
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform