Board index » delphi » The clause UNION

Bit

Delphi Developer
Mon, 22 Mar 2004 20:33:00 GMT

The clause UNION

Hi people!

Why this is query execute in SQLServer isn't IB?

Select CODE_PACKING,NULL,NULL from PACKING
union
Select CODE_PACKING,CODE_LOCATION,BALANCE from BALANCE_PRODUCT;

CODE_PACKING is CHAR(10)
COD_LOCATION is CHAR(10)
BALANCE is DOUBLE PRECISION

What is up?

PEACE!!

blz!

Bit

 
Harr

Delphi Developer
Mon, 22 Mar 2004 20:59:53 GMT

Re:The clause UNION


Hi

IB doesn't know what the datatypes of the null-values are.
Cast them to the correct datatypes:
cast(null as char(10)) etc.

Harry

"Bit" <sandro_marq...@ig.com.br> schreef in bericht news:3bbc56f9_2@dnews...

Quote
> Hi people!

> Why this is query execute in SQLServer isn't IB?

> Select CODE_PACKING,NULL,NULL from PACKING
> union
> Select CODE_PACKING,CODE_LOCATION,BALANCE from BALANCE_PRODUCT;

> CODE_PACKING is CHAR(10)
> COD_LOCATION is CHAR(10)
> BALANCE is DOUBLE PRECISION

> What is up?

> PEACE!!

> blz!

> Bit

Other Threads

1. Parameterised queries and UNION clause

2. Memo fields in select clause of union queries

3. using UNION and ORDER BY clauses

4. Interbase equivalent to UNION clause

5. UNION clause in SQL select

6. SQL Union clause (Local SQL)

7. Union clause with paradox tables

8. Possible BUG in LOCAL SQL UNION clause

9. SQL: UNION in SELECT clause

10. UNION clause