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