Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement returns a jumbled table
Message
 
 
To
09/04/2002 18:35:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00642023
Message ID:
00642950
Views:
21
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform