|Subject||Re: [firebird-support] Error message from an invalid SQL Query|
> >selectHmm... something along the lines of
> > Count(*)
> >from ...
> This says that the query should return one column of type integer (or
> then you do
> > Union
> > Select
> > nr,
> > navn
> > from ...
> this is two columns that have to be put into the one integer column
> above. That's impossible, hence 'count of column list and variable list
> do not match'. Mind you, I certainly wouldn't object if it was changed
> to something like 'incorrect number of columns specified' or similar,
> but I'm generally not all too unhappy with this error message.
"Incorrect number of columns in parts of UNION query" would be better,
As Michael said, all he could find (with Google) had to do with
Stored Procedures, given that there's where you use variables.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!