Does the Sql Server ODBC not support unions ?

[Karen99]

I am using D7 and Sql Server 2000. I use BDE components and connect through the ODBC.

I have a TQuery where my sql statement looks like this :

Select cola
from taba
union
Select colb
from tabb

I get a error that this cappability is not supported. Does the Sql Server ODBC not support unions ? Why not ? How do I get around this. I know ADO work, but the application I am working on is already a few years old and everything is in BDE. Would be to big a job to change everything to ADO.

Any suggestions ?

Karen

 

[Karen99]

Is everybody still on holiday !!!????

 

[towerbase]

You haven't stated what the error message actually says but I think it is the BDE that doesn't support unions.

I don't have SQL Server so I can't verify this.

Andrew
Hampshire, UK

 

[Karen99]

Well, the same query works through the BDE with Paradox. It is just strange that it will work with Paradox and not Sql Server.

Error message is :

Project IMQS.exe raised exception class EDBEngineError with message 'Capability not supported Token: UNION'