By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,185 Members | 1,420 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,185 IT Pros & Developers. It's quick & easy.

Union query of Foxpro tables returns inconsistent results

P: 2
Configuration:
Windows 2000 sp3
MS Access 2000 (9.0.4402 SR-1)
Visual Foxpro 9.0 detached tables
MS VFP Driver 6.01.6830.01 06/19/2003


For example, a simple query like:
select * from ddwg1
union all
select * from ddwg2


The query retreives a few thousand records but does not return the same result from one execution to the next.

If I first import the same tables then run the union query on the imported tables, results are ok.

I've tried on different tables with similar inconsistent results.

I've tried to reproduce the problem on a second computer with the following config:

Windows XP sp1
MS Access 2000 (same as above)
Visual Foxpro (same as above)
VFP ODBC driver 6.01.8629.01 12/7/1999
which I downloaded from Microsoft

The same setup produces the following message:
[Microsoft][Visual FoxPro Driver]Syntax error. (#200)

I saw somewhere on the internet that a hotfix existed for that problem but could not find it.

If anybody can help, it would be very appreciated.

Germain Catudal
Mar 29 '07 #1
Share this Question
Share on Google+
1 Reply


P: 2
Configuration:
Windows 2000 sp3
MS Access 2000 (9.0.4402 SR-1)
Visual Foxpro 9.0 detached tables
MS VFP Driver 6.01.6830.01 06/19/2003


For example, a simple query like:
select * from ddwg1
union all
select * from ddwg2


The query retreives a few thousand records but does not return the same result from one execution to the next.

If I first import the same tables then run the union query on the imported tables, results are ok.

I've tried on different tables with similar inconsistent results.

I've tried to reproduce the problem on a second computer with the following config:

Windows XP sp1
MS Access 2000 (same as above)
Visual Foxpro (same as above)
VFP ODBC driver 6.01.8629.01 12/7/1999
which I downloaded from Microsoft

The same setup produces the following message:
[Microsoft][Visual FoxPro Driver]Syntax error. (#200)

I saw somewhere on the internet that a hotfix existed for that problem but could not find it.

If anybody can help, it would be very appreciated.

Germain Catudal
Additional Note:

I installed FoxPro on the XP machine and now it gives the same inconsistent results as the Win2K.

Germain Catudal
Mar 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.