Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select statement returns a jumbled table
Message
 
 
À
09/04/2002 18:35:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00642023
Message ID:
00642950
Vues:
22
This message has been marked as the solution to the initial question of the thread.
I was able to reproduce your problem by checking "Fetch Data In Background" in DSN options. W/o "Fetch Data In Background" checked the code runs fine. After that I found mskb #Q269881 'PRB: Problems with Visual FoxPro Driver "Fetch Data In Background" Option'.
Anyway, uncheck that option and your problem should go away.

>Sergey,
>
>Did you run it without the index on the table, because you will only get the problem when the index is *NOT* on the table.
>
>This is a list of system I have tried it on so far(all with your same version of the ODBC driver):
>
>1. Celeron 1000 Mhz, 256MB RAM, Windows ME 4.90.3000, IE 6, VFP 7 SP1
>2. Duron 866Mhz, 256 MB RAM, Windows XP, IE 6, VFP 7 SP 1
>3. Athlon 800Mhz, 256Mb RAM, Windows XP, IE 6, VFP 7 SP 1
>4. Duron 800Mhz (Same as No. 2 but with a completely fresh Windows 2000 SP2 installation)
>5. Pentium II 266Mhz, 128Mb RAM, Windows 2000 SP 2, Office XP etc.
>
>Al machines run Office XP or Office 2000, Norton Antivirus 2001 (In disabled mode) - Except No. 4 which is completely blank.
>
>In case No.4 and 5, VFP wasn't even installed, only the runtimes were placed in the same folder as the test program and run from there.
>
>There is one machine that doesn't show the problem, it is the same as No. 5 but it has the Asian Language Pack installed aprt from that nothing different.
>
>Would you mind giving me a bit of details on your config so maybe we can setup a machine that doesn't get the problem ?
>
>Cheers,
>
>Chris Ormerod
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform