Page 1 of 1 1
Topic Options
#182835 - 2007-11-21 12:20 AM SQL UNION
5861king Offline
Fresh Scripter

Registered: 2006-09-28
Posts: 48
Loc: UK
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

Top
#182837 - 2007-11-21 01:34 AM Re: SQL UNION [Re: 5861king]
NTDOC Administrator Offline
Administrator
*****

Registered: 2000-07-28
Posts: 11623
Loc: CA
Let's see the code you're using and what version of KiXtart please.
Top
#182850 - 2007-11-21 10:12 AM Re: SQL UNION [Re: NTDOC]
Richard H. Administrator Offline
Administrator
*****

Registered: 2000-01-24
Posts: 4946
Loc: Leatherhead, Surrey, UK
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.

Top
#182853 - 2007-11-21 10:47 AM Re: SQL UNION [Re: Richard H.]
5861king Offline
Fresh Scripter

Registered: 2006-09-28
Posts: 48
Loc: UK
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

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
2 registered (morganw, mole) and 415 anonymous users online.
Newest Members
gespanntleuchten, DaveatAdvanced, Paulo_Alves, UsTaaa, xxJJxx
17864 Registered Users

Generated in 0.051 seconds in which 0.022 seconds were spent on a total of 13 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org