Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What have they done to VFP9 querying?
Message
 
 
À
23/08/2005 08:44:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01042667
Message ID:
01042874
Vues:
25
>
>I did find that (just after posting here, natch) but although it explains the issue, I couldn't find any pointers to solutions or workarounds.
>
>For instance, I thought, OK, if I test CPCURRENT and find it doesn't match CPDBF, then why not simply issue a "CODEPAGE=CPDBF()" and run the query as usual. Tried it, got a marginal improvement, (knocked the 17 down to 10 seconds) but still not a patch on the original vfp8 speed.
>
>Presumably the answer to the absence of the problem with ref to date fields is because both vfp8 and 9 deal with dates the same way regardless of codepages.


Only character/memo fields are affected by codepage translation.

>There also seems to be some dispute as to whether it is a bug or the result of a bug fix! One way or another, we obviously need a fix for it or a lot of our clients and users are going to be very peed off!

The confusion comes from the fact that this change wasn't documented in VFP9 help.
You have to change table codepage to the current codepage if you want Rushmore to work. If you want to convert data to the current codepage, use COPY TO command. If you want to change codepage only, use cpzero.prg from VFP Tools\Cpzero subdirectory.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform