|Subject||Re: [IBO] column list & variable list do not match|
> Just occurred to me: Is this the actual message you are getting?Yes, this is the actual message.
> "column list & variable list do not match" (ex Subject)
Maybe the clue lies in the whole error message:
Dynamic SQL Error
SQL Error Code = -104
count of column list and variable list do not match
Code = 335544569
> This message occurs in the course of executing a SP, when there is aNope, no SP involved at all. Just pure DSQL.
> mismatch between the column list in a [FOR] SELECT....INTO :<LIST OF
> VARIABLES> and the list of variables that you are feeding them into.
The only other times I've seen this error is from SP's, so that is
what I was looking into first.
I have explicitly cast all 7 fields in each set so they are identical.
It just doesn't make sense (which prolly means that it's simple & I'm
just looking too deep)
I have no variables in this query. No params.
Just to be sure I compared the field & param counts on both queries.
Both queries have fields = 7 & params = 0
Another strange thing is that when I cut & paste the query directly
into the TIBQuery on the report in design mode, then open it, then
preview it, I get no error & see the correct result set.
Also, (runtime) the error occurs after the rep.Preview statement. Not
after the .Open statement.
repQry.qry.Open; <-- No problem
repQry.qr.Preview; <-- Error twice here, then displays correctly
So is it a TQuickRep problem? If so, then why can I preview it in
design mode with the identical query?
I have red spot on my forehead from banging my desk, and my hair is
patchy in places from pulling at it...
OTBOI (On The Brink Of Insanity)