5861king
(Fresh Scripter)
2007-11-21 12:20 AM
SQL UNION

I have useing kix to do some SQL stuff and for some reason it does not like the union statement when running from kix, however work fine in the Microsoft SQL Query Manager. My question is does it support the UNION command?

TIA

5861king

NTDOCAdministrator
(KiX Master)
2007-11-21 01:34 AM
Re: SQL UNION

Let's see the code you're using and what version of KiXtart please.

Richard H.Administrator
(KiX Supporter)
2007-11-21 10:12 AM
Re: SQL UNION

The quick answer is that no, of course KiXtart doesn't support UNION, as it is not a SQL processor.

SQL feature support is provided (usually) by the ODBC driver or database connection automation object.

If you are using the same connection method for both KiXtart and SQL query manager then the same SQL features will be supported.

Post your KiXtart code to the "Advanced" forum for review, and restrict your SQL query to the simplest non-working example.

5861king
(Fresh Scripter)
2007-11-21 10:47 AM
Re: SQL UNION

o.k. will post in the advance section, just on other quick question does this also apply to the DISTINCT Satetment aswell.

Running Kix 4.60