Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select slow on tables shared with VFP8
Message
From
28/12/2004 13:18:24
 
 
To
28/12/2004 12:52:00
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972500
Message ID:
00972649
Views:
19
>>Hi Tore,
>>
>>Check CPCURRENT() and CPDBF(). If they don't match, VFP9 won't use indexes on character expressions for optimization.
>>
>>Thanks,
>>Aleksey.
>>
>
>Hi Aleksey,
>
>can you explain more on this argument ?
>
>I read on help:
>
>Visual FoxPro evaluates index expressions by reading character data
>from the table without additional code page translation even when
>current code page (CPCURRENT()) does not match code page tagged to the table (CPDBF())
>in order to produce the same index regardless of the current code page.

>
>Thanks

Hi Fabio,

Which part do you want me to explain?

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform