ODBC query w/ Access and VFP

[davidcreswell]

Hello:

I am trying to run a union query in a MS Access db with an odbc connection to vfp. The data in both tables have the same format -- they are just diffent years.

SELECT table1.vendor
FROM table1
UNION ALL
SELECT table2.vendor
FROM table2;

This should work, but I don't know why. I am getting the following msgbox.

ODBC – call failed.

[Microsoft][ODBC Visual FoxPro Driver]Syntax error. (#200)

Any help would be appreciated.

Thanks,
David

 

[Mike Lewis]

David,

Maybe it's the semi-colon at the end of the statement. I'm not sure how ODBC would handle that. Might be worth trying again without the semi-colon.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[davidcreswell]

Thanks for the reply Mike...

Taking the semicolon out gives the same message box.

I can run each query separately, and that may be what I have to end up doing right now.

Thanks,
David

 

[Mike Lewis]

David,

I can run each query separately, and that may be what I have to end up doing right now.

It's a pity you have to do that. I wish I could tell you what the problem is, but the syntax looks perfectly correct to me. If you ran the command within VFP, it would work OK.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk