Subject RE: [IBO] column list & variable list do not match
Author Jason Wharton
It could also be something INTERNAL going on in the database.
Check triggers and stored procedures, etc. that could be impacted.
Show us the SQL trace may help.

Jason

> -----Original Message-----
> From: Ryan Nilsson-Harding [mailto:scronkey@...]
> Sent: Thursday, November 18, 2004 4:29 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] column list & variable list do not match
>
> > Just occurred to me: Is this the actual message you are getting?
> >
> > "column list & variable list do not match" (ex Subject)
>
> Yes, this is the actual message.
> Maybe the clue lies in the whole error message:
> ---------------------
> Dynamic SQL Error
> SQL Error Code = -104
> Invalid command
> count of column list and variable list do not match
> Code = 335544569
> Statement:
> "<TApplication>.frmGlobSrchRep.qry.IBOqrqry"
> ---------------------
>
> > This message occurs in the course of executing a SP, when
> there is a
> > mismatch between the column list in a [FOR] SELECT....INTO
> :<LIST OF
> > VARIABLES> and the list of variables that you are feeding
> them into.
>
> Nope, no SP involved at all. Just pure DSQL.
> 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.
> Still happening.
>
> 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?
>
> Agghhh...
> 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)
> -Ryan