|Subject||RE: [firebird-support] Error message from an invalid SQL Query|
> Hiyou can't union 2 select statements where each statement has a different
> 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:
> from ekspedienter
> Ekspedienter.afdeling_ID=:PAfdeling_ID and ekspedienter.nr=99999
> from EkspedienterTilSalg Where
> Afdeling_ID=:PAfdeling_ID and
> 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
number of fields or have different data types.