> Hi
>
> I just had a strange problem with a query, which I got solved with
> some help from Martijn Tonies.
>
> I got an error message in my appl. and couldn't quite figure it out.
> Whatever I googled said something about stored procedures ....
>
> The SQL that was about to be executed was:
>
> select
> Count(*)
> from ekspedienter
> where
> Ekspedienter.afdeling_ID=:PAfdeling_ID and ekspedienter.nr=99999
>
> Union
>
> Select
> nr,
> navn
> from EkspedienterTilSalg Where
> Afdeling_ID=:PAfdeling_ID and
> UAfd_Navn=:PUAfd_Navn
>
>
> Its not something I generated, but rather IBO doing it internally
> (When doing a MyQuery.RecordCount).
>
> The error that comes up is this:
>
> ISC ERROR CODE : 335544569
> Dynamic SQL Error SQL error code = -104 Invalid command count of
> column list and variable list do not match
>
> In my point of view this error message is a bit wierd.
>
> I ran this query on a FB 1.5.3 and Fb 2.0
>
>
> Regards
> Michael

you can't union 2 select statements where each statement has a different
number of fields or have different data types.
Alan