Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select slow on tables shared with VFP8
Message
De
28/12/2004 13:18:24
 
 
À
28/12/2004 12:52:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00972500
Message ID:
00972649
Vues:
23
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform